|
Arthur, My Java guys use POI. Not that there's not anything better yet, but we haven't found it. Our RPG types use CVTDBFXLS and CVTXLSDBF from Kemetech to create spreadsheets and get data from spreadsheets into DB2 tables. http://www.kemetech.com They have a new product coming this month that will allow you toprogrammatically manipulate Excel files. I'm looking forward to it. Their stuff is good, and really inexpensive.
We also have SEQUEL from ASC and use that a great deal to create spreadsheets, but it doesn't go the other direction. Mike E. On 4/28/06, Arthur.Marino@xxxxxxxxxxxxxxxx <Arthur.Marino@xxxxxxxxxxxxxxxx> wrote:
I hesitated to mention the POI classes for 2 reasons: Though I'm going to get an 'A' in my 1st semester of Java at the local community college, I'm not quite there yet in terms of being able to actually DO anything practical in the language, and I wasn't sure if the POI classes were perhaps old stuff no longer used by the cognoscenti. But like I said, I'm still a Java novice anyway. Thanks for the repsonses (so far) everybody. Arthur J. Marino "Hatzenbeler, Tim" <thatzenbeler@xxxxxxxxxxxxx> Sent by: rpg400-l-bounces@xxxxxxxxxxxx 04/28/2006 04:47 PM Please respond to RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx> To "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx> cc Subject RE: Excel Integration If you're good with excel, you could do a little vba coding, to add some drop down menus for retrieving, and uploading the data. I use ADO (odbc) to retrieve files, into sheets 1 and 2, and then sheets 3-6 are updated pivot tables with graphs. You could easily, reverse the process, and insert worksheet data via odbc calls back to the iseries. The hiccup would be, you would have to install odbc drivers on the computers who are refreshing the data... ... If your working only with rpg in mind... I would recommend POI Tim -----Original Message----- From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Michael_Schutte@xxxxxxxxxxxx Sent: Friday, April 28, 2006 1:29 PM To: RPG programming on the AS400 / iSeries Subject: Re: Excel Integration Just a thought off the top of my head. Could you set up two holding files, one for downloading and one for uploading? When someone needs to get data, they can enter Excel, Data --> Transfer Data From iSeries. Save that data, then go do their editing. When done, they could go back to Data --> Transfer Data To iSeries. but uploading to the other file. Maybe that's too much. Just it's just a thought. Michael Schutte Arthur.Marino@so- container.com Sent by: To rpg400-l-bounces@ rpg400-l@xxxxxxxxxxxx midrange.com cc Subject 04/28/2006 04:12 Excel Integration PM Please respond to RPG programming on the AS400 / iSeries <rpg400-l@midrang e.com> I'm fairly desperate to have my RPG programs interact with Excel spreadsheets so field people can do their budgeting off-line. I need to be able to create the workbook and later be able to read rows/columns from it. Simple .csv files are not going to cut it. Does anyone know of an iSeries/Excel product that fits the bill? Any help will be appreciated. Arthur J. Marino -- This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. -- This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. -- This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. -- This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact copyright@midrange.com.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.