Class JsonSaveOptions

Class JsonSaveOptions

Namespace: Aspose.Cells
Assembly: Aspose.Cells.dll (25.2.0)

Represents the options of saving the workbook as a json file.

public class JsonSaveOptions : SaveOptions

Inheritance

objectSaveOptionsJsonSaveOptions

Inherited Members

SaveOptions.m_SaveFormat, SaveOptions.SaveFormat, SaveOptions.ClearData, SaveOptions.CachedFileFolder, SaveOptions.ValidateMergedAreas, SaveOptions.MergeAreas, SaveOptions.CreateDirectory, SaveOptions.SortNames, SaveOptions.SortExternalNames, SaveOptions.RefreshChartCache, SaveOptions.WarningCallback, SaveOptions.CheckExcelRestriction, SaveOptions.UpdateSmartArt, SaveOptions.EncryptDocumentProperties, object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()

Constructors

JsonSaveOptions()

Creates options for saving json file.

public JsonSaveOptions()

Properties

AlwaysExportAsJsonObject

Indicates whether always exporting excel to json as object, even there is only a worksheet in the file.

public bool AlwaysExportAsJsonObject { get; set; }

Property Value

bool

ExportArea

Gets or sets the exporting range.

public CellArea ExportArea { get; set; }

Property Value

CellArea

ExportAsString

Exports the string value of the cells to json.

public bool ExportAsString { get; set; }

Property Value

bool

ExportEmptyCells

Indicates whether exporting empty cells as null.

public bool ExportEmptyCells { get; set; }

Property Value

bool

ExportHyperlinkType

Represents the type of exporting hyperlink to json.

public JsonExportHyperlinkType ExportHyperlinkType { get; set; }

Property Value

JsonExportHyperlinkType

Remarks

The default value is Aspose.Cells.Json.JsonExportHyperlinkType.DisplayString;

ExportNestedStructure

Exported as parent-child hierarchy Json structure.

public bool ExportNestedStructure { get; set; }

Property Value

bool

HasHeaderRow

Indicates whether the range contains header row.

public bool HasHeaderRow { get; set; }

Property Value

bool

Indent

Indicates the indent.

public string Indent { get; set; }

Property Value

string

Remarks

If the indent is null or empty, the exported json is not formatted.

Schemas

The original json schema of each worksheet.

public string[] Schemas { get; set; }

Property Value

string[]

SheetIndexes

Represents the indexes of exported sheets.

public int[] SheetIndexes { get; set; }

Property Value

int[]

SkipEmptyRows

Indicates whether skipping emtpy rows.

public bool SkipEmptyRows { get; set; }

Property Value

bool

ToExcelStruct

Indicates whether converting to json struct of the Excel file.

public bool ToExcelStruct { get; set; }

Property Value

bool

Remarks

Only for converting range to JSON.