On 12/21/2015 6:06 AM,
giovanni.arturi@xxxxxxxxx wrote:

In a IFS Folder i have stored a Xls file; i would need to know if is it
possible (with RPG/HSSF) , update the xls file in such way to set the automatic
filter for all colunms

You need to be using a recent version of POI. There is no documentation
at the POI web site:
http://poi.apache.org/apidocs/org/apache/poi/xssf/usermodel/XSSFAutoFilter.html

Keep in mind that i don't have any experience in HSSF , so if possible to do
how i have requested , i would be grateful if some one could suggest me some
example

You may have better luck on the RPG mailing list if you want an RPG
example. But please understand that setting up POI will go a lot easier
if you have Java experience. In this regard, consider setting up POI on
your PC, and using an example in Java that updates a spreadsheet. Here
is one that is sort of what you are looking for:
http://stackoverflow.com/questions/3114220/poi-auto-filter

Once you have done this in Java, you will need to write some wrapper
functions and prototypes in order to call it from RPG. You may find it
easier to simply copy your (by now) working Java right up to IBM i and
update the spreadsheet using Java - no RPG at all.

An alternative to POI / Java is Python:
http://xlsxwriter.readthedocs.org/en/latest/example_autofilter.html#ex-autofilter


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-2019 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].