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
Recent Comments