Crating XLS file from binary data in node.js

Question

I received the binary data as response from http request.

In C# I convert the data to byteArray and writhing the byteArray into file creates a readable xls file.

C# Code:

 HttpResponseMessage httpResponseMessage = _httpClient.GetAsync(endPoint).Result;
 var httpResponseByteArray = httpResponseMessage.Content.ReadAsByteArrayAsync().Result;
 File.WriteAllBytes("plateList.xls", httpResponseByteArray);

I am looking for a way to implement the same thing in node js.

I`ve tried these methods so far but each created a non-readable file:

 const Excel = require('exceljs');

First try - node.js

 var dataBinary = response.data;
 var workbook = new Excel.Workbook(dataBinary);
 await workbook.xlsx.writeFile("Test.xls")
         .then(function (err) {
            if (err) throw err;
            console.log('\x1b[32m%s\x1b[0m', "Create excel file successfully");
          });

Secound try - node.js

 var bufferData = Buffer.from(response.data);
 var workbook = new Excel.Workbook(dataBinary);
 await workbook.xlsx.writeFile("Test.xls")
         .then(function (err) {
            if (err) throw err;
            console.log('\x1b[32m%s\x1b[0m', "Create excel file successfully");
          });

Other library:

 const fs = require('fs');

Third try - node.js

 fs.writeFileSync("Test.xls", response.data);

Fourth try - node.js

 fs.writeFileSync("Test.xls",  Buffer.from(response.data));

And more but nothing work to me

Naor Levi · Accepted Answer · 2020-01-27 10:30:45Z

3

// response.data as a arrayBuffer
var data = response.data;
var arr = new Array();
for (var i = 0; i != data.length; ++i)
    arr[i] = String.fromCharCode(data[i]);
var bstr = arr.join("");

/* Call XLSX */
var workbook = XLSX.read(bstr, {
    type: "binary"
});

/* Create the file*/
XLSX.writeFile(workbook, "carNumbersAllowedFromLPRCamera.xls");

/* Get the work sheet name */
var first_sheet_name = workbook.SheetNames[0];

/* Get worksheet */
var worksheet = workbook.Sheets[first_sheet_name];

/* Convert it to json*/
let xlsData = XLSX.utils.sheet_to_json(worksheet, {
    raw: true
})

edited Jan 27, 2020 at 10:30

Naor Levi

1,8211 gold badge17 silver badges30 bronze badges

answered Jan 27, 2020 at 9:36

Amichay_Atias

1252 gold badges2 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

DanyMartinez_ Over a year ago

Hi @Naor Levi , how to made to file excel base64 post?

Collectives™ on Stack Overflow

Crating XLS file from binary data in node.js

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related