Re: HSSF/POI

[Bryan Dietz <bdietz400@xxxxxxxxx>]

on another note www.scottklement.com  dns name seems to not be around.




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.