Document Solutions for Excel, .NET Edition | Document Solutions
Features / Table / Table Style / Modify Table Layout
In This Topic
    Modify Table Layout
    In This Topic

    In DsExcel .NET, Table Layout mode allows users to divide an area of a group into several rows and columns and then place controls into the created cells by specifying the indexes and span values for rows and columns. This functionality is similar to the one which is used while creating a table in HTML.

    C#
    Copy Code 
    ITable table = worksheet.Tables.Add(worksheet.Range["A1:B2"]);

//Show table header row.
table.ShowHeaders = true;

//To make "first row stripe" and "second row stripe" table style element's style effective.
table.ShowTableStyleRowStripes = false;

//Hide auto filter drop down button.
table.ShowAutoFilterDropDown = false;

//To make "first column" table style element's style effective.
table.ShowTableStyleFirstColumn = true;

//Show table total row.
table.ShowTotals = true;

//To make "last column" table style element's style effective.
table.ShowTableStyleLastColumn = true;

//To make "first column stripe" and "second column stripe" table style element's style effective.
table.ShowTableStyleColumnStripes = true;

//Unfilter table column filters, and hide auto filter drop down button.
table.ShowAutoFilter = false;