SetWbkMd

Syntax

SetWbkMdResult SetWbkMd(WbkId tWbk, SetWbkMdArg tArg)

Parameters

tWbk. Workbook instance moniker.

tArg. Operation execution parameters.

Description

The SetWbkMd operation changes workbook data and metadata.

Comments

To execute the operation, in the tWbk field specify moniker of the opened workbook instance, and in the tArg field specify change parameters. The moniker can be obtained on executing the OpenWbk operation. The tArg.pattern field is used to specify the pattern, according to which the changes are made, and the updated data and metadata is specified in the tArg.meta field. To save the changes, execute the SaveObject or SaveObjectAs operation after the SetWbkMd operation.

The result of the SetWbkMd operation is moniker of the changed workbook and the requested data or metadata that can be requested in the tArg.metaGet pattern.

Example

Various methods of using this operation are given in the following examples:

Example name

Data Filtering and Sorting

Displaying Additional Columns with Attribute Values

Changing Chart in Workbook

Changing Cell Style

Deleting a Series from Workbook

Applying Transformation to a Series