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 onl
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 t
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.
>
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
declaimed the following:
>>if the cell is an Ex
>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
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
--
https://mail.python.org/
