RE: Skipping Cells

[MWalter@xxxxxxxxxxxxxxx]

They're routines written in Java that will read and write MS type
documents, among other things. I've never really seen them used, especially
from within RPG, I just basically know that they exist.

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 02:15                                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
             <rpg400-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           




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.