Re: HSSF/POI

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

Weird - it was there yesterday,


Jon Paris
Jon.Paris@xxxxxxxxxxxxxx



> On Oct 23, 2024, at 12:08 PM, Bryan Dietz <bdietz400@xxxxxxxxx> wrote:
>
>
> 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.
>
> -- 
>
> -- .
> Bryan
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.