Data cant be read when number of rows is more than 14000

Aspose.Cells Product Family
1

Hi,

I have 2 excel file with 12000 rows and 24000 rows. When i try to manupulate this 12000 rows file it execute properly but when i try to execute 24000 rows, it doesnt work. Here i use a asp.net upload control and a GridView. Whenever I click on file upload, then it doesnt work.

What shoul i do now?

Mamun

2

Hi,

Well, Aspose.Cells can create or open huge files without any problem.

Following is my sample code which works fine. The file generated file size is more than 11MB.

Workbook workbook = new Workbook();
Worksheet ws = workbook.Worksheets[0];
for (int row=0;row<25000;row++)
{
for (int col =0;col< 18; col++ )
{
ws.Cells[row,col].PutValue(row.ToString() + "," + col.ToString());

}
}
workbook.Save("E:\\tst_Aspose.xls");


And here is the code to open this huge file ans save it as after some manipulation. It also works fine.

Workbook workbook = new Workbook();
workbook.Open("E:\\tst_Aspose.xls");
Worksheet ws = workbook.Worksheets[0];
ws.Cells["A25000"].PutValue("Testing");
workbook.Save("E:\\tst_Aspose_new.xls");

Is the output file (generated and manipulated by Aspose.Cells) rendered fine or not. Could you check whether it is the problem with Upload control.

Thank you.