ExcelView is a very simple VCL component for Delphi 2010/XE/XE2 that was created for MS Excel reporting based on Excel templates. It can automatically substitute in the templates:
- all published properties of the form or datamodule where the component is placed
- all components belonging to this form with their published properties
- all datasets with their field values
For now ExcelView supports the following property types: Integer, Int64, String, Double, Boolean, TStrings.
DataSet names are specified in the first column on each row, which contains the field names. When printing first column will be hidden.
If we want to print all the records from DataSet we need to put an asterisk before the name of the dataset: *tblOrders. Otherwise, we'll print only current record.