跳到主要内容

GetRows

Returns the ApiRange object that represents all the cells on the rows range.

Syntax

expression.GetRows(value);

expression - A variable that represents a ApiWorksheet class.

Parameters

NameRequired/OptionalData typeDefaultDescription
valueRequiredstring | numberSpecifies the rows range in the string or number format.

Returns

ApiRange | null

Example

This example shows how to get the ApiRange object that represents all the cells on the rows range.

// How to get all row cells.

// Get all row cells from the worksheet.

let worksheet = Api.GetActiveSheet();
worksheet.GetRows("1:4").SetFillColor(Api.CreateColorFromRGB(255, 213, 191));