Re: Custom colors in Excel with POI XSSF

I hear you on using a theme - but with POI you start with an empty slate - unless there is a way to base what you are doing on an existing file, you'd have to put in code to build the theme and apply it.

That might be possible, others will know better whether a "model" or "template" file is possible - I don't necessarily mean an Excel XLTX file.

But maybe, right?

Cheers
Vern

On 3/21/2019 2:20 PM, Booth Martin wrote:

I understand that.  My assumption is that if his existing process understands Excel instructions then probably it also has an instruction as to what theme to use.  If he can specify a theme then making a custom theme that he can use repeatedly would save him a ton of time.  If his shop is using a lot of Excel, chances are better than 50% that they already have a network place for custom Office themes. Saving his theme to the organization's network would most likely be a fairly routine step.

As to the out-of-network users....  that's a "Beyond this place there be Dragons" step that I won't tread.

After looking at the idea he may still reject it, but it's advantages make it deserving of a look-see.


On 3/22/2019 1:57 AM, Vernon Hamberg wrote:

Booth

Darren is trying to create Excel files on IBM i using POI - Office doesn't run there, so can't be used for this.

Of course, I could be missing what you mean, as well - and maybe the same the other way!!

Cheers
Vern