Richard White wrote: > however i cannot seem to work out how to set the borders and border styles. i > know it is possible as they are available in the jxl.format library but > cannot work out how to apply them to a cell
you need to use the Label class & apply a format created using the WritableCellFormat class, something like: <cfscript> // common objects cellColor=createObject("java","jxl.format.Colour"); border=createObject("java","jxl.format.Border"); borderLineStyle=createObject("java","jxl.format.BorderLineStyle"); // create format cellFormat=createObject("java","jxl.write.WritableCellFormat").init(); cellFormat.setBorder(border.ALL,borderLineStyle.THIN,cellColor.BLACK); cellFormat.setBackground(cellColor.BLUE); // do the label w/formatting thisLabel=createObject("java","jxl.write.Label").init(1,1,"A Label",cellFormat); </cfscript> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311396 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4