Free Support Forum - aspose.com

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

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

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.