Storing data in excel as date format when downloading excel file

[vidyashviram]

Hi,
I want to store value for a particular column in date format.

Below is the column in my workbook:
<Workbook.Column label="lastUpdatedDate" value="lastUpdatedDate" />

How can I store this 'LastUpdatedDate' as date value when we download the excel file?
The values are getting stored as text.The column values should come as 'date' instead of 'general' so that we can sort according to dates for that column.
Thanks

[tgoyer]

I used this to build dynamic Excel exports that had arbitrary columns.

{Data != null && ( <Workbook filename={Data.Name + " Export.xlsx"} element={ <Button color="primary" className={classes.subHeaderButton}> <i className="far fa-file-excel"></i> Excel Data Export </Button> }> <Workbook.Sheet data={formatExcelData(Data)} name={Data.Name}> {getExcelColumnMap().map(d => <Workbook.Column key={d.index} value={d.key} label={d.value} />)} </Workbook.Sheet> </Workbook> )}

getExcelColumnMap generated the list of columns and formatExcelData took care of Boolean/Date/Number/Currency/etc formatting.