Copy Worksheets
Contents
[
Hide
]
Migration Tip:
\1. Create Workbook object and get Worksheet. \2. Insert text in worksheet. \3. Create new Worksheet and Copy it to previous before made worksheet.
VSTO
Error rendering macro ‘code’ : Invalid value specified for parameter lang
Aspose.Cells
private static string fileName ="CopyWorksheets.xlsx";
Workbook newWorkbook = new Workbook();
Worksheet worksheet = newWorkbook.Worksheets.Add("New Sheet");
Cells cells = worksheet.Cells;
cells[0, 0].PutValue("Some Text");
Worksheet worksheet2 = newWorkbook.Worksheets.Add("MySheet");
worksheet2.Copy(worksheet);
newWorkbook.Save(fileName);