Convert XLS to XML without XLS Properties

M

M$User

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>
<Style ss:ID="s24">
<NumberFormat ss:Format="#,##0.000"/>
</Style>
<Style ss:ID="s25">
<Font ss:Color="#000000"/>
<Interior ss:Color="#FFCC99" ss:pattern="Solid"/>
</Style>
<Style ss:ID="s26">
<Interior/>
<NumberFormat ss:Format="@"/>
</Style>


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

Top