Create and Save New Workbooks
Contents
[
Hide
]
Migration Tips:
\1. Create Workbook object \2. Get current Worksheet. \3. Insert some text in any cell. \4. Save the Workbook.
VSTO
Below is 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 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);