I'd like to know how to use openpyxl to get the displayed value of a cell. I'm using 2.5.6 to read a xlsx file that contains a cell with a date, using the data_only=True option I'm successfully getting:
value: 2018-01-12 00:00:00 (datetime object)
number format: yyyy"-"mm"-"dd
The displayed value in LibreOffice is '2018-01-12'. How to get it?
I'm willing to code if the issue can be fixed in openpyxl.
On the search previous to opening this issue, I found that the formatting functionality might not fit in the openpyxl library, in that case, is there any ongoing effort to have an external library that will do the job?