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

CreateAsposeCellsFile() private static method

private static CreateAsposeCellsFile ( string filename_in, string filename_out ) : void
filename_in string
filename_out string
return void
        private static void CreateAsposeCellsFile(string filename_in, string filename_out)
        {
            DateTime start = DateTime.Now;
            string designerFile = filename_in;
            Workbook workbook = new Workbook(designerFile);
            for (int i = 0; i < 100; i++)
            {
                Worksheet ws = workbook.Worksheets[i];
                ws.Cells[0, 0].PutValue("Data" + i.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
LoadLargeExcelScenario1