Reading Data from XML Open Data Document

Anonymous — Tue, 06 Jan 2015 13:50:13 GMT

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

Re: Reading Data from XML Open Data Document

Anonymous — Tue, 06 Jan 2015 20:15:51 GMT

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

topic Re: Reading Data from XML Open Data Document in Talend Studio

Reading Data from XML Open Data Document

Re: Reading Data from XML Open Data Document