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" ssattern="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
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" ssattern="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