How to convert XML data to EXCEL

[Limno]

Hi,

Can anyone help How to convert XML file into EXCEL file
with some samples........

Urgent,
Help me
Thanks in Advance.

[r035198x]

Using a tool or a programming language?

[Limno]

Using Programming Language...........

[r035198x]

Using Programming Language...........

Which one?

[Limno]

Using .net programming language

[jkmyoung]

In general, when converting xml to an excel sheet, you're converting the data into a table - row format.
You need to define where each of your rows are, and which of the data you want for each row.

I suggest reverse engineering, by creating a small sample spreadsheet in excel (2003 or later) and then saving it in the xml format. You'll find that the data generally goes into a format like:

<Worksheet>
  <Table>
   <Row>
    <Cell><Data ss:Type="String">a</Data></Cell>
    <Cell><Data ss:Type="String">b</Data></Cell>
    <Cell><Data ss:Type="String">c</Data></Cell>
   </Row>
   <Row>
    <Cell><Data ss:Type="Number">1</Data></Cell>
    <Cell><Data ss:Type="Number">2</Data></Cell>
    <Cell><Data ss:Type="Number">3</Data></Cell>
   </Row>
  </Table>
</Worksheet>
 

[TrevRex]

This web page helped me and it should help you:

http://www.mrexcel.com/tip064.shtml

This was the most simple and easy to understand process that I have found in my internet searches.

[Landy67]

Hello,
I found a solution on C-sharp corner. I think that the method in this article may be helpful for you.
http://www.c-sharpcorner.com/UploadF...eport-in-net3/
Hope Helpful!