Re: Direct update to Excel spreadsheets

["David A Parnin" <daparnin@xxxxxxxxxxxxxxxxxx>]

If you just want to populate/update files in an Excel spreadsheet with
AS/400 data then Showcase can do the trick.  Every time you open the
spreadsheet it prompts you to update the links or to keep the current data.
You can break the links if you want the data to remain static in the
spreadsheet.  You can send the spreadsheets to people without Showcase and
they can still open them.  If the amount of data expands and contracts it
can dynamically adjust the cells below.

It sounds like you want to extract from Excel on to the AS/400 although the
links you provided seem to be for things that go the other way.

Dave Parnin
Nishikawa Standard Company
Topeka, IN  46571
daparnin@xxxxxxxxxxxxxxxxxx




                                                                                
                              
                      rob@xxxxxxxxx                                             
                              
                                               To:       
MIDRANGE-L@xxxxxxxxxxxx@SMTP@CTB                     
                      12/17/2003 10:47         cc:                              
                              
                      AM                       Subject:  Direct update to Excel 
spreadsheets                  
                      Please respond to                                         
                              
                      Midrange Systems                                          
                              
                      Technical                                                 
                              
                      Discussion                                                
                              
                      <midrange-l@midra                                         
                              
                      nge.com>                                                  
                              
                                                                                
                              
                                                                                
                              



The PHB is purchasing this application that runs on a PC.  It will poll
the PLC's and update well defined cells in an Excel spreadsheet.  Now he
wants a tool that will run on the iSeries that will go out to that PC,
open up that spreadsheet, and extract data from just those cells.

Years ago I had looked at an application that would not only read, but
could update, cells on a Lotus spreadsheet stored in a shared folder on
the 400.  I've lost all documentation on that product.  My question is
"Anyone know of such a product?"

Boss does NOT want the PC's spreadsheet stored on the iSeries.

My argument was to use a socket program on the iSeries to poll the PLC's
directly but I lost out.  Goes to show you that sometimes you need to take
the time to learn new technology even when you don't have a current need
so that you can be more useful, immediately, when the need arises.  "One
of these days" I'll take that sockets tutorial.

Rob Berendt
--
"All creatures will make merry... under pain of death."
-Ming the Merciless (Flash Gordon)
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.