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 );}}}}

--

--

--

There’s an API for that. Cloudmersive is a leader in Highly Scalable Cloud APIs.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

[Post-2] [LINQ] IEnumerator

Java RegEx: Part 6 — Group and Subgroup

Introducing Taiko

Passed AZ-900 with score above 900.

Celebrating the success of Nu-World’s first airdrop! OG/WL Qualification Event!

The Branding Letters Animation

The Branding Letters Animation

Oracle Xe and Apex in a docker container

Building a Kubernetes Mutating Admission Webhook

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
Cloudmersive

Cloudmersive

There’s an API for that. Cloudmersive is a leader in Highly Scalable Cloud APIs.

More from Medium

Query an XML file using XQuery, Get Results in C#

C# “ENCAPSULATION,PROPERTY AND PROP”

ZIP code geojson polygons for MapView | C# Parser

.NET Core: Winforms reporting with FastReport