Support for Int32 or more than 65536 rows

Apr 6, 2011 at 2:11 PM

I have run into an issue where the user base has moved on and are using Microsoft Office 2010. They are sending me data in XML format that I am programatically changing with NPOI to Exel.xls files. Some of these XML files are not reaching over 400Mbytes in size and contain multiple sheets with multiple headers and different colomns. I've acommodated everything to this point.

Having said that. I am now encountering individual sheets that are exceeding 65536 rows. In some instances there are over 100,000 rows per sheet.

Is anyone working on an upgrade to change the source to use Int32 for Rows Vs. Int16?

If not, has anyone developed a work around that does not involve breaking the sheets into mulitple sheets?

Coordinator
Apr 8, 2011 at 12:04 AM
Edited Apr 8, 2011 at 12:11 AM

65536 rows is by design, it's the maximum row for xls (at least for Excel 2003), which is stated in Microsoft BIFF format spec. I didn't see any xls document exceeds 65535 rows. As I know, only xlsx supports individual sheet exceeding 65535 but not xls. 

For office 2007/office 2010 formats, I suggest you take a look at OpenXML SDK 2.0. http://www.microsoft.com/downloads/en/details.aspx?FamilyId=C6E744E5-36E9-45F5-8D8C-331DF206E0D0&displaylang=en.