private static void CreateAsposeCellsFile(string filename_in, string filename_out)
{
DateTime start = DateTime.Now;
Workbook workbook = new Workbook(filename_in);
for (int i = 0; i < 100; i++)
{
Worksheet ws = workbook.Worksheets[i];
Cells cells = ws.Cells;
cells.InsertRows(0, 100);
for (int r = 0; r < 100; r++)
{
cells[r, 0].PutValue("This is testing row #: " + r.ToString());
}
}
workbook.Save(filename_out);
DateTime end = DateTime.Now;
TimeSpan time = end - start;
Console.WriteLine("File Updated! \n" + "Time consumed (Seconds): " + time.TotalSeconds.ToString());
}
// ExEnd:1