Re: Update Excel with RPG

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