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.

var oWorksheet = Api.GetActiveSheet();
Api.SetReferenceStyle("xlR1C1");
oWorksheet.GetRange("A1").SetValue(Api.GetReferenceStyle());