In french: HImporteXLS
Available only with these kinds of connection
Imports an XLS or XLSX file into a data file in HFSQL Classic or Client/Server format (data file described in the data model editor, or declared by HDeclare
// Import "C:\MyFiles\Customer.xls" into the Customer data file.
// The Customer data file will be overwritten if it already exists (hImpCreation constant)
// A progress bar will be displayed in PROGBAR_ProgBar1
HImportXLS(Customer, "C:\MyFiles\Customer.xls", 1, "", hImpCréation, PROGBAR_ProgBar1)
<Result> = HImportXLS(<Data file> , <Path of the XLS or XLSX file> [, <Worksheet number> [, <List of destination items> [, <Options> [, <Progress Bar>]]]])
- True if the operation was performed,
- False if an error occurred.
HError is used to identify the problem.
<Data file>: Character string
Name of the HFSQL data file into which the import must be performed.
Remark: If the HFSQL data file used does not physically exist, it will be automatically created.
<Path of the XLS or XLSX file>: Character string
Full access path to XLS or XLSX file to import.
Only the XLSX files can be used.
<Worksheet number>: Optional integer
Worksheet number in the XLS or XLSX file to import.
If this parameter is not specified, the first worksheet in the XLS or XLSX file will be imported.
<List of destination items>: Optional character string
List of names of items in the data file into which the import will be performed. The names can be delimited by single quotes and they are separated by commas or CR characters.
The names of the composite key items, binary memo items and binary items are ignored.
The non-imported items will be initialized with their default value described in the analysis.
If this parameter is not specified or if it corresponds to an empty string, all the items are imported (except the composite keys, the binary items and the binary memos) in the physical order of description.
<Options>: Optional Integer constant (or combination of constants)
Configures the type of import to perform:
<Progress Bar>: Optional control name or window name
- Name of the window in which the progress bar will be displayed,
- Name of the Progress Bar control.
This parameter is not available.
This page is also available for…