Re: Excel Integration -- RPG400-L

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 to

programmatically 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.