ImportExcel

concerns

The ImportExcel attribute function imports the records from an Excel workbook in the format specified by the ExportExcel function.

 

Syntax

ImportExcel(FileName [, SheetIndex][, FirstRow][, FirstCol])

Return value

None

Parameter

Use

Name

Type

Passing

Description

Required

FileName

String

ByVal

Name of the Excel file.

Optional

SheetIndex

Long

ByVal

Index of the sheet into the workbook
Standard is 1

Optional

FirstRow

Long

ByVal

The line number from which the data was entered into the sheet.
Standard is 1

Optional

FirstCol

Long

ByVal

The column number from which the data was entered into the sheet.
Standard ist 1