How to Retrieve Macros from an XLSX File in JavaScript

Utilizing macros in Excel will allow you to optimize productivity by automating data manipulation, formatting application, and much more. However, not all macros are the helpful type; some may contain malicious content that could infect your system. To discover the macros in an Excel file, you can use the following API in JavaScript to retrieve any macro information that may be contained in the document.

We will begin the process by running this command to install jQuery:

bower install jquery

Once the installation is complete, we can input the target Excel file into the below example code to call the function:

var form = new FormData();
form.append("inputFile", fileInput.files[0], "file");
var settings = {
     "url": "https://api.cloudmersive.com/convert/edit/xlsx/get-macros",
     "method": "POST",
     "timeout": 0,
     "headers": {
          "Content-Type": "multipart/form-data",
          "Apikey": "YOUR-API-KEY-HERE"
     },
     "processData": false,
     "mimeType": "multipart/form-data",
     "contentType": false,
     "data": form
};
$.ajax(settings).done(function (response) {
     console.log(response);
});

And that’s it! Your result will be returned in no time at all.