Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.
Fri Aug 24, 2018 9:18 am
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 ?
-
xudong
-
- Posts: 5
- Joined: Tue Jul 03, 2018 3:19 am
Fri Aug 24, 2018 10:30 am
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
-
Nina.Tang
-
- Posts: 1187
- Joined: Tue Sep 27, 2016 1:06 am
Mon Aug 27, 2018 3:05 am
Thank you for your response.
-
xudong
-
- Posts: 5
- Joined: Tue Jul 03, 2018 3:19 am
Mon Aug 27, 2018 3:09 am
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
-
Nina.Tang
-
- Posts: 1187
- Joined: Tue Sep 27, 2016 1:06 am