Skip to main content

LOWER

Converts all letters in a text string to lowercase.

Syntax

expression.LOWER(arg1);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

NameRequired/OptionalData typeDefaultDescription
arg1RequiredApiRange | ApiName | stringThe text to convert to lowercase. The text characters that are not letters are not changed.

Returns

string

Example

This example shows how to convert all letters in a text string to lowercase.

// How to make all characters uncapitalized.

// Use a function to make a text string to lowercase.

let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
worksheet.GetRange("A1").SetValue(func.LOWER("Day"));