Re: Exporting data in TimeSpan format

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

 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