Re: HSSF/POI

I don't know if I added this back in the day or if it's in Scotts original
because I added a few things and don't remember but there is a
HSSFSheet_createFreezePane that will allow you to freeze at least the rows
and I think columns as well.

You would have to look at what the values mean. This is some old source I
had in my vault that's no longer in use. If I remember correctly it froze
just the top row or maybe the top two 2 rows.
HSSFSheet_createFreezePane(sheet: 0: 1: 0: 1);

This was in my HSSF_H.RPGLE source
*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
* HSSFSheet_createFreezePane...
*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
D HSSFSheet_createFreezePane...

D PR EXTPROC(*JAVA

D :'org.apache.poi.hssf.usermodel-

D .HSSFSheet'

D :'createFreezePane')

D xtopfrz like(jint) value

D ytopfrz like(jint) value

D xbottomfrz like(jint) value

D ybottomfrz like(jint) value


Start with this, not a very experienced user with these. I usually "roll my

own" for creating XLS (more control over the formatting and such), but
working for a client that likes this better. Sure is much faster this way
just need to see if it can do a couple of things for me. If this is asked
and answered before and I missed it, please point me that direction.

The POI jar files say 3.6, which based upon the date on them (12/14/09)
means there is newer, but not sure I would get them to upgrade/update.
What
is current, just out of curiosity? Maybe I'll let them know and see what
comes of it.

Three specific things I would like to do:
1. Worksheet A has some report headings and then column titles in the
first
five rows. I would like to freeze the top five rows and place the cursor
in
cell A6.
2. Worksheet B has column titles in just the first two rows but has row
titles in column A. So, I would like to freeze the top two rows and the
first column and place the cursor in cell 3B.
3. Within any worksheet I would like to pick a column and place a filter
on
the column to save the user having to add it each time upon first opening.

I know what the embedded coding looks like when I am writing the file
myself, but I can't find those specific functions inside the HSSF_H source
code base we have.

As always, thanks in advance for the great assistance these boards always
provide.

Steve M.