EssGetStyle

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

styleTypeStyle 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

ItemMeaningReturn 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

IntegerColor

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)