× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.