RPG Excel - Home Page
     
RPG Excel - Home Page
   
RPG Excel - Home Page

Example 1 RPGLE source

Example 1 RPGLE free form source

Example 2 RPGLE source

Example 2 RPGLE free form source

Example 3 -Updating an existing worksheet

Example 4 -Read a workbook and update an As400 File

View example 1 Excel file
Excel Sheet

View example 2 Excel file
Excel Sheet













RPG Excel - Home Page

RPG Excel is a tool that allows you to effortlessly create or update existing Excel spreadsheets directly from either existing or new iSeries / AS400 RPG programs.

Features:

  • Create Excel Spreadsheets directly from your RPG programs.
  • Update Existing Excel Spreadsheets directly from your RPG programs.
  • Retreive a cell value from an Existing Excel Spreadsheet directly from your RPG program.
  • Format Excel Spreadsheets using easy to use commands.
  • Create Cell Formulas from within the RPG program.
  • Commands included allow setting Font Sizes, Colors, Print Options, Cell Formatting, Cell Properties, Custom Headers & Footers and more.
  • Create multiple sheets within a Workbook.
  • Writes Excel Workbooks directly to your IFS from within your RPG program.
  • Update ISeries PF records from Excel Workbooks.

RPGExcel is different from other programs that simply take an existing spool file or comma separated file and move it into Excel. RPG Excel allows programmers to create and format an Excel Spreadsheet directly from within an RPG program with direct row and cell creation using Excel formatting.

System Requirements:

  • OS400 V5.R2 or higher
  • RPGLE
  • Try our FREE 30 day evaluation !!!!

      Version:      1.03 (Sept 2008)
      File:   rpgexcel.zip   3.9 MB
      Price :   $ 1200.00 USD