devesh.hassani (10/5/2015)
Hi,I want to convert table into following xml format. Sample two records is given below. Any help would be appreciated.
<Row>
<Cell ss:StyleID="s22">
<Data ss:Type="String">XXXXXXXXXXXXX</Data>
</Cell>
<Cell ss:StyleID="s22">
<Data ss:Type="String">64856</Data>
</Cell>
<Cell ss:StyleID="s22">
<Data ss:Type="String">Test001</Data>
</Cell>
</ROW>
<Row>
<Cell ss:StyleID="s22">
<Data ss:Type="String">XXXXXXXXXXXXX</Data>
</Cell>
<Cell ss:StyleID="s22">
<Data ss:Type="String">64857</Data>
</Cell>
<Cell ss:StyleID="s22">
<Data ss:Type="String">Test002</Data>
</Cell>
</ROW>
Thanks,
DH
It would appear that you're trying to export "spreadsheet data". Why not just do a simple export of TSV data instead of jumping through the XML and "format every cell" hoop? It would be a whole lot easier on "the pipe".
--Jeff Moden
Change is inevitable... Change for the better is not.