GetAddress

GetAddress(RowAbs, ColAbs, RefStyle, External, RelativeTo) → { string | null }

Returns the range address.

Parameters:

Name Type Description
RowAbs boolean

Defines if the link to the row is absolute or not.

ColAbs boolean

Defines if the link to the column is absolute or not.

RefStyle string

The reference style.

External boolean

Defines if the range is in the current file or not.

RelativeTo range

The range which the current range is relative to.

Returns:

Type
string | null

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
oWorksheet.GetRange("A1").SetValue("1");
oWorksheet.GetRange("B1").SetValue("2");
var sAddress = oWorksheet.GetRange("A1").GetAddress(true, true, "xlA1", false);
oWorksheet.GetRange("A3").SetValue("Address: ");
oWorksheet.GetRange("B3").SetValue(sAddress);
builder.SaveFile("xlsx", "GetAddress.xlsx");
builder.CloseFile();

Resulting document