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
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 automate copy and paste from a website to Excel?
Yes, it can, however that functionality is only available in Excel...
How do I import JSON into Excel 2016?
I am trying to import a JSON file into Excel from a URL. I...