Excel.InsertWorksheetOptions interface
The options that define which worksheets to insert and where in the workbook the new worksheets will be inserted.
Remarks
Properties
position |
The insert position, in the current workbook, of the new worksheets. See |
relative |
The worksheet in the current workbook that is referenced for the |
sheet |
The names of individual worksheets to insert. By default, all the worksheets from the source workbook are inserted. |
Property Details
positionType
The insert position, in the current workbook, of the new worksheets. See Excel.WorksheetPositionType
for details. The default position is "End".
positionType?: Excel.WorksheetPositionType | "None" | "Before" | "After" | "Beginning" | "End";
Property Value
Excel.WorksheetPositionType | "None" | "Before" | "After" | "Beginning" | "End"
Remarks
relativeTo
The worksheet in the current workbook that is referenced for the WorksheetPositionType
parameter. The default is null
. If the relativeTo
parameter is not set, worksheets will be inserted based on positionType
, at the start or end of the current workbook.
relativeTo?: Worksheet | string;
Property Value
Excel.Worksheet | string
Remarks
sheetNamesToInsert
The names of individual worksheets to insert. By default, all the worksheets from the source workbook are inserted.
sheetNamesToInsert?: string[];
Property Value
string[]
Remarks
Office Add-ins