changing the cell format to date

ggreen86 / XLSX-Workbook-Class

VFP Class to Create an XLSX Workbook without Excel Automation or Installed

45 stars 16 forks source link

changing the cell format to date #26

Closed smartcrmKandel closed 4 years ago

smartcrmKandel commented 5 years ago

Hi, how can I format cells on a certain column according to the data type in the grid I am exporting. I would like to export an date column but in Excel it ist formatted asn 'standard'.

Best regards

ggreen86 commented 4 years ago

This is now being added to Release 32 (upcoming) for the save grid method (Ex version) to obtain the xlsx column formatting from the grid columns.