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

92
Hi,

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

Urgent,
Help me
Thanks in Advance.
Aug 11 '08 #1
7 17206
r035198x
13,262 8TB
Using a tool or a programming language?
Aug 12 '08 #2
Limno
92
Using Programming Language...........
Aug 13 '08 #3
r035198x
13,262 8TB
Using Programming Language...........
Which one?
Aug 13 '08 #4
Limno
92
Using .net programming language
Aug 14 '08 #5
jkmyoung
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>
  15.  
Aug 19 '08 #6
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.
Aug 20 '08 #7
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!
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.