Size limitations in creating excel sheets

Sep 22, 2016 at 4:08 PM
Hi all

I am considering this library for creating excel sheets in C# code. I wonder if there are any size limitations in how many rows can be generated in an xls sheet. I have been using excellib which is rather old, there I get memory problems when creating sheets with more than 200 thousand rows. Files that might be 100 - 200 Mb. should not be a proplem. I did it with CSV files, but I want to use regular xls sheets to preserve the numerical precision in the data.