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. In the tArg.pattern field specify the pattern that will be used to make changes, and in the tArg.meta field specify the updated data and metadata. To save the changes, execute the SaveObject or SaveObjectAs operation after the SetWbkMd operation.

The SetWbkMd operation results in the moniker of changed workbook and data/metadata 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