Exporting data in TimeSpan format

Reply

windCollector Posted: Tue, May 26 2009 5:51 AM

rated by 0 users

Hi all,

I have a DataTable which has  data type timespan, when I export this value to excel it is exported as string

I use the following style

  styTimespan.Format = XLStyle.FormatDotNetToXL("hh:mm:ss", Type.GetType("System.TimeSpan"));

Thanks all for any help

regards

Reply

C1_RaleighJ replied on Thu, May 28 2009 8:10 AM

rated by 0 users

 Hello,

For the formatting to take place, the value being exported cannot be a string.  Try exporting the value as a Timespan rather than a string.  I hope this helps.

-Raleigh