There is an SO article that talks about this that might be a good start. https://stackoverflow.com/questions/52357448/creating-custom-color-styles-for-an-xssfworkbook-in-apache-poi-4-0
Thanks, Kevin Seymour | Sr. Architect, App Development o: 603-354-6195 c: 603-505-0180 -----Original Message----- From: Bengt Rodehav [mailto:be...@rodehav.com] Sent: Friday, March 25, 2022 11:48 To: POI Users List <user@poi.apache.org> Subject: Changing the color palette CAUTION: This email originated from outside of your organization. Do not click links or open attachments unless you recognize the sender and know the content. Please report any suspicious emails to IT Security. ____________________________________________________________ In order to reduce the number of styles used, I use the CellUtil class. However it only works if the colors are indexed colors. See: https://urldefense.com/v3/__https://bz.apache.org/bugzilla/show_bug.cgi?id=59442__;!!Os7eWUw!4B2EM9uJLp415Qpueb7vcsEWlNj-ISUyWI3mBkWE9oqUCFW49VeNzEOpkjeH5EEv4A$ So, I now only use indexed colors. But I'm not really pleased with the default colors and would like to change them. I know this was possible using the getCustomPalette() method of the HSSFWorkbook class. But how can I do this using the XSSF user model? Or is it possible to use both HSSF and XSSF? /Bengt --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
