IBM i (AS400). Dynamic Excel functions available with iEXL

Example Function using OFFSET. Example work file. Notice the OFFSET value has been set to minus 1 The field OFFSET can be named anything you like. The value of minus one has been entered in this example as fields Jan, Feb and Mar fields only contain positive values. The value minus one can be any value that is guaranteed not to appear in any other numeric field/cell. Only place minus one in the OFFSET field where you would like the function to be placed. Create function withi...

Saturday, March 14, 2020 8:24 AM

iEXL: Sheet specific column headings

Sheet specific column headings are now available in iEXL. This allows you to change column headings for each sheet within a workbook. For instance you may need to specify a different division code on each sheet within the same workbook.

Sunday, January 21, 2018 10:18 AM

iEXL: New release V4R1M1 available for download. 21st June 2017. IBM i (AS400)

iEXL: New release V4R1M1 available for download. 21st June 2017. This new release allows for the generation of .Xlsx spreadsheets. Also various new formatting options.

Friday, June 23, 2017 2:21 PM

iEXL: New spreadsheet protection options. IBM i (AS400)

iEXL: New spreadsheet protection options. Replicates the selection window that appears when a spreadsheet is protected.

Wednesday, June 21, 2017 2:22 PM

New iEXL version V4R1M1. IBM i (AS400)

iEXL: Now upgraded to version V4R1M1 which will generate both .Xls and .Xlsx spreadsheets.

Wednesday, June 21, 2017 2:20 PM

iEXL: .Xls and .Xlsx generation. IBM i (AS400)

iEXL: Now upgraded to generate both .Xls and .Xlsx spreadsheets.

Wednesday, June 21, 2017 2:18 PM

iEXL: Language code 2924

iEXL: Installation of iEXL no longer requires the language code of English 2924. iEXL will install and work on all Latin-1 based servers.

Thursday, May 04, 2017 9:40 PM

iEXL: Include/Exclude fields within a DB2 file

iEXL: New option to Include/Exclude and sort fields within a DB2 file for a spreadsheet.

Thursday, April 07, 2016 1:30 PM

iEXL: Insertion of blank rows

iEXL now has the option to insert a specified number of blank rows before or after the row currently being processed.

Wednesday, December 09, 2015 1:23 PM

iEXL: Number of sheets extended to 9,999

The number of sheets within an Excel workbook generated by iEXL has been extended to 9,999. All of the sheets can be individually named. For more information please see WWW.iEXLSOFTWARE.COM

Thursday, November 26, 2015 5:53 PM