Modify Table Layout

Spread.Services Documentation
Modify Table Layout
Collapse All Expand All

Spread.Services Documentation > Developer's Guide > Manage Data in Spread Component > Use Table > Apply Table Style > 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;

Copyright © GrapeCity, inc. All rights reserved.