Re: openpyxl reads cell with format

On 6/5/2017 4:55 PM, Gregory Ewing wrote: Mahmood Naderan wrote: from a button on a web page, I chose "export as excel" to download the data. Do you get an option to export in any other format? CSV would be best, since you can trivially read that with Python's csv module. If Excel is the

Re: openpyxl reads cell with format

Mahmood Naderan wrote: from a button on a web page, I chose "export as excel" to download the data. Do you get an option to export in any other format? CSV would be best, since you can trivially read that with Python's csv module. If Excel is the only format available, you should complain to

Re: openpyxl reads cell with format

On 05/06/17 16:46, Mahmood Naderan wrote: >> if the cell is an Excel date, it IS stored as a numeric > > As I said, the "shape" of the cell is similar to date. The content which is > "4-Feb" is not a date. It is a string which I expect from cell.value to read > it as "4-Feb" and nothing else. >

Re: openpyxl reads cell with format

OK thank you very much. As you said, it seems that it is too late for my python script. Regards, Mahmood On Monday, June 5, 2017 10:41 PM, Dennis Lee Bieber wrote: On Mon, 5 Jun 2017 14:46:18 + (UTC), Mahmood Naderan via Python-list

Re: openpyxl reads cell with format

>if the cell is an Excel date, it IS stored as a numeric As I said, the "shape" of the cell is similar to date. The content which is "4-Feb" is not a date. It is a string which I expect from cell.value to read it as "4-Feb" and nothing else. Also, I said before that the file is downloaded from

openpyxl reads cell with format

Hello guys... With openpyxl, it seems that when the content of a cell is something like "4-Feb", then it is read as "2016-02-04 00:00:00" that looks like a calendar conversion. How can I read the cell as text instead of such an automatic conversion? Regards, Mahmood --