Posted 3 August 2017, 6:16 am ESTHi Data Dynamics support,
I am using the SpreadBuilder class to export report in excel.Now my requirement is to shift number of records to next sheet if it exits the Ms-Excel 2007 limit of rows in a sheet(i.e 10,48,576 ).Now I put a Row Counter to check if it is beyond 10,48,576 then it will shift rest of the records to next sheet and so on.But it is giving a run-time error if Row Counter goes beyond 65,536. It means if I reduce the value from 10,48,576 to 65,536 to trigger a sheet change then it works fine.
<b>[Error Message:-The specified iColumn argument is either less than zero or greater than the maximum number of columns that the Excel file format supports.
Parameter name: iRow]
My Question is "Does SpreadBuilder class internally uses the Ms-97-2003 standard to generate excel?"