How to split an Excel XLSX into Separate Worksheets in C# .NET Framework

Install-Package Cloudmersive.APIClient.NET.DocumentAndDataConvert -Version 3.2.8
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 SplitDocumentXlsxExample{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 SplitDocumentApi();var inputFile = new System.IO.Stream(); // System.IO.Stream | Input file to perform the operation on.var returnDocumentContents = true;  // bool? | Set to true to return the contents of each Worksheet directly, set to false to only return URLs to each resulting worksheet.  Default is true. (optional)try{// Split a single Excel XLSX into Separate WorksheetsSplitXlsxWorksheetResult result = apiInstance.SplitDocumentXlsx(inputFile, returnDocumentContents);Debug.WriteLine(result);}catch (Exception e){Debug.Print("Exception when calling SplitDocumentApi.SplitDocumentXlsx: " + e.Message );}}}}

--

--

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