Add Method

Add a sheet to the Excel document.

Syntax

Sub Add(sheetName)


Parameters


sheetName

Type: String

The name of the sheet to add



Return Value


None

Examples

IronPython

#Add a sheet

doc = VSExcelDocument("D:\Data\Tabular.Transaction.Header.xlsx", FileMode.Open)

doc.Add("new sheet")

doc.SaveAs("D:\Data\Temp\myCopy.xlsx")


C#

//Add a sheet

VSExcelDocument doc = new VSExcelDocument(@"D:\Data\Tabular.Transaction.Header.xlsx", FileMode.Open);
doc.Add("new sheet a");
doc.SaveAs(@"D:\Data\Temp\myCopy2.xlsx");

Remarks