JsonFormatProvider
The JsonFormatProvider (introduced in Q4 2025) makes it easy to export Workbook data to a structured JSON representation. Unlike the other text-based providers (CSV / TXT), the JSON export can include richer metadata such as number formats, named ranges, chart data and workbook level flags. Currently the provider is Export-only.
The provider also exposes an ExportSettings property, that allows you to control the export behavior.
Prerequisites
To use the JsonFormatProvider class you need to reference the following NuGet package:
- Telerik.Windows.Documents.Spreadsheet.FormatProviders.Json
Export
The following example demonstrates how to import an existing Workbook and export it to a JSON file using the default settings.
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();
using (Stream output = new FileStream(jsonOutputPath, FileMode.Create))
{
jsonFormatProvider.Export(workbook, output, TimeSpan.FromSeconds(10));
}