472,101 Members | 1,503 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,101 software developers and data experts.

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 17296
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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.