SetReferenceStyle
Sets the cell reference style.
Syntax
expression.SetReferenceStyle(sReferenceStyle);
expression - A variable that represents a Api class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| sReferenceStyle | Required | ReferenceStyle | The cell reference style. |
Returns
This method doesn't return any data.
Example
This example sets reference style.
- Code
- Result
let worksheet = Api.GetActiveSheet();
Api.SetReferenceStyle("xlR1C1");
worksheet.GetRange("A1").SetValue(Api.GetReferenceStyle());