- GC
- GC.Data
- GC.Pivot
- GC.Spread.Pivot
- GC.Spread.Slicers
- GC.Spread.CalcEngine
- GC.Spread.Commands
- GC.Spread.Common
- GC.Spread.Formatter
- GC.Spread.Report
- GC.Spread.Sheets
- GC.Spread.Sheets.IO
- GC.Spread.Sheets.AutoMerge
- GC.Spread.Sheets.Barcode
- GC.Spread.Sheets.Bindings
- GC.Spread.Sheets.CalcEngine
- GC.Spread.Sheets.Search
- GC.Spread.Sheets.CellState
- GC.Spread.Sheets.CellTypes
- GC.Spread.Sheets.Charts
- GC.Spread.Sheets.Commands
- GC.Spread.Sheets.Comments
- GC.Spread.Sheets.ConditionalFormatting
- GC.Spread.Sheets.ContextMenu
- GC.Spread.Sheets.DataValidation
- GC.Spread.Sheets.Fill
- GC.Spread.Sheets.Filter
- GC.Spread.Sheets.FloatingObjects
- GC.Spread.Sheets.FormulaTextBox
- GC.Spread.Sheets.FormulaPanel
- GC.Spread.Sheets.Hyperlink
- GC.Spread.Sheets.InputMask
- GC.Spread.Sheets.NameBox
- GC.Spread.Sheets.OutlineColumn
- GC.Spread.Sheets.Outlines
- GC.Spread.Sheets.PDF
- GC.Spread.Sheets.Print
- GC.Spread.Sheets.Shapes
- GC.Spread.Sheets.Slicers
- GC.Spread.Sheets.Sparklines
- GC.Spread.Sheets.StatusBar
- GC.Spread.Sheets.Tables
- GC.Spread.Sheets.TableSheet
- GC.Spread.Sheets.GanttSheet
- GC.Spread.Sheets.Touch
- GC.Spread.Sheets.Designer
- GC.Spread.Excel
GC.Spread.Sheets.SheetTabStyleManager
Class: SheetTabStyleManager
Spread.Sheets.SheetTabStyleManager
Table of contents
Constructors
Methods
Constructors
constructor
• new SheetTabStyleManager(workbook)
Represents the sheet tab style manager, which can manage the related styles of all sheet tabs.
Parameters
| Name | Type | Description |
|---|---|---|
workbook |
Workbook |
The workbook. |
Methods
add
▸ add(state, style, sheetNames?): void
Add the status style of some or all sheet tabs in the spreadsheet.
example
spread.sheetTabStyles.add(GC.Spread.Sheets.SheetTabState.active, {foreColor: "red"}, ["Sheet1", "Sheet2"]);
spread.sheetTabStyles.add(GC.Spread.Sheets.SheetTabState.hover, {foreColor: "red"});
Parameters
| Name | Type | Description |
|---|---|---|
state |
SheetTabState |
Sheet tab state. |
style |
ISheetTabStyle |
Sheet tab style. |
sheetNames? |
string[] |
The array of sheet tab names to style. |
Returns
void
all
▸ all(sheetNames?): ISheetNameTabStyleMap
Get the status style of some or all sheet tabs in the spreadsheet.
example
spread.sheetTabStyles.all(["Sheet1", "Sheet2"]);
spread.sheetTabStyles.all();
Parameters
| Name | Type | Description |
|---|---|---|
sheetNames? |
string[] |
Array of names of sheet tabs to be queried. |
Returns
The status style of some or all sheet tabs.
clear
▸ clear(sheetNames?): void
Clear the status styles of some or all sheet tabs in the spreadsheet.
example
spread.sheetTabStyles.clear(["Sheet1", "Sheet2"]);
spread.sheetTabStyles.clear();
Parameters
| Name | Type | Description |
|---|---|---|
sheetNames? |
string[] |
The array of worksheet tab names whose status styles need to be cleared. |
Returns
void
remove
▸ remove(state, sheetNames?): void
Remove the status style of some or all sheet tabs in the spreadsheet.
example
spread.sheetTabStyles.remove(GC.Spread.Sheets.SheetTabState.active, ["Sheet1", "Sheet2"]);
spread.sheetTabStyles.remove(GC.Spread.Sheets.SheetTabState.hover);
Parameters
| Name | Type | Description |
|---|---|---|
state |
SheetTabState |
Sheet tab state. |
sheetNames? |
string[] |
The worksheet tab name array corresponding to the state style needs to be deleted. |
Returns
void