Using sql-server: Export excel from c# – date modification on newest questions tagged sql-server – Stack Overflow

In sql there is a record in the format:

2012-06-13 08:30:00.000

When I export it to Excel, it appears in this format:

2012-07-18T08:30:00+03:00

How can I fix it?

I use MSSQL. Here is the c# code: (I use RKLib.ExportData component)

int[] iColumns = { 0, 1, 2, 3, 4, 5, 6 };

RKLib.ExportData.Export objExport = new RKLib.ExportData.Export("Web");

Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentEncoding = System.Text.Encoding.GetEncoding("windows-1254");
Response.Charset = "windows-1254";

objExport.ExportDetails(dt, iColumns, RKLib.ExportData.Export.ExportFormat.Excel, "exceldocument.xls");

See Answers


source: http://stackoverflow.com/questions/11466069/export-excel-from-c-sharp-date-modification
Using sql-server: using-sql-server



online applications demo