Export to Excel 97/2000/XP

Excel – application for working with electronic spreadsheets. It is included in Microsoft Office.

The Export method is Table.

When exporting to Excel format a dialogue opens requesting output file settings.

Data grouping:

• Like the report - each page of prepared report is exported on a separate Excel sheet;

• All in one page - generate continuous document without page breaks and page headers/footers;

• Chunks. Each chunk has (rows) - each chunk is exported on a separate Excel sheet.

Export settings:

• WYSIWYG : full compliance to report appearance; when disabled optimization is allowed, reducing the number of lines and columns in the export file

• Pictures – includes graphic images export into output table;

• Grid lines - turns on/off Excel grid lines;

• Adjust page size - adjusts cell size to fit the content;

• Delete empty rows - deletes empty rows from the output table;

• Export formulas - if a cell text starts with "=" symbol, it is exported as an Excel formula.

• Open Excel after export : exported file is opened immediately after export.

Export features: RichText objects are exported as simple text.