JSON Converter
How to Convert Excel to JSON using C#

How to Convert Excel to JSON using C#

Converting Excel files to JSON simplifies data interchange and enhances compatibility with web applications. Aspose.Cells for .NET offers robust functionality to serialize Excel data into JSON effortlessly.

Why Convert Excel to JSON?

  1. Interoperability:
    • Streamline data exchange between different platforms and systems.
  2. Data Management:
    • JSON provides a structured format ideal for web development and data manipulation.
  3. Automation:
    • Automate Excel data serialization to JSON, reducing manual data handling.

Step-by-Step Guide to Convert Excel to JSON

Step 1: Install Aspose.Cells via NuGet

Install Aspose.Cells for .NET using NuGet Package Manager:

dotnet add package Aspose.Cells

Step 2: Configure Aspose.Cells License

Set your Aspose.Cells license to use full features:

Metered matered = new Metered();
matered.SetMeteredKey("PublicKey", "PrivateKey");

Step 3: Load Excel File

Load your Excel file into a Workbook object:

Workbook workbook = new Workbook("file.xlsx");

Step 4: Specify Excel Data to Convert

You can serialize various Excel data types:

  • Cell Range:
var cells = workbook.Worksheets["Sheet1"].Cells.CreateRange("A1:C3");
  • Single Cell:
var cell = workbook.Worksheets["Sheet1"].Cells["A1"];
  • Tables, Charts, Pivot Tables, etc.:
var tables = workbook.Worksheets["Sheet1"].ListObjects;
var charts = workbook.Worksheets["Sheet1"].Charts;
var pivots = workbook.Worksheets["Sheet1"].PivotTables;

Step 5: Serialize Excel Data to JSON

Serialize your specified data into JSON:

string jsonString = Aspose.Cells.Utility.JSONSerializer.Serialize(cells);

Step 6: Save JSON Data

Save the serialized JSON data to a file:

System.IO.File.WriteAllText("output.json", jsonString);

Step 7: Customize JSON Output (Optional)

Enhance JSON output by customizing serialization:

  • Serialize specific elements (formulas, hyperlinks, charts, images, etc.).
  • Control JSON structure and formatting using JsonSaveOptions.

Common Issues and Fixes

1. Incorrect JSON Structure

  • Solution: Verify the data type being serialized (e.g., cell range vs. single cell).

2. Licensing Errors

  • Solution: Check your license file path and ensure it is valid and correctly referenced.

3. File Path Issues

  • Solution: Ensure input Excel file paths and output JSON paths are correct and accessible.
 English