Spread.Services Documentation
Apply Table Style
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;