XML2Excel: Import to different sheets

J

Jannick Asmus

The xsl availabe at http://xslfactory.free.fr is said to transform an
XML file to a big spreadsheet. I want to open the transformation output
with MS Excel such that the data are - as announced - sorted to
different sheets.

How can I have Excel provide me with the output on different sheets? Or
is the xsl-file to be amended? Importing to one sheet seems to be no
problem at the moment.

Thanks for your help.

J.

ps: I am real newbie to this business. Please choose the fup since I
don't know to which newsgroup I should sort this posting. Thanks. :)
 
J

Joe Fawcett

Jannick Asmus said:
The xsl availabe at http://xslfactory.free.fr is said to transform an XML
file to a big spreadsheet. I want to open the transformation output with
MS Excel such that the data are - as announced - sorted to different
sheets.

How can I have Excel provide me with the output on different sheets? Or is
the xsl-file to be amended? Importing to one sheet seems to be no problem
at the moment.

Thanks for your help.

J.

ps: I am real newbie to this business. Please choose the fup since I don't
know to which newsgroup I should sort this posting. Thanks. :)
What version of Excel does the output use? As far as I know you can compose
multiple sheets if targeting Excel 2007's XML format and most likely the
2003 format.
 
J

Jannick Asmus

What version of Excel does the output use? As far as I know you can
compose multiple sheets if targeting Excel 2007's XML format and most
likely the 2003 format.

Sorry, forgot that: It's Excel2003.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top