I am trying to export a datatable where i have multiple columns of datatype 'Datetime'
I have added code in the event
private void cellExport1_GetDataParams(object sender, Spire.DataExport.EventArgs.DataParamsEventArgs e)
{
if (e.Col == 3)
{
e.FormatText = "yyyy-mm-dd hh:mm:ss";
}
}
but when looking in the excel sheet the column is formatted as yyyy-mm-dd 00:00:00.
I know for a fact that the column contains a time different from 00:00:00.
Could you please help me with this formatting issue.
Steen Christiansen
Seapay Aps
Denmark