Hi,
I am trying to export a datatable to Excel using the XLS.CellExport. Everything seems to work fine but when i open the created xls file it opens in a protected view and only shows 256 columns? Is there a limitation? Or something I have missed. Code see below:
Spire.DataExport.XLS.CellExport cellExport1;
cellExport1 = new Spire.DataExport.XLS.CellExport();
cellExport1.DataFormats.CultureName = "sv-SE";
cellExport1.DataFormats.DateTime = "yyyy-MM-dd HH:mm:ss";
cellExport1.DataFormats.Float = "#,###,##0.00";
cellExport1.DataFormats.Integer = "#,###,##0";
cellExport1.DataFormats.Time = "HH:mm";
cellExport1.DataTable = data.Tables[0];
cellExport1.DataSource = Spire.DataExport.Common.ExportSource.DataTable;
cellExport1.SaveToFile("c:\\Export.xls");
Regards
André