Hi All,
I am trying to Parse XML based data from an excel based XML Open Document but I am not able to get the exact Result. The Column values are shifting from one place to another.Please refer to attached screen shot. My XML has the following format.
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com
ffice:spreadsheet"
xmlns
="urn:schemas-microsoft-com
ffice
ffice"
xmlns:x="urn:schemas-microsoft-com
ffice:excel"
xmlns:ss="urn:schemas-microsoft-com
ffice:spreadsheet"
xmlns:html="" xmlns:x2="">
To see the whole post, download it
here