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: Apikey
var 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 request
var 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.