Re: Direct update to Excel spreadsheets

As luck would have it, I'm currently working on an article for the Club
Tech iSeries Programming list over at iSeriesNetwork.com which explains
how to use the POI java classes to parse an Excel spreadsheet.

I was planning to publish this article on the list on Jan 8th.

As for retrieving it from a PC, you should be able to use either FTP or
/QNTC to do that... that part should be easy.


On Wed, 17 Dec 2003 rob@xxxxxxxxx wrote:

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