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.

Tue Aug 16, 2022 4:46 pm

Hi, Is it possible to use Spire.XLS to download 200k plus rows from a datatable ?

Your response will be much appreciated.

Thanks.

Obiajulu
 
Posts: 2
Joined: Tue Aug 16, 2022 4:37 pm

Wed Aug 17, 2022 6:40 am

Hi,

Thank you for your inquiry.
Our Spire.XLS supports importing data from datatable to Excel, please refer to the tutorials on our website: Export Datatable to Excel from Database. If you have any questions, please feel free to contact us.

Sincerely,
Kylie
E-iceblue support team
User avatar

kylie.tian
 
Posts: 412
Joined: Mon Mar 07, 2022 2:30 am

Wed Aug 17, 2022 7:03 am

Hi Good Morning

I tried using the sample code from your tutorial to download 200 k rows
But it only downloaded 65k rows.

Can you please explain this ?

Thanks

Obiajulu
 
Posts: 2
Joined: Tue Aug 16, 2022 4:37 pm

Fri Aug 19, 2022 10:18 am

Hi,

Since our Spire.XLS creates an new instance of Workbook, the default version is Excel 2003, and it has a limitation of 65536 rows. I suggest you refer to the code below to declare the version to be 2007 and try it out. If you have any questions, please feel free to contact.
Code: Select all
            Workbook book = new Workbook();
            book.Version = ExcelVersion.Version2007;
            //...
            //...

Sincerely,
Kylie
E-iceblue support team
User avatar

kylie.tian
 
Posts: 412
Joined: Mon Mar 07, 2022 2:30 am

Fri Sep 23, 2022 7:12 am

Hi,

Greetings from E-iceblue.
Has your problem been effectively solved now? Could you give us some feedback at your convenience?

Sincerely,
Kylie
E-iceblue support team
User avatar

kylie.tian
 
Posts: 412
Joined: Mon Mar 07, 2022 2:30 am

Return to Spire.XLS