JsonExportSettings
Provides configuration settings that control how a JsonFormatProvider exports a Workbook to JSON.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.FormatProviders.Json
Assembly:Telerik.Windows.Documents.Spreadsheet.FormatProviders.Json.dll
Syntax:
public class JsonExportSettingsInheritance: objectJsonExportSettings
Constructors
public JsonExportSettings()Properties
Gets or sets how chart data should be represented (only references, only resolved values, or both).
public ChartDataMode ChartDataMode { get; set; }Gets or sets which portion of the workbook will be exported (entire workbook, only the active sheet, or only a selection of ranges).
public ExportWhat ExportWhat { get; set; }Gets or sets a value indicating whether the name of the active worksheet is exported in the metadata section.
public bool IncludeActiveSheet { get; set; }Gets or sets a value indicating whether blank cells within the used range of a worksheet should be explicitly output.
When false blank cells are skipped to reduce JSON size.
public bool IncludeBlankCells { get; set; }Gets or sets a value indicating whether charts in the exported worksheets are serialized.
public bool IncludeCharts { get; set; }Gets or sets a value indicating whether per-series statistical aggregates (min, max, average, sum, standard deviation, count) are included for chart data.
public bool IncludeChartStats { get; set; }Gets or sets a value indicating whether a human-readable summary string is generated for each chart.
public bool IncludeChartSummaries { get; set; }Gets or sets a value indicating whether a simple trend classification (increasing / decreasing / flat) is exported for eligible series.
public bool IncludeChartTrends { get; set; }Gets or sets a value indicating whether defined names (named ranges / constants) are exported.
public bool IncludeDefinedNames { get; set; }Gets or sets a value indicating whether hidden worksheets are included when ExportWhat is EntireWorkbook.
public bool IncludeHiddenSheets { get; set; }Gets or sets a value indicating whether cell number formats (format codes other than General) are emitted.
public bool IncludeNumberFormats { get; set; }Gets or sets a value indicating whether the workbook protection flag (IsProtected) is included.
public bool IncludeWorkbookProtectionFlag { get; set; }Gets or sets a value indicating whether the JSON output should be indented (pretty printed) for readability.
public bool PrettyPrint { get; set; }Gets the collection of ranges to export when ExportWhat is Selection. If the collection is empty the active worksheet is exported instead.
public List<CellRange> SelectedRanges { get; }Gets or sets how cell values are rendered in the export (raw underlying value, formatted display value, or both).
public ValueRenderMode ValueRenderMode { get; set; }