LOWER

LOWER(arg1) → { string }

Converts all letters in a text string to lowercase.

Parameters:

Name Type Description
arg1 string

The text to convert to lowercase. The text characters that are not letters are not changed.

Returns:

Type
string

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.LOWER("Day"));
builder.SaveFile("xlsx", "LOWER.xlsx");
builder.CloseFile();

Resulting document