Create and Save New Workbooks

Migration Tips:

1. Create a Workbook object.
2. Get the current worksheet.
3. Insert some text in any cell.
4. Save the workbook.

VSTO

Below is a code example for VSTO

  Excel.Workbook newWorkbook = this.Application.Workbooks.Add();

  Excel.Worksheet worksheet = newWorkbook.ActiveSheet;

  Excel.Range cells = worksheet.Cells;

  cells.set_Item(1, 1, "Some Text");

  newWorkbook.Save();

Aspose.Cells

Below is a code example for Aspose.Cells

  Workbook newWorkbook = new Workbook();

  Worksheet worksheet = newWorkbook.Worksheets.Add("New Sheet");

  Cells cells = worksheet.Cells;

  cells[0, 0].PutValue("Some Text");

  newWorkbook.Save(fileName);

Download

• GitHub