Re: How to apply filter to a sheet in RPG. (HSSFR4, POI, Spreadsheet)

Vern, thanks.

Right. I have some additional things i've aggregated/found-on-list/etc
thru the years but have not incorporated them into his srvpgm.
When needed, i copy them into the program.

The filter Don pointed out is one of them. (thanks to original? poster) I
love putting the filters on columns/ranges. . . I'd just like to be able
to tweak their contents.
Heck, i love outputting to spreadsheets. After having to worry about
field lengths and fitting things on DDS reports etc, it's so liberating to
NOT have to worry about such things.
(kinda like going all free code)

It'd be a nice to have (someday). My starting point being this list and.
. if you don't ask, you'll never know.

One of the usual gurus on the list pointed out the steps to do what you
indicate below, (in a reply a few years back). I still have them, maybe
i'll dig them out when this reaches critical mass with me.
(if i do i'll share)

Just thought i'd try the easy way first. :-)

John


<snip>
Hi John

Since you're using Scott's POI service program, right? It can do only
the things from POI that Scott elected to include.

POI has many other functions that are not yet in the SRVPGM, and you can
certainly add what you need to it. Once added, you could share it, to
the benefit of all.

It isn't too complicated to add things there - as I recall, all the
calls to Java methods are similar in design.

Good luck!
Vern
</snip>
<br />
The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else is
unauthorized. If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it, is
prohibited and may be unlawful.