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.

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