REPT
function REPT(arg1: string = null, arg2: number = null): stringDescription
Repeats text a given number of times. Use this function to fill a cell with a number of instances of a text string.
Parameters
- arg1
stringdefault: null The text that will be repeated.
- arg2
numberdefault: null A positive number specifying the number of times to repeat text.
Returns
stringTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.REPT("Text", 3));