|
Start with this, not a very experienced user with these. I usuallythat direction.
"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
first opening.
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
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 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.