# Settings The [JsonFormatProvider](https://www.telerik.com/document-processing-libraries/documentation/libraries/radspreadprocessing/formats-and-conversion/json/jsonformatprovider) exposes an `ExportSettings` property of type `JsonExportSettings`. The settings control the behavior of the [JsonFormatProvider](https://www.telerik.com/document-processing-libraries/documentation/libraries/radspreadprocessing/formats-and-conversion/json/jsonformatprovider) when exporting a [Workbook](https://www.telerik.com/document-processing-libraries/documentation/libraries/radspreadprocessing/working-with-workbooks/working-with-workbooks-what-is-workbook) to JSON. By adjusting the available properties, you can tailor the size, richness, and focus of the generated JSON payload. ## Properties | Property | Type | Default | Description | | ------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------- | -------------------------------------------------------------------------------------------------- | | `ExportWhat` | [ExportWhat](https://www.telerik.com/document-processing-libraries/documentation/libraries/radspreadprocessing/formats-and-conversion/json/jsonexportsettings#enum-values) | EntireWorkbook | Portion of the workbook to export (entire workbook, active sheet, or selection). | | `IncludeHiddenSheets` | bool | false | Include hidden worksheets when exporting the entire workbook. | | `IncludeDefinedNames` | bool | true | Export defined names (named ranges / constants). | | `IncludeNumberFormats` | bool | true | Emit number format codes for formatted cells. | | `IncludeCharts` | bool | true | Serialize chart objects from exported sheets. | | `ChartDataMode` | [ChartDataMode](https://www.telerik.com/document-processing-libraries/documentation/libraries/radspreadprocessing/formats-and-conversion/json/jsonexportsettings#enum-values) | ReferencesOnly | Control chart data representation: only reference formulas, only resolved literal values, or both. | | `PrettyPrint` | bool | false | Indent JSON output for readability. Disable to reduce size. | | `ValueRenderMode` | [ValueRenderMode](https://www.telerik.com/document-processing-libraries/documentation/libraries/radspreadprocessing/formats-and-conversion/json/jsonexportsettings#enum-values) | Display | Export raw underlying values, formatted display values, or both. | | `IncludeBlankCells` | bool | false | Emit blank cells explicitly within the used range. Otherwise they are skipped. | | `IncludeWorkbookProtectionFlag` | bool | true | Include workbook protection state (Workbook.IsProtected). | | `IncludeActiveSheet` | bool | true | Emit the name of the active worksheet in metadata. | | `SelectedRanges` | List\ | empty | Ranges to export when ExportWhat is Selection. Empty collection falls back to active sheet. | | `IncludeChartStats` | bool | true | Include min, max, average, sum, stdev, and count aggregates for chart series. | | `IncludeChartSummaries` | bool | true | Include natural language summary strings per chart. | | `IncludeChartTrends` | bool | true | Include simple trend classification (increasing / decreasing / flat) for eligible series. | ### Enum Values **ExportWhat** | Value | Description | | ---------------- | ------------------------------------------------- | | `ActiveSheet` | Exports only the currently active worksheet. | | `EntireWorkbook` | Exports all worksheets in the workbook. (Default) | | `Selection` | Exports only the currently selected cell ranges. | **ChartDataMode** | Value | Description | | ---------------- | ---------------------------------------------------------- | | `ReferencesOnly` | Only formula/reference expressions are exported. (Default) | | `ResolvedValues` | Only resolved literal value arrays are exported. | | `Both` | Both references and resolved value arrays are exported. | **ValueRenderMode** | Value | Description | | --------- | -------------------------------------------------- | | `Raw` | Underlying raw cell value is exported. | | `Display` | Formatted display value is exported. (Default) | | `Both` | Both raw and display representations are exported. | ## Basic Usage The following example shows how to create a `JsonExportSettings` instance with the desired settings while exporting a [Workbook](https://www.telerik.com/document-processing-libraries/documentation/libraries/radspreadprocessing/working-with-workbooks/working-with-workbooks-what-is-workbook) to JSON format: **Import a workbook, configure JsonExportSettings, and export formatted JSON output** ```C# Workbook workbook; XlsxFormatProvider xlsxFormatProvider = new XlsxFormatProvider(); using (Stream input = new FileStream("inputFile.xlsx", FileMode.Open)) { workbook = xlsxFormatProvider.Import(input, TimeSpan.FromSeconds(10)); } string jsonOutputPath = "outputFile.json"; JsonFormatProvider jsonFormatProvider = new JsonFormatProvider(); JsonExportSettings jsonExportSettings = new JsonExportSettings { ExportWhat = ExportWhat.EntireWorkbook, IncludeWorkbookProtectionFlag = true, IncludeNumberFormats = true, IncludeActiveSheet = true, IncludeBlankCells = true, ValueRenderMode = ValueRenderMode.Raw, PrettyPrint = true, IncludeHiddenSheets = true, ChartDataMode = ChartDataMode.ReferencesOnly, IncludeCharts = true, IncludeChartStats = true, IncludeChartSummaries = true, IncludeChartTrends = true, IncludeDefinedNames = true }; jsonFormatProvider.ExportSettings = jsonExportSettings; using (Stream output = new FileStream(jsonOutputPath, FileMode.Create)) { jsonFormatProvider.Export(workbook, output, TimeSpan.FromSeconds(10)); } ``` ## See Also * [JsonFormatProvider](https://www.telerik.com/document-processing-libraries/documentation/libraries/radspreadprocessing/formats-and-conversion/json/jsonformatprovider) * [Timeout Mechanism](https://www.telerik.com/document-processing-libraries/documentation/knowledge-base/timeout-mechanism-in-dpl)