Thanks for everyone's replies. Using the latest version of POI, I found good cellstyle duplication in this thread -- http://www.coderanch.com/t/420958/open-source/Copying-sheet-excel-file-another . Looks like they uniquely identify CellStyles by a hash, and then store those in a Map when they replicate cells. I adapted the code there to suit XSSF classes.
One thing i noticed with the CellStyle cloning process is that cell background/fill colors were not copied. Wasn't clear if that was a me problem or if there was something else going on, but for my purposes, everything else works great. - Dave -- View this message in context: http://apache-poi.1045710.n5.nabble.com/How-do-I-copy-cell-styles-tp5615723p5618222.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]
