XML to Javascript/Jquery readable format

Question

I have a XML file with approximately 600 lines, I need to make it in a JQuery/JavaScript readable format like the example below:

                    var newSheet = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>' +
                        '<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" mc:Ignorable="x14ac">' +
                        '<cols >' +
                        '<col min="1" max="1" width="24.7" customWidth="1"/>' +
                        '<col min="2" max="2" width="37.7" customWidth="1"/>' +
                        '</cols>' +
                        '<sheetData>' +
                        '<row  r="1">' +
                        '<c t="inlineStr" r="A1" s="7">' +
                        '<is>' +
                        '<t>Information sheet</t>' +
                        '</is>' +
                        '</c>' +
                        '</row>' +
                        '<row  r="2">' +
                        '<c t="inlineStr" r="A2" s="2">' +
                        '<is>' +
                        '<t>Created by</t>' +
                        '</is>' +
                        '</c>' +
                        '<c t="inlineStr" r="B2" s="3">' +
                        '<is>' +
                        '<t>F12Magic</t>' +
                        '</is>' +
                        '</c>' +
                        '</row>' +
                        '<row  r="3">' +
                        '<c t="inlineStr" r="A3" s="2">' +
                        '<is>' +
                        '<t>Date</t>' +
                        '</is>' +
                        '</c>' +
                        '<c t="inlineStr" r="B3" s="3">' +
                        '<is>' +
                        '<t>' + '</t>' +
                        '</is>' +
                        '</c>' +
                        '</row>' +
                        '</sheetData>' +
                        '<mergeCells count="1">' +
                        '<mergeCell  ref="A1:B1"/>' +
                        '</mergeCells>' +
                        '</worksheet>';

As you can see, the quotation marks and the '+' sign are all there to make it readable for JQuery/JavaScript. Is there a way to convert the XML file to above format so that it can read it?

As you can imagine: I am not going to surround 600 lines with the quotation marks and the '+' sign.

What do you mean by read it? Do want to parse it on javascript to do further operations? You could go through this answer for parsing it as xml. — shrys
– shrys, Commented Jun 13, 2019 at 11:59
It needs to be in a readable format for Javascript with the quotation marks/and + signs. I can't be the only one looking for a easier way to do that. @shrys — Aids Jung
– Aids Jung, Commented Jun 13, 2019 at 12:05
You can use back ticks as this post suggests or put a back slash after each line before new line starts, for readability — shrys
– shrys, Commented Jun 13, 2019 at 12:29

shrys · Accepted Answer · 2019-06-13 12:43:45Z

2

You can use back ticks as this post suggests or put a back slash after each line before new line starts, for readability.

var foo = `Bob
is
cool`;

answered Jun 13, 2019 at 12:43

shrys

5,9682 gold badges26 silver badges38 bronze badges

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

1 Comment

faisaljanjua Over a year ago

even try but output is same

Collectives™ on Stack Overflow

XML to Javascript/Jquery readable format

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related