Convert Excel XLSX to JSON Object Array in C#

With the Cloudmersive Convert API, you can easily convert Excel files to JSON object arrays in 13 different programming languages. Below, we’ll walk through how to take advantage of this API using C# code from the Cloudmersive API Console.

Your first step is installing either the .NET or .NET Core SDK.

For .NET:

Install-Package Cloudmersive.APIClient.NET.DocumentAndDataConvert -Version 3.4.2
using System;
using System.Diagnostics;
using Cloudmersive.APIClient.NET.DocumentAndDataConvert.Api;
using Cloudmersive.APIClient.NET.DocumentAndDataConvert.Client;
using Cloudmersive.APIClient.NET.DocumentAndDataConvert.Model;

For .NET Core:

Install-Package Cloudmersive.APIClient.NETCore.DocumentAndDataConvert -Version 2.2.1
using System;
using System.Diagnostics;
using Cloudmersive.APIClient.NETCore.DocumentAndDataConvert.Api;
using Cloudmersive.APIClient.NETCore.DocumentAndDataConvert.Client;
using Cloudmersive.APIClient.NETCore.DocumentAndDataConvert.Model;

After that, simply copy the code below to complete the API call. Include your Cloudmersive API key where indicated below:

namespace Example
{
    public class ConvertDataXlsxToJsonExample
    {
        public void main()
        {
            // Configure API key authorization: Apikey
            Configuration.Default.AddApiKey("Apikey", "YOUR_API_KEY");
var apiInstance = new ConvertDataApi();
            var inputFile = new System.IO.FileStream("C:\\temp\\inputfile", System.IO.FileMode.Open); // System.IO.Stream | Input file to perform the operation on.
try
            {
                // Convert Excel XLSX to JSON conversion
                byte[] result = apiInstance.ConvertDataXlsxToJson(inputFile);
                Debug.WriteLine(result);
            }
            catch (Exception e)
            {
                Debug.Print("Exception when calling ConvertDataApi.ConvertDataXlsxToJson: " + e.Message );
            }
        }
    }
}