RE: Excel/POI The Final Frontier

The path and file name is: 
'/bq_budgets/inbound/dayton/B7_DAYT_S001_JOHNSMITH_QQ.xls'. 

All workbooks for Dayton salesmen were created in one run and all given a 
single group-sequence-number (001, in this example) in my control file. 
(Each salesman workbook created in the run has it's own unique 
book-sequence-number within 001.) 

When it's time to read Dayton workbook(s) back in, the user will refer to 
that sequence number (001) even though, in this example, only John Smith's 
workbook is there to be read. 

I want it to process all workbooks that exist in the folder. The problem 
is that if TOM JONES' workbook is defined in group 001, the HSSF_open 
fails and then so does every successive _open. 

I'm now checking existence with DSPLNK (*PRINT) before I attempt to do the 
_open, but it's kind of inelegant.

Arthur J. Marino
Southern Container Corporation
(631) 231-0400 x133



"Phil Kestenbaum" <pkestenbaum@xxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
08/23/2006 03:35 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
RE: Excel/POI The Final Frontier






Are they in a heavily nested set of folders?

What is the length of the full path plus the errant workbook names?
There is a limit.

If you have multiple references to the other files in your formula, then
you will expand every reference by the length of the full file path.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Arthur.Marino@xxxxxxxxxxxxxxxx
Sent: Wednesday, August 23, 2006 2:26 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Excel/POI The Final Frontier

First, thanks to all, particularly Scott Klement, for all your guidance.

The spreadsheets I'm creating are perfect, just what the project
requires. 
And reading them back in is even easier. Again, thanks to all.

Before I put out an email outlining what I've learned, I have just 1
more 
question (and 1 wish):

The question:
When running the workbook 'inbound' function, if there's a failure in
the 
"book = HSSF_open(file_name)" loop because a given workbook in the group

doesn't exist in the path, then no 'open' works after that even though 
subsequent workbook(s) in the group do exist. The monitor group around
the 
'open' just prevents the halt, subsequent existing book(s) still fail on

the open. I've tried "HSSF_end_object_group()" (in the on-error) but
that 
fails as well. (I know the program logic is good because if I'm specific

about the single workbook I want to read, it retrieves it just fine.
What 
should I be doing after an 'open' legitimately fails? Or do I have to do

an existence test in the IFS before I attempt the HSSF 'open'? 

The wish:
If there's a way to protect the sheet(s) of a workbook and the workbook 
itself (with a password) from within my creation program, I'll die a
happy 
man.

Again, thanks for all your help.

Arthur J. Marino
Southern Container Corporation
(631) 231-0400 x133