Convert **Document ↔ JSON** in .NET – Streamline Your Data Pipelines with Sheetize JSON Converter

using Sheetize;

// 1️⃣ Load the license (free trial license – no credit‑card required)
var license = new Sheetize.License();
license.SetLicense(@"C:\Sheetize.JsonConverter_for_.NET.lic");

// 2️⃣ Define input (any spreadsheet format)
var loadOpts = new LoadOptions
{
InputFile = @"C:\Data\SalesReport.xlsx"
};

// 3️⃣ Define JSON output options
var saveOpts = new JsonSaveOptions
{
OutputFile = @"C:\Exports\SalesReport.json"
};

// 4️⃣ Execute conversion
JsonConverter.Process(loadOpts, saveOpts);
Console.WriteLine("✅ Spreadsheet exported to JSON.");

using Sheetize;

// License
var license = new Sheetize.License();
license.SetLicense(@"C:\Sheetize.JsonConverter_for_.NET.lic");

// Load JSON source (could be a stream, a string, or a file)
var loadOpts = new LoadOptions
{
InputFile = @"C:\Exports\SalesReport.json"
};

// Choose the target document format – here we generate XLSX
var saveOpts = new SaveOptions
{
OutputFile = @"C:\Results\SalesReport_FromJson.xlsx",
SaveFormat = FileFormatType.Xlsx // any supported format (Csv, Html, Epub, …)
};

JsonConverter.Process(loadOpts, saveOpts);
Console.WriteLine("✅ JSON imported into native XLSX workbook.");

using Sheetize;
using System;
using System.IO;
using System.Linq;

try
{
// 1️⃣ License validation
var license = new Sheetize.License();
license.SetLicense(@"C:\Licenses\Sheetize.JsonConverter_for_.NET.lic");

// 2️⃣ Input & output paths (replace with your own)
string inputPath = @"C:\Input\Report.epub";
string outputPath = @"C:\Output\Report.json";

// 3️⃣ Supported extensions
var docExts = new[] { ".xlsx", ".xlsb", ".xlsm", ".xltm", ".xlam",
".xls", ".xml", ".csv", ".tsv", ".sqlscript",
".dif", ".epub", ".azw3", ".html", ".mhtml" };
var jsonExt = ".json";

// 4️⃣ Validate that one side is JSON
bool inputIsJson = Path.GetExtension(inputPath).Equals(jsonExt, StringComparison.OrdinalIgnoreCase);
bool outputIsJson = Path.GetExtension(outputPath).Equals(jsonExt, StringComparison.OrdinalIgnoreCase);

if (!inputIsJson && !outputIsJson)
throw new InvalidOperationException("One of the files must be a JSON document.");

// 5️⃣ Validate document extensions
if (!inputIsJson && !docExts.Contains(Path.GetExtension(inputPath).ToLower()))
throw new NotSupportedException($"Unsupported input file type: {inputPath}");
if (!outputIsJson && !docExts.Contains(Path.GetExtension(outputPath).ToLower()))
throw new NotSupportedException($"Unsupported output file type: {outputPath}");

// 6️⃣ Build options
var loadOpts = new LoadOptions { InputFile = inputPath };
var saveOpts = inputIsJson
? new DocumentSaveOptions
{
OutputFile = outputPath,
SaveFormat = Path.GetExtension(outputPath).ToLower() switch
{
".xlsx" => FileFormatType.Xlsx,
".csv" => FileFormatType.Csv,
".html" => FileFormatType.Html,
".epub" => FileFormatType.Epub,
".azw3" => FileFormatType.Azw3,
".xml" => FileFormatType.Xml,
".tsv" => FileFormatType.Tsv,
".sqlscript" => FileFormatType.SqlScript,
".dif" => FileFormatType.Dif,
_ => throw new NotSupportedException("Unsupported destination format.")
}
}
: new JsonSaveOptions { OutputFile = outputPath };

// 7️⃣ Execute conversion
JsonConverter.Process(loadOpts, saveOpts);
Console.WriteLine($"✅ Conversion succeeded: {outputPath}");
}
catch (Exception ex)
{
// Centralized logging (Serilog, NLog, Azure AppInsights, etc.)
Console.Error.WriteLine($"❌ Conversion failed: {ex.GetType().Name} – {ex.Message}");
// optionally re‑throw for upstream handling
}

# 1️⃣ Install the NuGet package
dotnet add package Sheetize

# 2️⃣ Grab a free trial licence (no credit‑card needed)
# https://purchase.sheetize.com/temp-license/113911

# 3️⃣ Place the .lic file in your project (e.g., ./Licenses/Sheetize.JsonConverter_for_.NET.lic)

# 4️⃣ Use the code snippets above – compile and watch your data flow!