Looks to me like all my crazy versions work egually well now. Must have been
something else, but nice call.
Even this crazy combo
workBook.setSheetName(0, "My First Sheet",workBook.ENCODING_UTF_16);
uglyStyle.setFillBackgroundColor(40);
workBook.getSheet("My First
Sheet").getRow(0).getCell(0).setCellStyle(uglyStyle);
Crazy stuff !!!
In Open office too!!
On 9/5/06, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> > As per normal I found an error in his code.
> >
> > <cfset cell.setCellStyle(uglyStyle)/>
> >
> > should be
> >
> > <cfset row.getCell(0).setCellStyle(uglyStyle)>
>
> Are you sure that's an error? The HSSF docs say that the createCell method
> of the row object returns the new cell, so you should be able to reference
> it directly as Dave Ross is doing.
>
>
> http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFRow
> .
> html#createCell(short)
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
>
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more information!
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252080
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
