Templates / Template Configuration / Tables
In This Topic
Tables
In This Topic

Tables are essential to depict large amounts of data in an organized way. DsExcel supports using Excel tables in template layouts where various operations can also be performed on it like filtering, sorting etc.

This template example lists E-Commerce sales for different areas grouped as a list. The template cells are defined within the table layout. You can also download the Excel template layout from here.

Table template

After DsExcel processes the template layout, the Excel report will look like below:

Table template output

An Excel table can be incorporated in a template layout in two ways:

  1. Template cells inside an Excel table: You can insert a table in Excel's template layout and define template cells inside it, as shown in above screenshot. The table is resized according to the expanded data after processing the template in DsExcel. 
  2. Excel table inside a template cell’s range: You can define a template cell with Range property and insert a table anywhere within that range. The table is copied according to the expansion data after processing the template in DsExcel.
Note: Table formulas are also supported in template cells.

Limitations