In this section: |
This section describes new features for Sequential and Indexed adapters.
The Adapter for Excel (via direct retrieval) is available as a named adapter on the Web Console in the Sequential and Indexed folder. It supports direct retrieval from Excel files (.xls and .xlsx files). The adapter uses the Apache POI, which is a Java API that provides access to Microsoft file formats.
The suffix is DIREXCEL. This example creates a synonym:
CREATE SYNONYM baseapp/name FOR baseapp/name.xlsx DBMS DIREXCEL PARMS 'WORKSHEET Sheet1 HROWS 1 RECORDS 1000'
A DATASET parameter or a FILEDEF for a flat file can use an asterisk (*) as a wildcard to represent multiple files. To identify which file (of many) that a record comes from, you can add a field with an ALIAS of INSTANCE to the Master File. When used in a SELECT, TABLE, or MODIFY procedure, that field will have the name of the specific file.
WebFOCUS |