Convert Excel to HTML by XSLT transformation of XML

I have a requirement to preview excel files in browser. I could generate an XML for the worksheet. I am trying to convert the XML to HTML by XSLT transformation. I am able to get the data in table format. I could not get the style part in xsl. Below is the XML for a sample spreadsheet.

"9.25" defaultRowHeight="15" dyDescent="0.25" />
"1">
"A1" ColumnId="A" ColumnNumber="0" Type="s">
Make
Make
"B1" ColumnId="B" ColumnNumber="1" Type="s">
Miles
Miles
"C1" ColumnId="C" ColumnNumber="2" Type="s">
Cost
Cost
"2">
"A2" ColumnId="A" ColumnNumber="0" Type="s">
Ford
Ford
"B2" ColumnId="B" ColumnNumber="1">
40000
40000
"C2" ColumnId="C" ColumnNumber="2" Style="1">
"6" formatCode=""$"#,##0_);[Red]$"$"#,##0$" applyNumberFormat="1">
"11" />
"1" />
"Calibri" />
"Swiss" />
"minor" />
3500
$3,500
"3">
"A3" ColumnId="A" ColumnNumber="0" Type="s">
Chevi
Chevi
"B3" ColumnId="B" ColumnNumber="1">
55000
55000
"C3" ColumnId="C" ColumnNumber="2" Style="1">
"6" formatCode=""$"#,##0_);[Red]$"$"#,##0$" applyNumberFormat="1">
"11" />
"1" />
"Calibri" />
"Swiss" />
"minor" />
4200
$4,200
"4">
"A4" ColumnId="A" ColumnNumber="0" Type="s">
Tata
Tata
"B4" ColumnId="B" ColumnNumber="1">
51000
51000
"C4" ColumnId="C" ColumnNumber="2" Style="1">
"6" formatCode=""$"#,##0_);[Red]$"$"#,##0$" applyNumberFormat="1">
"11" />
"1" />
"Calibri" />
"Swiss" />
"minor" />
3800
$3,800

XSL Sheet

"3.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
"@*|node()">
"@*|node()"/>
"Data">
"@*|node()"/>
"Row">
"@*|node()"/>
"Cell">
"DisplayValue"/>

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jenith Thakkar6y ago
You should check viewerjs for that It's providing kind of iframe to show document
Also it wil give you good UI

https://viewerjs.org/

please refer this link
you just need to convert Excel to ods