IBM Support

SYSTOOLS.GENERATE_SPREADSHEET

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

You are in: IBM i Technology Updates > Db2 for i - Technology Updates > IBM i Services (SQL) > SYSTOOLS.GENERATE_SPREADSHEET
 
For complete detail, visit this IBM Documentation page: GENERATE_SPREADSHEET scalar function
 
Enhanced with IBM i 7.6 SF99960 Level 3 & IBM i 7.5 SF99950 Level 12:
  • Option added to provide a sheet name
Enhanced with IBM i 7.6 SF99960 Level 2 & IBM i 7.5 SF99950 Level 11:
  • Options added to provide a stored query as input, to replace or update the output, to specify the sheet, row, and column to start writing, and to kill the daemon threads at completion

Enhanced with IBM i 7.5 SF99950 Level 7 & IBM i 7.4 SF99704 Level 28:

  • A spreadsheet is generated with proportional width columns for xls and xlsx formats

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001go6AAA","label":"IBM i Db2-\u003ESQL Services \/ table functions"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.4.0;and future releases"}]

Document Information

Modified date:
29 June 2026

UID

ibm17031280

Page Feedback