Excel 2007/2010

For storing documents as the basic Microsoft Excel format, right up to the Excel 2007 version, used its own binary format of files (BIFF) and the file extension was «.xls». In Excel 2007/2010, the basic format is the Microsoft Office Open XML format and stores document in files with the «.xlsx» extension. The Excel 2007 is compatible with binary formats such as CSV, DBF, SYLK, DIF, and others.

By default a report is exported as one table to one Excel sheet. Maximal number of rows on a sheet in limited. It depend on the version of Excel and is set using the MaximumSheetHeight static property (by default 1048574 for Excel 2007). If rows are too many then redundant rows will be output on the next sheet. Also it is possible to export each page of a report to the single sheet Excel. To do this, it is necessary to set the ExportEachPageToSheet property to true.

Each page of a report has the ExcelSheet report property to what any expression may be assigned. Numbers of pages with the same value in the “ExcelSheet” are combined and exported to a single sheet of Excel. The name of the sheet becomes the value of the expression.