Reading wrongly formatted cells

Aug 12, 2014 at 9:38 AM
Hello everyone! I have been reading a lot around my issue but I am still struggling to get an idea how to go around it. Any help would be appreciated!

I am reading an Excel spreadsheet that can contain wrongly formatted data, e.g. a cell could be formatted as a date but in Excel appears normally- as a string as it contains a string. When I read it with the Excel data reader it appears as 31/12/1899. How can I just get the value of the string as displayed in Excel?

Thanks!
Developer
Aug 27, 2014 at 9:20 AM
I've created this issue for discussion over on github
https://github.com/ExcelDataReader/ExcelDataReader/issues/15