This project is read-only.
6
Vote

Excel Lite throws error when working with Large set of data (49000 rows)

description

Excel Lite seems to throw the below error when we try to save excel data with 49000 rows, the error details is given below
 
Error:Specified argument was out of the range of valid values. Parameter name: SATSectorIndex
 
Stack Trace: Lite.ExcelLibrary.CompoundDocumentFormat.MasterSectorAllocation.GetSATSectorID function
 
I have debugged using the Source code, it seems that the error gets thrown from the below function.
 
    public int GetSATSectorID(int SATSectorIndex)
    {
        if (SATSectorIndex < NumberOfSecIDs)
        {
            return MasterSectorAllocationTable[SATSectorIndex];
        }
        else if (SATSectorIndex == NumberOfSecIDs)
        {
            return AllocateSATSector();
        }
        else
        {
            throw new ArgumentOutOfRangeException("SATSectorIndex");
        }
    }
 
It seems that a condition arises when working with large data- SATSectorIndex becomes greater than the NumberOfSecIDs.
 
Please let me know your comments regarding this issue. We tried to export by reducing the number of rows, then it worked fine. Is there any way that this issue can be solved or any workaround for this issue.

comments

marshallhp wrote Jul 23, 2013 at 1:33 AM

I'm finding it can only output about 7041kb files.

Keen to see if there may be a fix

ozcan_avtat wrote Jul 31, 2013 at 3:28 PM

wrote Nov 5, 2013 at 7:44 AM