Split an XLSX File into Separate Worksheets using Node.JS

Excel spreadsheets are very useful for organizing and sharing complex data sets in easy-to-understand formatting. However, for the creator of an XLSX file, each worksheet within the file may represent and fill different needs, and thus may need to be shared separately. The following API will split an XLSX file into separate worksheets in new files.

Image for post
Image for post

To use this API, run this command to install the SDK:

npm install cloudmersive-convert-api-client --save

You can also add this snippet to your package.json:

"dependencies": {
"cloudmersive-convert-api-client": "^2.4.8"
}

Then, call the function:

var CloudmersiveConvertApiClient = require('cloudmersive-convert-api-client');
var defaultClient = CloudmersiveConvertApiClient.ApiClient.instance;

This will return one new file for each separated worksheet (i.e., if your original file had five worksheets, the output will be five new files). You can retrieve the API Key from Cloudmersive at no cost and with no commitment. This will give you access to 800 monthly calls across our library of APIs.

Written by

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

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