Copy Worksheets

Migration Tip:

\1. Create a Workbook object and get a Worksheet.
\2. Insert text in the worksheet.
\3. Create a new Worksheet and copy it to the previously created 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);

Download

  • GitHub