RPGLE with Excel

Posted on 2006-04-18
Last Modified: 2012-06-21
Has anyone created any RPGLE programs that interact with Excel and the individual cells within a spreadsheet?  If so, Where could I get some documentation?  Thanks for any help
Question by:dhardy95
    LVL 26

    Accepted Solution


    There has been some work like this over the years with limited success. But the real efforts have been in using POI/HSSF via Java procedures called from RPG. Since Java and POI/HSSF have been far superior, I'm not sure anyone has pursued RPG-only solutions. If you have C programming that can do it, I suppose you could convert it to RPG IV; but that seems long way to go when useful functions are already available.

    Example that discusses technique --

    Googling on [ poi hssf rpg ] shows a number of discussions. The various iSeriesNetwork links are some of the highest quality.

    LVL 17

    Expert Comment

    Save you Excel sheet as CSV (comma seperated file) file. Then you can simply write a RPGLE program to read those  and fetch records .

    BR Dushan
    LVL 17

    Expert Comment

    Sometimes following suggestions will hhelp for you.

    BR Dushan

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Suggested Solutions

    Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
    If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now