Document Solutions for Excel, .NET Edition | Document Solutions
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 sales information for different areas grouped as a list. The template cells are defined within the table layout.

    The below image displays a template layout where a table is used and template cells are defined inside the table. You can also download the Excel template layout from here.

    Excel template layout displaying template cells inside a table

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

    Excel report displaying generated data inside a table

    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