Is there any row limit for excel using BIFF?

Question

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.

Answer 1

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

Answer 2

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