export to xls: date not in date format

[santoz]

Hello,

I'm doing an export to excel but my date is not displayed as a date.
the correct date is in there but as a number. If i change the properties of the field, i will get the correct date. How can i fix this?

[code]
Spire.DataExport.XLS.CellExport exp = new Spire.DataExport.XLS.CellExport();
exp.DataFormats.CultureName = "nl-NL";
exp.DataFormats.Float = "#,###,##0.00";
[b]exp.DataFormats.DateTime = "dd-MM-yyyy";[/b]
exp.DataFormats.Currency = "

[DataExport]

Hello,

You need to add getParams event to CellExport component,
Try to using following source code,

Code: Select all

  private void cellExport1_GetDataParams(object sender, Spire.DataExport.EventArgs.DataParamsEventArgs e)
        {
            if (e.Col == 1)
            {
                e.FormatText = "YYYY-MM-DD";
            }
        }