RPGLE with Excel

Posted on 2006-04-18
Medium Priority
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
  • 2
LVL 27

Accepted Solution

tliotta earned 500 total points
ID: 16481211

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

by:Dushan De Silva
ID: 16495905
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

by:Dushan De Silva
ID: 16531999
Sometimes following suggestions will hhelp for you.


BR Dushan

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you try to migrate from Elastix to Issabel, you will face a lot of issues. These problems are inevitable but fortunately, you can fix them. In the guide below, I will explain how I performed the migration while keeping all data and successfully t…
This blog will spread awareness about Dropbox. We have given the statements based upon our experience. Along with this, there is a section of some new plans that should be added in Dropbox this year. This will make the storage service enhanced from …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Is your organization moving toward a cloud and mobile-first environment? In this transition, your IT department will encounter many challenges, such as navigating how to: Deploy new applications and services to a growing team Accommodate employee…
Suggested Courses

612 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