Writing a date cell to open in Excel 2016 #904
Labels
No Label
DBF
Dates
Defined Names
Features
Formula
HTML
Images
Infrastructure
Integration
International
ODS
Operations
Performance
PivotTables
Pro
Protection
Read Bug
SSF
SYLK
Style
Write Bug
good first issue
No Milestone
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: sheetjs/sheetjs#904
Loading…
Reference in New Issue
Block a user
No description provided.
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Hi,
I am using version 0.11.10 of the library and was looking for an example of writing a date cell (or column) to xls file which can then be opened by Excel 2016.
Having converted the workbook out using XLSX.utils.aoa_to_sheet and then written it out using XLSX.write, I can see that the underlying XML has set the cell with type DateTime. However, when I open the file using Excel 2016, the cell is automatically formatted as a number.
Separately I have created a date cell in Excel, saved the file and examined the underlying XML. It would appear to set a Styles element at the beginning and then set the cell with the appropriate StyleID attribute. How can the same be achieved using the library?
Any help with this would be much appreciated.
Thanks.
Do you see the same issue with the XLSX or XLSB formats?