GetNumberFormat

GetNumberFormat() → { string | null }

Returns a value that represents the format code for the current range.

Parameters:

Returns:

Type

string | null

Example

builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oRange = oWorksheet.GetRange("B2");
oRange.SetValue(3);
var sFormat = oRange.GetNumberFormat();
oWorksheet.GetRange("B3").SetValue("Number format: " + sFormat);
builder.SaveFile("xlsx", "GetNumberFormat.xlsx");
builder.CloseFile();

Resulting document