You can reuse the cell style objects. You only need to ceate as many cell styles objects as you need different cell styles then apply each to as many cells as necessary; it is not the case that you need to create a new cell style object for every cell..
Yours Mark B Khanh Tran-3 wrote: > > Hello POI users, > > On Excel VBA, we can set cell attribute by using CellFormat object, and no > need to create any new CellStyle Object. Is there a way to do that with > POI? > > It seems like we always need to create new cell style when setting cell > appearance attributes. This lead to so many cell style created in the > target > spreadsheet. > > Thanks. > > > > > -- View this message in context: http://www.nabble.com/Set-cell-color-without-creating-new-cell-style-tp25000416p25001221.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]
