iexl blog | iexl software

iexl sofware blog | iexl updates | iexl information | iexl news | AS400 | iSeries

The latest version of iEXL is now available from iEXLSOFTWARE.COM. The product now contains the following options for your spreadsheet design.

  • Fonts

  • Colors

  • Background and Text

  • Text rotation

  • Text underline

  • Text alignment both horizontal and vertical

  • Edit codes

  • Column headings

  • Functions/Formula

  • Merge cells

  • Hide columns

  • Sort functionality

  • Password

  • Images

  • Freeze Pane

  • Page Heading & Footers

  • Text insertion

  • 50 DB files per workbook

  • UNICODE data processing

  • Data triggers

  • Borders and Grids for document design

  • Individual cell protection

  • Insertion of blank row

  • Ability to select and sort fields from a DB file

  • Recognition of default values for IBM i Date and time fields

  • Emails and much more.

 All the options above can be used by RPG, SQL, JAVA, QUERY400 software. No API calls required. Design the file and off you go to professional spreadsheets. 

We can be contacted at iEXLSOFTWARE@GMAIL.com 

iEXL: Mutiple named sheets extended to 9,999 within a workbook.

See WWW.iEXLSOFTWARE.com for more information.

iEXL has been extended to allow up to 9,999 individually   named sheets within a Excel workbook.

 

 

iEXL: Alias Email.

iEXL now has the option to email spreadsheets with any name.

Normally iEXL would use the physical file name in the email that was used to produce the spreadsheet. Now you can use the email Alias option to name the spreadsheet that is sent in the email. You could give it a specific invoice or purchase order number with text.

For more information please see iEXL home page

 

 

 

 

AS400 Spreadsheets

No comments

iEXL: Native, fully formatted Excel spreadsheets.

www.iexlsoftware.com

Options include.

  • Fonts

  • Colors

  • Background and Text

  • Text rotation

  • Text underline

  • Text alignment both horizontal and vertical

  • Edit codes

  • Column headings

  • Functions/Formula

  • Merge cells

  • Hide columns

  • Sort functionality

  • Password

  • Images

  • Freeze Pane

  • Page Heading & Footers

  • Text insertion

  • 50 DB files per workbook

  • UNICODE data processing

  • Data triggers

  • Borders and Grids for document design

  • Emails and much more.

 

 

Transform you existing Query400 reports to fully formatted Excel spreadsheets direct on AS400, IBM i, Power Systems.

For more information see http://www.iexlsoftware.com

iEXL

No comments

iEXL: Default date and time field values.

iEXL has been updated to deal with defaults for date and time fields within DB2 files.

iEXL has been updated to deal with date and time field default values. The system will now treat default values for these fields as blanks. This stops them appearing in spreadsheets as real values within cells.

 

For  more information please see www.iEXLSOFTWARE.COM 

RPG Excel

No comments

AS400 IBM i native Excel spreadsheet.

Design/Develop genuine Excel spreadsheets on the AS400, iSeries, i5, IBM i on power.

Use RPG, SQL, JAVA, Query etc to create fully formatted Excel spreadsheets.

See www.iexlsftware.com for more information.

AS400 IBM i native Excel spreadsheet.

Design/Develop genuine Excel spreadsheets on the AS400, iSeries, i5, IBM i on power.

Use RPG, SQL, JAVA, Query etc to create fully formatted Excel spreadsheets.

See www.iexlsftware.com for more information.

AS400 IBM i native Excel spreadsheet.

Design/Develop genuine Excel spreadsheets on the AS400, iSeries, i5, IBM i on power.

Use RPG, SQL, JAVA, Query etc to create fully formatted Excel spreadsheets.

See www.iexlsftware.com for more information.

 

iEXL

No comments

iEXL Column level cell protection

iEXL now has column level cell protection.

Via new screen options complete columns can be protected,

www.iexlsoftware.com