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.





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 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 copyright@midrange.com.

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.