Skip to main content
Skip table of contents

f$Excel readname


f$Excel readname

Read the coordinates of a definite name. The data for the name range read is written into a parameter group with the parameters: Sheet, Left, Above, Right, and Below. The use of these name areas makes the set of rules independent of how the Excel sheets are distributed.

Syntax:

Status = f$Excel('ReadName', 'Name', 'PGName' )

German: Status = f$Excel ( 'Namelesen' , 'Name' , 'PGName' )

 

Argument

Type

Meaning

 

'ReadName'

String

Keyword

 

'Name'

String

Name of the name range in Excel

 

PGName

String

Name of the parameter group to which the information is written.

Result:

Integer

0: command executed successfully

Example:

Status = f$Excel('Workbook','open','c:\\temp\\test2.xls')
Status = f$Excel('Visible')
Status = f$Excel( 'ReadName', 'Datablock1', 'Excelname' )
p$TDV:Param:PGAnzeige( 0, 'Excelname' )
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.