Skip to main content
Skip table of contents

f$Excel open sheet


f$Excel open sheet

Open a sheet in the current Excel workbook. If the sheet does not exist, the status –6 is returned.

Syntax:

Status = f$Excel('Sheet', 'open', Name )

 

Argument

Type

Meaning

 

'Sheet'

String

Keyword

 

'Open'

String

Keyword

 

Name

String

Name of the sheet to be opened.

Result:

Integer

0: command executed successfully

Example:

Status = f$Excel('Workbook','open','c:\\temp\\test2.xls')
Status = f$Excel('Sheet', 'Open', 'Calculation')
Status = f$Excel('Cell', 'set',2,1, '1')
Status = f$Excel('Close',0)

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.