Hi Laurence,
Our company is looking for a component to work with Office, especially Excel, we’d like to know the performance like writing values to 1000 or 10000 cells, before further action.
Do you have some test and test result for Aspose Cells? Thank you.
Best Regards
Mike Zhang
Hi Mike,
Aspose.Cells runs very fast for 10000 cells. I made a simple program in my laptop. It filled 10000 cells in less than 0.5 seconds.
DateTime start = DateTime.Now;
Workbook wb = new Workbook();
Cells cells = wb.Worksheets[0].Cells;
for (int i = 0; i < 1000; i++)
{
for (int j = 0; j < 10; j++)
cells[i, j].PutValue(i + 100 * j);
}
wb.Save("c:\\testperform.xls");
DateTime end = DateTime.Now;
TimeSpan span = end - start;
Console.WriteLine(span.TotalSeconds);
My laptop has a 1.8G dual-core CPU and 2GRAM.