跳到主要内容

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

NameRequired/OptionalData typeDefaultDescription
arg1RequiredApiRangeApiNamestring
arg2RequiredApiRangeApiNamenumber

Returns

string

Example

var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.REPT("Text", 3));