Output to Excel or Standard report to Excel can be only
used if MS Excel is installed or another application is linked with .xls files.
The data transfer path to Excel or another spreadsheet
application is selected automatically. COM and XMLSS are available as transfer
paths.
- COM - This procedure is
very time-consuming with larger reports.
Note: Is only intended for older Microsoft Excel versions which do not
support XMLSS. The reports are written directly into a new Excel file.
- XMLSS - This procedure is
much quicker, even with larger reports.
- The report is stored as
a file with the ending ‘.excel.xml’ in the project’s report directory. This
file is opened with the application which is linked with ‘.xls’ files.
Note: XMLSS stands
for "eXtendable Markup Language for Spread Sheets" and is a standard for
spreadsheet applications supported by many manufacturers.
Data transfer
paths
- Program – Data transfer
- Microsoft Excel older
than XP/2002 (version 10) – COM
- Microsoft Excel XP/2002
(version 10) – XMLSS
- Microsoft Excel 2003
(version 11) – XMLSS
- Microsoft Excel Viewer
2003 – does not work
- OpenOffice.Org 2.2 –
XMLSS, if the application Calc is linked to the extension ‘.xls’