Read excel file to iSeries using RPGLE and JAVA
Home > IT Answers > AS/400 > Read excel file to iSeries using RPGLE and JA...
Heidiltl
0 pts.
0
Q:
Read excel file to iSeries using RPGLE and JAVA
RPGLE
I am trying to read an excel file to iSeries platform using combination of RPGLE and JAVA. Is anyone done this before and get it to work? Please advise.
ASKED: Jul 31 2006  9:51 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
DaddyCOZ
0 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
yes, this works great! You can read, update and create Excel spreadsheets. The solution is based on the Jakarta POI project.

Scott Klement wrote some articles for iSeries Network that explain how to use Java POI/HSSF classes to read and write directly to Excel spreadsheets.

see this URL: http://faq.midrange.com/data/cache/533.html

Or, just google on "rpg excel Klement"
Last Answered: Jul 31 2006  10:35 AM GMT by DaddyCOZ   0 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

DaddyCOZ   0 pts.  |   Jul 31 2006  10:35AM GMT

yes, this works great! You can read, update and create Excel spreadsheets. The solution is based on the Jakarta POI project.

Scott Klement wrote some articles for iSeries Network that explain how to use Java POI/HSSF classes to read and write directly to Excel spreadsheets.

see this URL:  <a href="http://faq.midrange.com/data/cache/533.html" title="http://faq.midrange.com/data/cache/533.html" target="_blank">http://faq.midrange.com/data/cache/533.h…</a>

Or, just google on “rpg excel Klement”

 
0