RE: HSSF/POI

Thanks, Bryan. Great for locking/unlocking cells, but the function is
actually called Freeze in Excel that I seek.

https://poi.apache.org/components/spreadsheet/quick-guide.html#Splits
https://poi.apache.org/apidocs/dev/org/apache/poi/ss/usermodel/Sheet.html#cr
eateFreezePane-int-int-

Steve


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Bryan
Dietz
Sent: Wednesday, October 23, 2024 11:19
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: HSSF/POI

internet archive:


https://web.archive.org/web/20120423064815/http://www.systeminetwork.com/art
icle/rpg-programming/locking-cells-in-hssf-64813

hope it helps
Bryan

Steve M via MIDRANGE-L wrote on 10/23/2024 7:32 AM:

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.