Xml to Xls

[Mounilk]

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.

 

[Nicholas Paldino [.NET/C# MVP]]

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.

 

[Mounilk]

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.