GrapeCity.Documents.Excel.SjsSaveOptions

SjsSaveOptions Class

Represents options for saving a workbook as a SpreadJS .sjs file.

Use this class to control which workbook content is included when exporting to .sjs, such as styles, formulas, unused names, empty cells outside the used range, binding sources, automatically merged cells, and data outside the defined row and column counts.

Inheritance

object

SaveOptionsBase

SjsSaveOptions

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public class SjsSaveOptions : SaveOptionsBase

Public Class SjsSaveOptions
    Inherits SaveOptionsBase

Examples

worksheet.Range["A1"].Value = "Name";
SjsSaveOptions options = new SjsSaveOptions();
options.IncludeStyles = false;
string json = workbook.ToSjsJson(options);
workbook.Save("path/to/output.sjs", options);

Constructors

Name	Description
SjsSaveOptions()	Constructor.

Properties

Name	Description
IgnoreRangeOutOfRowColumnCount	Gets or sets whether data outside the worksheet `RowCount` and `ColumnCount` is ignored when exporting to an .sjs file. The default value is false. When this property is false, data outside the specified row and column count is still exported to the .sjs file.
IncludeAutoMergedCells	Gets or sets whether to include automatically merged cells when saving a file. The default value is false.
IncludeBindingSource	Gets or sets whether to include the binding source when saving the file. This option controls whether bound data is exported when the workbook is saved to SpreadJS `.sjs` format. The default value is true.
IncludeEmptyRegionCells	Gets or sets whether empty cells outside the used data range are included when saving to an SJS file. The default value is true.
IncludeFormulas	Gets or sets whether formulas can be included when saving the file. The default value is true.
IncludeStyles	Gets or sets whether styles are included when saving files. This option controls whether style information is written when exporting to the SpreadJS `.sjs` format. The default value is true.
IncludeUnusedNames	Gets or sets whether unused custom names are included when saving the file. This property applies when exporting to the SpreadJS `.sjs` format. The default value is true.