Spire.XLS 8.8.0.6040 InsertDataTable

[xudong]

Hi,
Is that function InsertDataTable only can insert less than 255 columns?
I turn to try function InsertColumn(1, 1024), Exception thrown.

I that Spire.xls has limitation of max column and row ?

[Nina.Tang]

Hello,

Thanks for your inquiry.
When using the code "Workbook book = new Workbook();" to create a new Excel file, it would create an Excel file with version 2003 by default, and the Excel 2003 or below has a limitation of 256 columns. To avoid it, please declare the version to be 2007 or above like below code. If there is any question, welcome to write back.

Code: Select all

Workbook book = new Workbook();
book.Version = ExcelVersion.Version2007;
...


Sincerely,
Nina
E-iceblue support team

[xudong]

Thank you for your response.

[Nina.Tang]

Hi,

Thanks for your response.
If you encounter issues while using our product, just feel free to contact us.
Wish you all the best!

Sincerely,
Nina
E-iceblue support team