How to convert Excel XLSX into JSON in C# .NET Framework

Excel might be a perfectly usable program on the surface, but XLSX format itself is notoriously difficult to parse and deal with, especially from within C#. The never-ending cascade of different layers of elements that make up one of these files is enough to give you a headache. Generally, JSON format is much simpler to work with, and so we will be setting up a means by which we can convert our XLSX files into JSON equivalents easily.

First step, install our client library:

Install-Package Cloudmersive.APIClient.NET.DocumentAndDataConvert -Version 3.2.8

Now we can go ahead and call the function that we need for XLSX to JSON conversion:

using System;using System.Diagnostics;using Cloudmersive.APIClient.NET.DocumentAndDataConvert.Api;using Cloudmersive.APIClient.NET.DocumentAndDataConvert.Client;using Cloudmersive.APIClient.NET.DocumentAndDataConvert.Model;namespace Example{public class ConvertDataXlsxToJsonExample{public void main(){// Configure API key authorization: ApikeyConfiguration.Default.AddApiKey("Apikey", "YOUR_API_KEY");// Uncomment below to setup prefix (e.g. Bearer) for API key, if needed// Configuration.Default.AddApiKeyPrefix("Apikey", "Bearer");var apiInstance = new ConvertDataApi();var inputFile = new System.IO.Stream(); // System.IO.Stream | Input file to perform the operation on.try{// Convert Excel XLSX to JSON conversionObject result = apiInstance.ConvertDataXlsxToJson(inputFile);Debug.WriteLine(result);}catch (Exception e){Debug.Print("Exception when calling ConvertDataApi.ConvertDataXlsxToJson: " + e.Message );}}}}

Whew! Done.

Image for post
Image for post

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store