XML2Excel: Import to different sheets

  • Thread starter Thread starter Jannick Asmus
  • Start date Start date
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. :-)
 
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. :-)
Click to expand...
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.
 
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.
Click to expand...

Sorry, forgot that: It's Excel2003.
 
Back
Top