Reading Data from XML Open Data Document

[Anonymous]

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

[Anonymous]

Why do you try this hard way. There are excel related components doing all this work for you.