469,326 Members | 1,359 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

How to convert XML data to EXCEL


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

Help me
Thanks in Advance.
Aug 11 '08 #1
7 17206
13,262 8TB
Using a tool or a programming language?
Aug 12 '08 #2
Using Programming Language...........
Aug 13 '08 #3
13,262 8TB
Using Programming Language...........
Which one?
Aug 13 '08 #4
Using .net programming language
Aug 14 '08 #5
2,057 Expert 2GB
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:
Expand|Select|Wrap|Line Numbers
  1. <Worksheet>
  2.   <Table>
  3.    <Row>
  4.     <Cell><Data ss:Type="String">a</Data></Cell>
  5.     <Cell><Data ss:Type="String">b</Data></Cell>
  6.     <Cell><Data ss:Type="String">c</Data></Cell>
  7.    </Row>
  8.    <Row>
  9.     <Cell><Data ss:Type="Number">1</Data></Cell>
  10.     <Cell><Data ss:Type="Number">2</Data></Cell>
  11.     <Cell><Data ss:Type="Number">3</Data></Cell>
  12.    </Row>
  13.   </Table>
  14. </Worksheet>
Aug 19 '08 #6
This web page helped me and it should help you:


This was the most simple and easy to understand process that I have found in my internet searches.
Aug 20 '08 #7
I found a solution on C-sharp corner. I think that the method in this article may be helpful for you.
Hope Helpful!
Feb 14 '12 #8

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by neeraj | last post: by
8 posts views Thread by =?Utf-8?B?UmljYXJkbyBRdWludGFuaWxsYQ==?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.