RE: Skipping Cells

["Haas, Matt" <Matt.Haas@xxxxxxxxxxx>]

It's part of an Apache project called POI. Take a look at 
http://jakarta.apache.org/poi/index.html.

Matt

-----Original Message-----
From: Bob O. [mailto:otis_the_cat@xxxxxxxxxxx]
Sent: Tuesday, March 01, 2005 2:16 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Skipping Cells


Enlighten me...  What are HSSF routines?  I never heard of it.




>From: MWalter@xxxxxxxxxxxxxxx
>Reply-To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
>To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
>Subject: RE: Skipping Cells
>Date: Tue, 1 Mar 2005 14:07:02 -0500
>
>Does the process need to be seamless? That is, without intervention? You
>could use RPG to build your outfile, then use Client Access to populate the
>spreadsheet. Although, the HSSF routines look intriguing. But then again, I
>wouldn't want to frustrate Scott with some of my convoluted processes! :-)
>(All in good fun).
>
>Thanks,
>
>Mark
>
>Mark D. Walter
>Senior Programmer/Analyst
>CCX, Inc.
>mwalter@xxxxxxxxxx
>http://www.ccxinc.com
>
>
>
>              "Bob O."
>              <otis_the_cat@hot
>              mail.com>                                                  To
>              Sent by:                  rpg400-l@xxxxxxxxxxxx
>              rpg400-l-bounces@                                          cc
>              midrange.com
>                                                                    Subject
>                                        RE: Skipping Cells
>              03/01/2005 01:59
>              PM
>
>
>              Please respond to
>               RPG programming
>               on the AS400 /
>                   iSeries
>              <rpg400-l@midrang
>                   e.com>
>
>
>
>
>
>
>What I meant by "grab the data" was that I was going to use an output file
>to hold the records I need to populate the spreadsheet.  From what you all
>were saying about VBA modules/macros and such is beyond my knowledge
>(unfortunately).  Of the three of us that work here, none of us know Visual
>
>Basic.  Just three old-school RPG programmers here.
>
>
>
>
> >From: "Bob O." <otis_the_cat@xxxxxxxxxxx>
> >Reply-To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
> >To: rpg400-l@xxxxxxxxxxxx
> >Subject: Skipping Cells
> >Date: Tue, 01 Mar 2005 10:34:45 -0600
> >
> >I have a project where I need to grab data from the as400 via an RPG
> >program and dump it into an existing excel spreadsheet.  There are cells
>on
> >the spreadsheet that perfrom calculations.  I need to "skip" over these
> >cells so as not to overwrite the formulas.  Is there a way to accomplish
> >this?
> >
> >
> >--
> >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.