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:
[code=xml]
<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>
[/code]

[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/UploadFile/f201d9/data-export-to-excel-and-create-group-report-in-net3/

Hope Helpful!