GetSheet
Returns an object that represents a sheet.
Syntax
expression.GetSheet(nameOrIndex);
expression
- A variable that represents a Api class.
Parameters
Name | Required/Optional | Data type | Default | Description |
---|---|---|---|---|
nameOrIndex | Required | string | number |
Returns
ApiWorksheet | null
Example
This example shows how to get an object that represents a sheet.
var oWorksheet = Api.GetSheet("Sheet1");
oWorksheet.GetRange("A1").SetValue("This is a sample text on 'Sheet1'.");