Modify Table Layout

In Spread.services, 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;

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;