• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • IBM i Excel Spreadsheet Generator Now Unicode Compliant

    September 4, 2012 Alex Woodie

    iDATA Development recently delivered a new release of iEXL, its Excel spreadsheet generation software that runs on IBM i. With V3R2, the software is now Unicode compliant, which will enable Asian IBM i shops to take advantage of iEXL.

    iEXL is an IBM i program that generates Excel spreadsheets directly from DB2/400 files. The software is used by employees and managers who prefer to see and work with company data within the comfort of Microsoft Excel, as opposed to any of the other myriad ways of getting at the data, such as canned reporting tools, ad hoc query tools, or powerful direct-access database utilities.

    Using iEXL can be as simple as entering the names of up to 50 files, and watching as the software automatically converts the files into different workbooks in a spreadsheet. The software can be used with default settings, or it can be configured for more complicated workflows, such as by modifying an existing report program to output to a spreadsheet instead of a text-based report.

    Spreadsheets generated by iEXL can be consumed in several ways. The software can be configure to store the spreadsheets in the IFS, distribute them automatically via email, or immediately open them on the desktop. ZIP compression is also supported to keep spreadsheets from taking up too much storage.

    iDATA provides a green-screen menu system to configure the various iEXL settings. This gives the user fine-grained control over style settings, such as font and type size, cell and background colors, cell positioning, page breaks, worksheets, and so forth. Users can also insert images into their generated spreadsheets, and manipulate Excel functions via iEXL. Auto filters, sort sequences, and initialize and hide column functions are also supported.

    iEXL gives users options in how their DB2/400 files will be converted into Excel spreadsheets.

    iEXL is based on Apache APIs to access Microsoft Office formats. Specifically, it uses the Apache POI (“Poor Obfuscation Implementation”) project’s humorously named HSSF (“Horrible SpreadSheet Formula”) API. The project also makes other “horrible” APIs for generating Word and PowerPoint, and Publisher files, too.

    iDATA principle Mark Golden says he developed iEXL so that IT departments and users can use their existing knowledge to create spreadsheets. Users can get up and running very quickly with iEXL, since many of the options can be set as defaults, he says.

    With the latest release, V3R2, iEXL has been adapted to be Unicode compliant, enabling it to display double-byte character sets used by Asian languages. Golden says a handful of organizations from around the world have adopted iEXL over the years.

    Pricing is tier-based and starts at £3,000, or about $4,750 at current exchange rates. iDATA is based in the U.K., and its software is distributed in the U.S. through The Moore Consulting Group. For more information, see www.iexlsoftware.com.

    This article was corrected. iEXL is used by a “handful” of customers, not by hundreds of organizations. IT Jungle regrets the error.



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    VISUAL LANSA 16 WEBINAR

    Trying to balance stability and agility in your IBM i environment?

    Join this webinar and explore Visual LANSA 16 – our enhanced professional low-code platform designed to help organizations running on IBM i evolve seamlessly for what’s next.

    🎙️VISUAL LANSA 16 WEBINAR

    Break Monolithic IBM i Applications and Unlock New Value

    Explore modernization without rewriting. Decouple monolithic applications and extend their value through integration with modern services, web frameworks, and cloud technologies.

    🗓️ July 10, 2025

    ⏰ 9 AM – 10 AM CDT (4 PM to 5 PM CEST)

    See the webinar schedule in your time zone

    Register to join the webinar now

    What to Expect

    • Get to know Visual LANSA 16, its core features, latest enhancements, and use cases
    • Understand how you can transition to a MACH-aligned architecture to enable faster innovation
    • Discover native REST APIs, WebView2 support, cloud-ready Azure licensing, and more to help transform and scale your IBM i applications

    Read more about V16 here.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    System i Developer:  RPG & DB2 Summit, Oct 23-25 in Minneapolis. Register by Oct 12 to save $100!
    Profound Logic Software:  Webinar: Developing Mobile Applications for the IBM i. October 3
    Help/Systems:  2012 Solutions Summit. September 17-20 in Minneapolis, MN.

    IT Jungle Store Top Book Picks

    BACK IN STOCK: Easy Steps to Internet Programming for System i: List Price, $49.95

    The iSeries Express Web Implementer's Guide: List Price, $49.95
    The iSeries Pocket Database Guide: List Price, $59
    The iSeries Pocket SQL Guide: List Price, $59
    The iSeries Pocket WebFacing Primer: List Price, $39
    Migrating to WebSphere Express for iSeries: List Price, $49
    Getting Started with WebSphere Express for iSeries: List Price, $49
    The All-Everything Operating System: List Price, $35
    The Best Joomla! Tutorial Ever!: List Price, $19.95

    The Ethernet Switch Market Is Booming Future Coding

    Leave a Reply Cancel reply

Volume 12, Number 23 -- September 4, 2012
THIS ISSUE SPONSORED BY:

Profound Logic Software
Help/Systems
Townsend Security
Tembo Application Generation
Connectria Hosting

Table of Contents

  • Attachmate Add Features with MFT Update
  • Security Bundle Blocks Unwanted Web Traffic from Reaching IBM i
  • IBM i Excel Spreadsheet Generator Now Unicode Compliant
  • Maxava Taps Baseline to Resell HA in the Cloud
  • Trimble to Buy Trucking Software Firm TMW Systems for $335M
  • Indigo Chooses CNX’s Valence to Modernize RPG App
  • Liaison Grows Its Cloud with Acquisition of HubSpan
  • Equity Firm Merges Quadrant and Softbase, Eyes Further IBM i Acquisitions
  • ManageEngine Bolsters Performance Management Tools
  • IntelliChief to Provide Document Automation for B&L

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • Liam Allan Shares What’s Coming Next With Code For IBM i
  • From Stable To Scalable: Visual LANSA 16 Powers IBM i Growth – Launching July 8
  • VS Code Will Be The Heart Of The Modern IBM i Platform
  • The AS/400: A 37-Year-Old Dog That Loves To Learn New Tricks
  • IBM i PTF Guide, Volume 27, Number 25
  • Meet The Next Gen Of IBMers Helping To Build IBM i
  • Looks Like IBM Is Building A Linux-Like PASE For IBM i After All
  • Will Independent IBM i Clouds Survive PowerVS?
  • Now, IBM Is Jacking Up Hardware Maintenance Prices
  • IBM i PTF Guide, Volume 27, Number 24

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2025 IT Jungle