Spire.XLS rows limitation

[thiyagarajans]

Hi,

Xlsx has a limitation of 1,048,576 rows per sheet. How Spire.XLS will behave when generating excel with more than 1,048,576 rows? Will it split and generate another worksheet or workbook?

Regards
Thiya

[Abel.He]

Hello,

Thanks for your inquiry.
When you insert more than 1,048,576 rows data into worksheet, there will throw exception in program.

Sincerely
Abel
E-iceblue support team