Spire.DataExport for .NET is a 100% pure data .NET library suit for exporting data into MS Word, Excel, RTF, Access, PDF, XPS, HTML, XML, Text, CSV, DBF, SYLK, SQL Script, DIF, Clipboard, etc.

Tue Apr 14, 2009 11:05 am

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

Posts: 4
Joined: Tue Aug 19, 2008 8:32 am

Return to Spire.DataExport