I'm having a strange issue when I'm trying to read an excel into a dataframe. The excel, that is provided daily, comes with a format R1C1 (meaning the columns are with numbers in spite of letters). With this format, when I try to read the file, the following error is raised: invalid literal for int() with base 10: 'E' I think the error must be that because as soon as I open the file and disallow the R1C1 style, the code works fine and read the file. How do I avoid this issue? The idea is loading the file automatically everyday. Continue reading...
