How to merge two Excel XLSX files together in Node.JS

Setting up spreadsheet merging in Node.JS is nobody’s idea of a fun afternoon, especially when it takes longer than that. Don’t you worry, though, we have a quick way to get this done.

So we are going to start by installing our client via this reference in your package.json file.

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

Now call this function:

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.MergeDocumentApi();
var inputFile1 = "/path/to/file"; // File | First input file to perform the operation on.
var inputFile2 = "/path/to/file"; // File | Second input file to perform the operation on (more than 2 can be supplied).
var callback = function(error, data, response) {
if (error) {
console.error(error);
} else {
console.log('API called successfully. Returned data: ' + data);
}
};
apiInstance.mergeDocumentXlsx(inputFile1, inputFile2, callback);

Select your two files and they will be returned to you as a single merged file. Not bad! The file order will be maintained if you repeat the process using additional files.