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?