SpreadsheetSaveOptionsInsertAsNewWorksheet Property
Boolean flag, which specifies whether edited worksheet should replace the existing worksheet in original spreadsheet on the position, specified by the WorksheetNumber property, or it should be injected between existing worksheet and previous one, without replacing its content. By default is false — existing worksheet will be replaced. This property is ignored, if value of WorksheetNumber property is set to '0'.

Namespace: GroupDocs.Editor.Options
Assembly: GroupDocs.Editor (in GroupDocs.Editor.dll) Version:
public bool InsertAsNewWorksheet { get; set; }

Property Value

Type: Boolean
By default worksheet is replaced. This means that if given spreadsheet has 5 worksheets, and WorksheetNumber=4, then 4th worksheet will be replaced with the new edited worksheet, while the total amount of worksheets in spreadsheet (5) will remain untouched. However, if value of this property is set to true, the new edited worksheet will be injected as 4th worksheet, and all subsequent worksheets will be shifted to the end: "old" 4th worksheet becomes 5th, and 5th becomes 6th, and the total amount of worksheets in spreadsheet will be incremented by one and equal to 6.
See Also