How to write Report with JavascriptTotal Sale and Total Order For per day

I have Create XML Report For Excel Report
I write by Java-script for Sale Detail Report and Order Detail Report XML
Like This…

i write like that code after i open export file in Excel it show like this

What I wrong in code it show not properly

That is not Javascript at all. Not even close.

XML is not a native/natural format for Excel. They are not related. If you want to import XML into Excel, it can be done, but you need to research how to do it…

XML is a text file with a particular structure for representing data. You are seeing a text file in Excel.

Instead, you should be creating a Data Export for CSV (comma separated values). Excel can read CSV files natively …

1 Like