Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
I am exporting an array to excel sheet, when I try to export more than 5000 rows from an array to excel then I am getting an out of memory exception. The number of columns here is 49, so totally it comes to 5000 * 49 = 2, 45, 000 records.
While searching for a work around, in appose forum some experts suggested to use new version of the aspose dll (Please go through the out of memory exception if I try to export above 5500 rows. Here is the piece of code that I used for export functionality.
'Array used for exporting the data
Dim aAttcode As Array
'Code for setting size of an array
aAttcode = sheet.Cells.ExportArray(0, 0, dsans.Tables(0).Rows.Count, dtques.Rows.Count)
'Fill array with the data from data table
For iIndex1 = 0 to dsans.Tables (0).Rows.Count – 1
aAttcode.SetValue (sSting, iIndex1, iCurrentColumn)
Loop
'Exporting the data from array to excel sheet
sheet.Cells.ImportTwoDimensionArray (aAttcode, 0, 0)
I am getting the error when I try to export the two dimensional array to excel sheet. Is there any other way to export more rows from an array into excel sheet, in our requirement, it should be able to export 12000 rows (12,000 * 49 =. 5, 88,000)?
Regards