1

I want to create node script which will convert XML to EXCEL file,I have different XML file I want to generate single EXCEL in key value pair, key is common and value is different in all files, I want to generate EXCEL in such way that it will take key in one column and values related to this keys in different column and in same row

File1.xml

<string name="app_name">PDF</string>
<string name="string_ok">English</string>

file2.xml

<string name="app_name">Share it</string>
<string name="string_ok">America</string>

file3.xml

<string name="app_name">File Explorer</string>
<string name="string_ok">India</string>

I want Excel in the following format

Key        column1   column2   column3

app_name   PDF       Share it  File Explorer
string_ok  English   America   India
1
  • Refer to here for xml parsing. And checkout this for creating excel files. Commented Jun 14, 2017 at 7:50

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.