Overview


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: Property names and component names are specified in brackets in the template: [Caption], [Tag], [Memo1.Lines].

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.

ExcelView template

ExcelView sheet