Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table plus
applyColStyleToCelltrue
heading0
columnTypess,s,s,s
multiplefalse
columnAttributesstyle="background:#e5e7ea;font-weight:bold,,style="background:#e5e7ea;font-weight:bold,
enableSortingfalse

Syntax

excelSetCurrentSheet(workbookFID, worksheet_name_or_index)

Package

excel

Alias

Pkg Usage

setCurrentSheet(workbookFID, worksheet_name_or_index)

Description

Excerpt
hiddentrue

Specifies the current sheet by name or index that subsequent processes should use.

Specifies the current sheet by name or index that subsequent processes should use.

Parameters

Table plus
applyColStyleToCelltrue
columnTypess,s,s,s
heading0
multiplefalse
enableSortingfalse

Parameter name

Type

Required

Description

workbookFID

Integer

Yes

The file id of the open workbook. The file id is returned from running the excelOpenWorkbook() routine.

worksheet_name_or_index

String

Yes

The name or index of the worksheet that should be set as current (index starts at 0).

Return Type

Boolean

Returns true if the operation was successful, false otherwise.

...

Result: A new row is first added to the Venemous Snake sheet then a new row is added to the Non-Venemous Snake sheet.

Note

Click here to download the workbook used in this example.

See also

Filter by label (Content by label)
showLabelsfalse
max25
showSpacefalse
cqllabel = "excel_routine" and space = currentSpace ( )
labelsarray_routines