Re: POI Classes for Excel

And if you dont know the name of the color or the number, I made some
changes to Scott's program COLORDEMO, 'cause I wanted to know how 
many colors I could select.

The title: HSSF POI Values for Color and Pattern 
and a SAVF can be found here: Think400.dk/downloads.htm
 
The other one... protection of certain cells. If I remember correct...  I 
haven't 
seen this one before, but if you make a solution... pls. let us know :-)

Best regards,
Leif

----- Original Message ----- 
From: <johnking@xxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: 1. august 2006 19:39
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