The best place to start is alsways with the Quick Guide. More specifically, have a look here;
http://poi.apache.org/spreadsheet/quick-guide.html#MergedCells and here http://poi.apache.org/spreadsheet/quick-guide.html#CustomColors I know that you are not working with custom colours but the mechanism for setting the colour of the cell remains the same; HSSFCellStyle style = wb.createCellStyle(); style.setFillForegroundColor(HSSFColor.LIME.index); style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND); If you want to look at some more complete examples, then take a look at this page - http://poi.apache.org/spreadsheet/examples.html - which contains a number of complete workbooks worked as examples to demonstrate many of the api's features. Hope this helps. Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/pictorial-diagram-tp4290340p4290670.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
