IBM i (AS400). Dynamic Excel functions available with iEXLExample 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 headingsSheet 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: Language code 2924iEXL: 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 4, 2017 9:40 PM
iEXL: Insertion of blank rowsiEXL now has the option to insert a specified number of blank rows before or after the row currently being processed.
Wednesday, December 9, 2015 1:23 PM
iEXL: Number of sheets extended to 9,999The 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