Re: Custom colors in Excel with POI XSSF

Hi Vern,

With POI you can also read a spreadsheet, so the idea is, create a template spreadsheet that already has formatting applied to rows/columns/cells, have your RPGLE program read it, then populate it with data, and write out a new spreadsheet.  You can also add markers in certain cells so your program knows where to place certain data, kind of like host variables in an SQL statement.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /

On 3/22/2019 12:47 AM, Vernon Hamberg wrote:

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

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus