EssSetStyle

Description

Sets styles information.

Syntax

EssSetStyle([workbookName]sheetName, styleType, dimName, item, newValue)

Where [workbookName]sheetname is the text name of the workbook and worksheet to perform the action.

styleType specifies the style setting you want to set, as shown in Table 36.

Table 36. styleType Values 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 set.

newValue contains the setting of item, as shown in Table 37.

Table 37. Item Values

Foreground and background colors are shown in Table 38.

Table 38. Foreground and Background Colors

Example

This example sets the style for child members to italic and displays the style in the spreadsheet.

=EssSetStyle("[Sample.xls]Sheet1",1,,5,TRUE)
=EssSetStyle("[Sample.xls]Sheet1",1,,1,TRUE)