Skip to main content

UNICODE

Returns the number (code point) corresponding to the first character of the text.

Syntax

expression.UNICODE(arg1);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

NameRequired/OptionalData typeDefaultDescription
arg1RequiredApiRange | ApiName | stringThe character for which the Unicode value will be returned.

Returns

number

Example

Return the number (code point) corresponding to the first character of the text in a spreadsheet.

// How to get an Unicode of a character in a spreadsheet.

// Use a function to return the character's Unicode in a spreadsheet.

let worksheet = Api.GetActiveSheet();
let func = Api.WorksheetFunction;
worksheet.GetRange("A1").SetValue(func.UNICODE("example"));