Apply Table Style

Spread.Services Documentation
Apply Table Style
Collapse All Expand All

Spread.Services Documentation > Developer's Guide > Manage Data in Spread Component > Use Table > Apply Table Style

In Spread.Services, you can create custom table style elements and apply them to your worksheet using the ITableStyle Interface. Also, you can format a table using any of the predefined table styles provided by Spread.services.

Typically, each workbook possesses an ITableStyle collection that is used to store both built-in and custom table styles. If you want to insert a custom table style, you use the Add method of the ITables interface, which returns the IStyle object representing the corresponding table style instance.

C# | Copy Code
--- | ---

    //Use table style name get one build in table style.
    ITableStyle tableStyle = workbook.TableStyles["TableStyleLight11"];
    worksheet.Tables.Add(worksheet.Range[0, 0, 2, 2], true);

    //set build in table style to table.
    worksheet.Tables[0].TableStyle = tableStyle;

Copyright © GrapeCity, inc. All rights reserved.