Export (0) Print
Expand All

Worksheets.Add method

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Object Add(
	Object Before,
	Object After,
	Object Count,
	Object Type
)

Parameters

Before
Type: System.Object

Optional Object. An object that specifies the sheet before which the new sheet is added.

After
Type: System.Object

Optional Object. An object that specifies the sheet after which the new sheet is added.

Count
Type: System.Object

Optional Object. The number of sheets to be added. The default value is one.

Type
Type: System.Object

Optional Object. Specifies the sheet type. Can be one of the following XlSheetType constants: xlWorksheet, xlChart, xlExcel4MacroSheet, or xlExcel4IntlMacroSheet. If you are inserting a sheet based on an existing template, specify the path to the template. The default value is xlWorksheet.

Return value

Type: System.Object

If Before and After are both omitted, the new sheet is inserted before the active sheet.

Community Additions

ADD
Show:
© 2014 Microsoft