Spire.DataExport for .NET is a 100% pure data .NET library suit for exporting data into MS Word, Excel, RTF, Access, PDF, XPS, HTML, XML, Text, CSV, DBF, SYLK, SQL Script, DIF, Clipboard, etc.

Fri Sep 14, 2012 12:43 pm

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é

andre.berg@prevas.se
 
Posts: 1
Joined: Fri Sep 14, 2012 12:11 pm

Mon Sep 17, 2012 7:40 am

Dear André,

Thanks for your inquiry.
We need to affirm that the xls file show 256 columns or 256 rows? There is a limitation for rows if you don't purchase our products. If the xls file show 256 columns, could you provide us a sample datatable which more than 256 columns? So that we can reproduce your problem and solve it quickly. Thanks.

Thanks and Regards,
Amy
e-iceblue support
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Return to Spire.DataExport