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
-
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
-
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
-
kylie.tian
-
- Posts: 412
- Joined: Mon Mar 07, 2022 2:30 am