SpreadsheetSaveOptions Class
Allows to specify custom options for generating and saving Spreadsheet (Excel-compliant) documents
Inheritance Hierarchy
SystemObject
  GroupDocs.Editor.OptionsSpreadsheetSaveOptions

Namespace: GroupDocs.Editor.Options
Assembly: GroupDocs.Editor (in GroupDocs.Editor.dll) Version: 21.6.0.0
Syntax
public sealed class SpreadsheetSaveOptions : ISaveOptions

The SpreadsheetSaveOptions type exposes the following members.

Constructors
  NameDescription
Public methodSpreadsheetSaveOptions
Creates a new instance of SpreadsheetSaveOptions with specified mandatory Spreadsheet output format, while all other parameters are default
Properties
  NameDescription
Public propertyInsertAsNewWorksheet
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'.
Public propertyOutputFormat
Allows to specify a Spreadsheet format, which will be used for saving the document
Public propertyPassword
Allows to specify, modify, obtain, or remove a password, which will be used to encode the generated Spreadsheet document, if tis document format supports password protection. Specify NULL or empty string for removing (cleaning) the password.
Public propertyCode exampleWorksheetNumber
Allows to insert edited worksheet into copy of existing spreadsheet instead of creating a new single-worksheet spreadsheet (default behavior). WorksheetNumber is a 1-based number of a worksheet in the spreadsheet, loaded in the Editor class. If it is 0 (default value), the new spreadsheet will be created with single edited worksheet. If it is greater or lesser then zero, and there is valid spreadsheet, loaded in the Editor class, the edited worksheet, that is represented by input EditableDocument instance, will be inserted into this spreadsheet.
Public propertyWorksheetProtection
Allows to enable a worksheet protection for the output Spreadsheet document. By default is NULL - protection is not applied. Not all formats support a worksheet protection.
See Also