Aspose.Cells.Examples.CSharp.KnowledgeBase.Benchmarking.CreateAnExcelFileSingleWorksheet.CreateAsposeCellsFile C# (CSharp) Method

CreateAsposeCellsFile() private static method

private static CreateAsposeCellsFile ( string filename ) : void
filename string
return void
        private static void CreateAsposeCellsFile(string filename)
        {
            DateTime start = DateTime.Now;
            Workbook workbook = new Workbook();
            Worksheet ws = workbook.Worksheets[0];
            for (int row = 0; row < 10000; row++)
            {
                for (int col = 0; col < 30; col++)
                {
                    ws.Cells[row, col].PutValue(row.ToString() + "," + col.ToString());
                }
            }
            workbook.Save(filename);
            DateTime end = DateTime.Now;
            TimeSpan time = end - start;
            Console.WriteLine("File Created! \n" + "Time consumed (Seconds): " + time.TotalSeconds.ToString());
        }
        // ExEnd:1
CreateAnExcelFileSingleWorksheet