GetSheet
function GetSheet(nameOrIndex: string | number = null): ApiWorksheet | "null"Description
Returns an object that represents a sheet.
Parameters
- nameOrIndex
string | numberdefault: null Sheet name or sheet index.
Returns
ApiWorksheet | "null"Try It
var oWorksheet = Api.GetSheet("Sheet1");
oWorksheet.GetRange("A1").SetValue("This is a sample text on 'Sheet1'.");