471,617 Members | 1,119 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

Xml to Xls

Hi all,
I have a predefined Xls template which i need to populate with
the data from an Xml file. The Xls template has about 30 columns. The
records in the xml file do not necessarily have all the columns. I need
to map the columns in the xls to the right column in the xls template.
Any pointers would be greatly appreciated. If this is not the right NG,
please point me to the more appropriate NG.

TIA,
Mounil.

Feb 2 '06 #1
2 2094
Mounil,

XLS should handle this natively. Have you checked the w3c consortium
website for info on XSL sheets:

http://www.w3.org/Style/XSL/

This is a decent starting place.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Mounilk" <mo***********@hotmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
Hi all,
I have a predefined Xls template which i need to populate with
the data from an Xml file. The Xls template has about 30 columns. The
records in the xml file do not necessarily have all the columns. I need
to map the columns in the xls to the right column in the xls template.
Any pointers would be greatly appreciated. If this is not the right NG,
please point me to the more appropriate NG.

TIA,
Mounil.

Feb 2 '06 #2
Hi Nicholas,
Thanks a lot for your reply. I am not sure if I
explained my question in the right manner. What I am wanting to do is
to map the columns in my excel spreadsheet to the elements in the XML
document. My excel spreadsheet has about 130 columns. My Xml looks like
this:-

<data>
<row>
<field1>value</field1>
<field4>value</field4>
<field8>value</field8>
<field77>value</field77>
<field5>value</field5>
</row>
<data>

and my excel has columns named field1,field2,field3 and so on. I want
to add a row to my excel spreadsheet inserting the value of the
<fieldX> in the XML to the corresponding column <fieldX> in the excel
spreadsheet. It can be safely assumend that the XML will always contain
only 1 <row> ie only 1 record.

Once again, if this is not the most appropriate NG, please direct me to
one that is more appropriate.

TIA,
Mounil.

Feb 6 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by William C. White | last post: by
2 posts views Thread by Albert Ahtenberg | last post: by
3 posts views Thread by James | last post: by
reply views Thread by Ollivier Robert | last post: by
1 post views Thread by Richard Galli | last post: by
4 posts views Thread by Albert Ahtenberg | last post: by
1 post views Thread by inderjit S Gabrie | last post: by
2 posts views Thread by Jack | last post: by
3 posts views Thread by Sandwick | last post: by
1 post views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
1 post views Thread by ZEDKYRIE | 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.