Convert XLS to XML without XLS Properties



Dear All,

I need to convert one excel (xls) file to XML file without the excel
properties like height, width, font etc. This appears as 'Style'
statements in the XML file.

Following is the sample XML file showing the Style statments-
<Style ss:ID="s23">
<NumberFormat ss:Format="@"/>
<Style ss:ID="s24">
<NumberFormat ss:Format="#,##0.000"/>
<Style ss:ID="s25">
<Font ss:Color="#000000"/>
<Interior ss:Color="#FFCC99" ss:pattern="Solid"/>
<Style ss:ID="s26">
<NumberFormat ss:Format="@"/>

Kindly help in saving the XLS to XML directly without above properites
so that the XML will directly show the column headings and the data.

Thanks & Regards


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XML to Excel XLS conversion 2
Convert .xls to .prn problem 1
Convert XLS to CSV in Excel 2
Benefit of converting XLS to EXE ? 28
xls to htm? 1
Damaged XLS 4
.qpw to .xls? 2
XLS to JPG 3