How to create a blank Excel XLSX spreadsheet in Node.JS

Despite seeming simple at first glance, the task of creating blank XLSX files is actually quite a bit more taxing upon closer inspection. There is an exception, however, if we bypass the whole process entirely. I have an API here that will do just that.

With npm install, our client can be installed, as you see here:

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

The next step is to instantiate our edit document API using a free key. Following that, call editDocumentXlsxCreateBlankSpreadsheet via the instance.

var CloudmersiveConvertApiClient = require('cloudmersive-convert-api-client');var defaultClient = CloudmersiveConvertApiClient.ApiClient.instance;// Configure API key authorization: Apikeyvar Apikey = defaultClient.authentications['Apikey'];Apikey.apiKey = 'YOUR API KEY';// Uncomment the following line to set a prefix for the API key, e.g. "Token" (defaults to null)//Apikey.apiKeyPrefix = 'Token';var apiInstance = new CloudmersiveConvertApiClient.EditDocumentApi();var input = new CloudmersiveConvertApiClient.CreateBlankSpreadsheetRequest(); // CreateBlankSpreadsheetRequest | Document input requestvar callback = function(error, data, response) {if (error) {console.error(error);} else {console.log('API called successfully. Returned data: ' + data);}};apiInstance.editDocumentXlsxCreateBlankSpreadsheet(input, callback);

Alright, this one is in the bag. You read correctly, we’re already finished. Now that we have a blank XLSX, we can use other functions from this same library to populate it and then return the finished file.

Image for post
Image for post

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