TxlReport class

The TxlReport class is the only class accessible in Delphi component palette. This class encapsulates all the mechanisms and algorithms of Microsoft Excel report generation. To build a report using an existing template you have to:

• Create an instance of the class, at either design-time or run-time.
• Specify the path and file name of the template workbook in the XLSTemplate property.
• Add all the datasets required in report generation to DataSources collection and define their properties.
• Call the Report method of this class.

Example of report building on tQuickStart.xls template with tblCustomers and tblOrders datasets: