A table in Aspose.Cells Report template consists of header, table data row, row group and footers. A sample of table is shown in the following.
Table header normally contains the title for each table column and other text item such as static text, Report Parameters, Report Global Variables and so on. Table header is optional.
Table data row is a row of Cells that contains smart markers. A table can only contain single data row.
Row group follows closely after table data row and it includes two parts: group tag and group data row. Group tag should be placed on the left of the first column of table data column that indicates the row is the data row of row group. The format of group tag is “##group{GroupColumn}”, for example, “##group{SalesOrderNumber}” where “SalesOrderNumber” is one of the column names of dataset. A table could only contains a row group but row group could contain more than one group data row and group tag may be placed only in the first data row, as shown in the sample above.
Group tag will be removed from output Excel file at rendering time. Row groups is optional.
Footers follows closely after row group and it includes three parts: footer tag, footer data row and footer text area. Footer tag should be placed on the left of the first column of table data column that indicates the row is the footer of the table. A table could contain more than one footer data rows and each footer row has to be marker by footer tag. Footer text area could contain some static text, Report Parameters and Report Global Variables, as shown in the sample above.
Footer tag will be removed from output Excel file at rendering time. Footers is optional.
The output of the sample template is shown as the following.
