REPT

Repeats text a given number of times. Use this function to fill a cell with a number of instances of a text string.

Syntax

expression.REPT(arg1, arg2);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

Name	Required/Optional	Data type	Default	Description
arg1	Required	ApiRange | ApiName | string		The text that will be repeated.
arg2	Required	ApiRange | ApiName | number		A positive number specifying the number of times to repeat text.

Returns

string

Example

• Code
• Result

let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
worksheet.GetRange("A1").SetValue(func.REPT("Text", 3));