Xml To Excel Converter: Convert Your Xml Data To Excel, Xml To Excel Conversion Using Node Js

when you have a Web Service, which has the response or output as XML data. Before using it in our UI, we can convert this XML response to JSON data and get the particular data in the form of Excel, so that it will be easy for us to generate the reports.

Đang xem: Xml to excel converter: convert your xml data to excel

You would like to parse the XML data to JSON data, from that JSON you have to retrieve the particular fields you want and then generate the report in excel format.

How to convert XML to EXCEL:

In Node JS to convert XML to EXCEL, so many modules are available, but in this article we have to use simple modules i.e xml2js, json2xls module.

Steps to convert XML to JSON:

Step 1: Install xml2js module.

You can install xml2js module by using npm, type the following command in command prompt as follow:

npm install xml2js

Step 2: Create a sample XML file or use the XML file you have.

If you have XML Web Service URL, then generate a XML file and use it in place of sample XML file.

Chandu Mallireddy Female TarunTej Mallireddy Male

Step 3: Code to convert XML to JSON .

var fs = require(“fs”); // File System Module

var parseString = require(‘xml2js’).parseString; // XML2JS Module

var xml = ‘ChanduMallireddy’

+’FemaleTarunTejMallireddy’

+’Male’;

parseString(xml, function (err, result) {

jsonTextFromXML = JSON.stringify(result)

console.log(“result”,jsonTextFromXML);

});

Save the sample file in .js extension and name as xml2json.js

Step 4 : Run the xml2json.js file.

Xem thêm: Giới Thiệu Phương Pháp 5S

To run this file, first go the file placed directory in command prompt and type following command:

node xml2json.js

You can see the JSON response or output as follow:

{“EmployeeDetails”:{“EmployeeDetail”:<{“PersonalInformation”:<{“FirstName”:<“Chandu”>,”LastName”:<“Mallireddy”>,”Gender”:<“Female”>}>},{“PersonalInformation”:<{“FirstName”:<“TarunTej”>,”LastName”:<“Mallireddy”>,”Gender”:<“Male”>}>}>}}

You have JSON data, now you need to convert the JSON data to Excel.

Steps to convert JSON to EXCEL:

Step 1: Install json2xls module.

You can install json2xls module by using npm, type the following command in command prompt as follow:

npm install json2xls

Step 2 : select the JSON data,which you want to convert it into EXCEL.

I have choosen the JSON which was obtained in the before conversion.

{“EmployeeDetails”:{“EmployeeDetail”:<{“PersonalInformation”:<{“FirstName”:<“Chandu”>,”LastName”:<“Mallireddy”>,”Gender”:<“Female”>}>},{“PersonalInformation”:<{“FirstName”:<“TarunTej”>,”LastName”:<“Mallireddy”>,”Gender”:<“Male”>}>}>}}

Step 3: Code to convert JSON to EXCEL.

var json2xls = require(‘json2xls’); // JSON2XLS Module

var fs = require(“fs”); // File Module

var parseString = require(‘xml2js’).parseString;

var xml = ‘ChanduMallireddy’

+’FemaleTarunTejMallireddy’

+’Male’;

parseString(xml, function (err, result) {

jsonTextFromXML = JSON.stringify(result)

jsonTextArray=<>

for (i = 0; i