Jul-23-2020, 08:25 PM
Hi all,
Wonder if someone could point me in the right direction for a little problem I have. I have written a Python script which converts an Excel document (and all worksheets within said Excel document) into a UTF8 CSV file. The problem I have is the output is coming out raw, i.e. not as it 'appears' in the Excel sheet.
For example, one of the fields is a 'Timestamp' field (displayed as 07/23/2020 21:00). However my output once converted to a csv is something like '4250.12345678'. Likewise, there are many numeric values present, presented in the Excel document as '0', '50' etc. Again, once converted these are coming out as '0.0', '50.0'.
Is there anyway I can output the data in the format that it is shown in Excel?
Thank you.
Wonder if someone could point me in the right direction for a little problem I have. I have written a Python script which converts an Excel document (and all worksheets within said Excel document) into a UTF8 CSV file. The problem I have is the output is coming out raw, i.e. not as it 'appears' in the Excel sheet.
For example, one of the fields is a 'Timestamp' field (displayed as 07/23/2020 21:00). However my output once converted to a csv is something like '4250.12345678'. Likewise, there are many numeric values present, presented in the Excel document as '0', '50' etc. Again, once converted these are coming out as '0.0', '50.0'.
Is there anyway I can output the data in the format that it is shown in Excel?
Thank you.