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[]