Skip to main content
Skip table of contents

f$Excel create sheet


f$Excel create sheet

Create a new sheet in the current Excel workbook. If the sheet already exists, the status –2 is returned. The error message from Excel can be obtained with: f$Excel(’Error’, ParameterName ).

Syntax:

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

 

Argument

Type

Meaning

 

'Sheet'

String

Keyword

 

'create'

String

Keyword

 

Name

String

Name of the sheet to be created.

Result:

Integer

0: command executed successfully

Example:

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

JavaScript errors detected

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

If this problem persists, please contact our support.