> 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:252068 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
