Free Support Forum - aspose.com

Aspose Cells only saving 15-330 out of 30-000 rows

I have a large excel file I am createing with 30,000 rows. when I save the excel file it only saves 15,330 rows.

How do I get all 30,000 rows to save.

Thanks,

Michael Hobbs
mhobbs@comuterdesigns.com

Hi Mike,

I don't find the problem, you have mentioned. Which version of Aspose.Cells for .NET you are using.

I tried the latest version (4.4.3) and it works fine. Following is my testing code and attached is the resultant file.

Code:

Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];
Cells cells = worksheet.Cells;

for(int row=0;row<30000;row++)
{

for(int col = 0;col<8;col++)
{

cells[row,col].PutValue("Row" + row.ToString()+ " " + "Col" + col.ToString());

}

}

workbook.Save("d:\\test\\out_testedworkbook.xls");

Thank you.