Oxygen XML Forum

Hi all,
I have an excel sheet I want to convert the data into xml format, when I tried i got only 2 options "root" and "row", but i have subchild elements also. Can any one please tell me how I can convert this excel data into an XML data in my desired format?



Thanks in advance,
Raj

Hello,

In the XML Import Preview area of the Excel import dialog you can see the names of the root element of the result XML document and the elements for the rows and columns of the Excel sheet. With the button Change labels you can change the names of these elements and see the result in the preview area. If you want to create a document with other format you have to create a stylesheet in the XSLT language for transformation from the format created by the Import feature to your format.

Regards,
Sorin

Hi Sorin,
Thanks a lot for your reply, I will try with XSLT to transform the file into my desired format.


Raj

Thanx 4 letting us know abt the conversion.I was facing some difficulty but after reading this,i m successful.Thanx.

If you get a copy of OpenOffice (free) it can open your XL spreadsheet and same it as XML with all the sheets, rows and columns intact.