The Excel Reader
Any Excel file in Excel format 2.1
Output to database
Generation of a new file
Assignment of Excel columns
Immediate display possible
Process Excel spreadsheets natively!
iGetExcel displays each Excel spreadsheet in a 5250 subfile. From here you start the transfer into a new or existing file. Convenient tools are available for assigning columns to fields, as well as extensive conversion options, for example for date fields.
iGetExcel processes the native Excel file formats XLS and XSLX, but it can also process all CSV files.
When executed in batch mode, an extensive plausibility check is carried out before the transfer so that only consistent data is transferred. If desired, however, a "as good as possible" transfer can also be carried out.
iGetExcel is responsible for importing Excel (XLS and XLSX). The import can either take place in new files or also insert in existing files.
A conversion of e.g. date fields from/to serial format can be configured as desired.
The products iExcelGen and iGetExcel can run interactively or fully automatically in the background via CL Command.