Re: Using Java in RPGLE - cell comments and document properties

["Peter Dow" <maillist@xxxxxxxxxxxxxxx>]

Thanks Matt, Mike!

That's a good idea about the template spreadsheet Matt; the sample program
Scott provided reads in a spreadsheet, modifies it, and writes it out, which
should work for my purposes -- the Jakarta website says they've tried very
hard not to disturb records they don't operate on so that this kind of thing
will be possible.

If I knew enough Java it would be fun to try adding a NOTE record.

That just reminded me of something else.  When I was running Scott's demo
programs, I failed to put enough records in the DIVSALES physical file
that's used to populate the spreadsheet, and as a result, the cell that the
update program was going to modify did not exist, and Java threw an
exception.  Is there some way to test for the existence of a cell before
trying to read it?  Or to catch the Java exception?

Peter Dow
Dow Software Services, Inc.
909 793-9050 voice
909 793-4480 fax
951 522-3214 cell



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.802 / Virus Database: 545 - Release Date: 12/3/2004