How do I read a dynamic Excel file in Python?
I have data that is sent to me in an excel file, but it seems to be dynamic (ie. Just change based on the current date). How can I make the data in the excel sheet are easily modifyable when I open the file?
I am using Pandas, but have also tried with Tkinter. If you could point me in the right direction that would be greatly appreciated! A great User Guide to reading custom excel files (Templates) is provided in Read Excel Files. This applies to MS Excel but will work so long as the format of your file remains similar.
If you see a 'd' alternatively to each cell, you should see a normal excel cell (ie the d will be stripped). Alternatively, If you have access to MS Excel, I'd recommend saving your file as OpenXML (.xlsx). This is the native Microsoft format for Excel and is compatible with most programming languages. It'll be much easier to use the build in datatype handling too.
Related Answers
How can I open a PDF file in Excel for free?
How to Convert PDF to Excel for Free. Convert PDF to Exce...
Why won't macros work in Excel on Mac?
Macro (aka VBA) can be used to execute code automatically in Excel. This...
How do I write to an existing Excel file in Python?
Let's take a step back. In this post, we'll write a simple Python script...