News
Abstract
The GENERATE_SPREADSHEET scalar function generates a file in the Integrated File System containing a spreadsheet based on either the results of a query or the complete content of a database file.
This scalar function relies upon the CLDownload feature provided by the IBM i Access Client Solutions (ACS) jar that ships on every IBM i. The ACS jar is delivered via the IBM HTTP SERVER FOR i PTF Group, and is found at this path: /QIBM/proddata/Access/ACS/Base/acsbundle.jar
Note: Launching IBM i Access Client Solutions will always start another service daemon job for the user that will show on IBM i as a QJVAEXEC job that will remain active. This is normal and can be referenced by subsequent launches of ACS by that user and should remain active.
Content
- A spreadsheet is generated with proportional width columns for xls and xlsx formats
Was this topic helpful?
Document Information
Modified date:
11 July 2024
UID
ibm17031280