Is there any row limit for excel using BIFF?

456 views Asked by At

I have a code to export my data grid to excell using BIFF4. The problem is it cant accept rows beyond 65536. I asuume it is because the row index is word and it is of 2 bytes. Is there any way i could write more than the available row count? any workaround is possible? any help will be appreciated.

2

There are 2 answers

0
Tony Qu On

In Excel 97-2003, the row limit is 65535 per sheet. It should be the default BIFF row limit.

0
Aviva M. On

If you have to use BIFF, the best thing to do is split the data into multiple sheets.