256 columns limitation on XLS.CellExport?

Technical support for Spire.DataExport

Moderators: iceblue support, DataExport, Manager

256 columns limitation on XLS.CellExport?

Postby andre.berg@prevas.se » Fri Sep 14, 2012 12:43 pm


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;


Posts: 1
Joined: Fri Sep 14, 2012 12:11 pm

Re: 256 columns limitation on XLS.CellExport?

Postby amy.zhao » 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,
e-iceblue support
User avatar
Posts: 2241
Joined: Wed Jun 27, 2012 8:50 am

Return to Spire.DataExport

Who is online

Users browsing this forum: No registered users and 0 guests