Description
Retrieves styles information.
Syntax
EssGetStyle([workbookName]sheetName, styleType, dimName, item)
Where [workbookName]sheetname is the text name of the workbook and worksheet from which to retrieve style information.
styleType specifies the style setting you want to get, as shown in Table 28.
Table 28. Style Types and Settings
styleType | Style Setting |
---|
0 | Dimensions |
1 | Child Members |
2 | Parent Members |
3 | Shared Members |
4 | Read Only |
5 | Read/Write |
6 | Contains Formula |
7 | Dynamic Calculations |
8 | Linked Objects |
11 | Attributes |
12 | Integration Server Drill-Through |
dimName is the dimension name if styleType is 0; otherwise this parameter should be set to Null.
item is the style you want to get, as shown in Table 29.
Table 29. Item Meanings and Return Types
Item | Meaning | Return Type |
---|
1 | Use style | Boolean |
2 | Font name | Text |
3 | Font size | Number |
4 | Bold | Boolean |
5 | Italic | Boolean |
6 | Underline | Boolean |
7 | Strikeout | Boolean |
8 | Foreground color | Number |
9 | Background color | Number |
10 | Border | Boolean |
Foreground and background colors are shown in Table 30.
Table 30. Foreground and Background Colors
Integer | Color |
---|
1 | Black |
2 | White |
3 | Red |
4 | Lime |
5 | Blue |
6 | Yellow |
7 | Fuchsia |
8 | Aqua |
9 | Maroon |
10 | Green |
11 | Navy |
12 | Olive |
13 | Purple |
14 | Teal |
15 | Silver |
16 | Gray |
Example
=EssGetStyle("[Sample.xls]Sheet1",1,,5)