RE: POI Classes for Excel

Thank you. 

I actually did create prototypes for setBackgroundColor (and setLocked) 
but I was shooting in the dark. I was hoping for some more specific help 
somewhere on the Apache site. I'll certainly go to iSeriesNetwork.com. for 
more help.

Inside the setBackgroundColor documentation, it says "It is necessary to 
set the fill style in order for the color to be shown in the cell." (I 
assume he means 'pattern', not 'style.) The example shown: 
        or, for the special case of SOLID_FILL: 
        cs.setFillPattern(HSSFCellStyle.SOLID_FILL );
        cs.setFillForgroundColor(HSSFSeCellStyle.RED);
So I think I'm going to need another prototype for setFillPattern. 

Anyway, thanks so much (again).

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



johnking@xxxxxxx 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
08/01/2006 01:39 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: POI Classes for Excel






 A continuting source of frustration for us old RPG'ers is mastering the
syntax of all these weird new languages... Scott's project didn't include
prototypes for every single thing - leaving many as an exercise for the
reader. The best thing is to learn to compare & contrast the POI
documentation with the RPG examples. Here is one to get you started.

 *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 * HSSFCellStyle_setFillBackgroundColor()
 *    Sets the background fill color of a HSSFCellStyle object
 *   bgcolor = color
 *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
D HSSFCellStyle_setFillBackgroundColor...
D                 PR                  ExtProc(*JAVA:
D                                     'org.apache.poi.hssf.-
D                                     usermodel.HSSFCellStyle':
D                                     'setFillBackgroundColor')
D    bgcolor                          like(jShort) value

 *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 * COLOR_XXX constants for calling HSSFFont_setColor()
 *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
D COLOR_AQUA...
D                 C                   49
D COLOR_BLACK...
D                 C                   8
D COLOR_BLUE...
D                 C                   12
D COLOR_BLUE_GREY...
D                 C                   54

JK

Goto www.iseriesnetwork.com & search the articles for HSSF

Scott Klement wrote several articles on this (as well as create the
service program you're probably using...)


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Arthur.Marino@xxxxxxxxxxxxxxxx
Sent: Tuesday, August 01, 2006 11:52 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: POI Classes for Excel

Ignorance is NOT bliss.

I've got the POI documentation and the RPGLE demo program.
The documentation on the APIs is all Java. The RPG demo uses prototyped
procedures like: HSSFCellStyles() and HSSFFont_setBoldweight(ChFont:
BOLDWEIGHT_BOLD);

Is there ANY documentation on the creation of OTHER prototyped procs for

RPG?
I need to PROTECT certain cells and also to set BACKGROUND COLOR to grey

in all input-capable cells.

Ignorance is HELL. Thanks for any help.

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