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 transferred as simple text, graphic image transfer is supported.
|
