iExcelGen

What is iExcelGen?

iExcelGen is an Excel generator for IBM i (POWER i/AS/400) that converts data from your IBM i environment into genuine Microsoft Excel files. The output is generated directly ‘full native’ on the system without additional PC or Java components and is stored in the Integrated File System (IFS). This makes iExcelGen particularly suitable for companies that use Excel as the standard format for reporting, controlling or data exchange and want to reliably automate these processes on IBM i.

iExcelGen processes physical and logical files as well as query and SQL results as data sources; spool data can also be used as input. For professional reports, iExcelGen supports template handling, which allows you to specify formatting, formulas, logos, pivot tables and charts and then have them filled automatically. In addition to XLS/XLSX, exports to CSV, XML or HTML are also possible, depending on the application.

Another key feature is distribution: after generation, the integrated email client sends the files directly to individual recipients or to defined recipient groups. In automated scenarios, sending can also be controlled, e.g. with CC, optional read confirmation, bundling of multiple attachments into one package or automatic deletion of the generated file after sending.

Advantages for your company

You reduce manual intermediate steps and accelerate the provision of evaluations – from nightly batch jobs to ad hoc management overviews. By integrating it into your own CL programmes and job schedulers, you can create reproducible Excel exports that are consistent in terms of content and appearance. You also benefit from practical features such as Unicode/UTF-8 support, simple administration and the ability to make adjustments yourself. According to the provider, the licence/pricing model is based on the system model/processor and, if applicable, the number of LPARs; a fast ROI is explicitly addressed as the target.

Highlights and important features

• Native Excel generation on IBM i: Creation of XLS/XLSX directly in IFS – without PC or Java dependencies.
• Broad input support: Data from DB files (physical/logical), queries, SQL and spool data.
• Template function for layout & analysis: Integration of corporate design, formulas, pivot tables and charts.
• Multi-format output: Optional export to CSV, XML and HTML.
• Integrated email client: Send to individuals or recipient groups; ideal for report distribution.
• Controllable sending process: Includes CC, read confirmation, attachment bundling and automatic deletion after sending.
• Update and API function: Update existing Excel files sheet by sheet or cell by cell.
• Automation-capable: Call via command/CL, suitable for batch operation and recurring jobs.
• Optional spool add-on: For classic reports including multi-line formats; assignment of Excel columns to database fields and generation/update of existing files.

If you want to convert your IBM i data more quickly into meaningful, well-formatted Excel reports and distribute them automatically to internal or external recipients, iExcelGen supports you with a consistent, IBM i-native approach.

Contact the provider to coordinate data sources, template strategy, automation and dispatch workflows for your organisation.