Hi, I'm new to the list. I've been playing around with HSSF recently and
let me say, nice work! The API is so clean that it's been a breeze
getting the xls file I need written.
I have been using the Spreadsheet::WriteExcel perl module, but the Excel 5
format it writes to is too limiting.
However, I have a question for you about HSSF. I've read through the
Javadoc and HOW-TO for the HSSF classes and can't find one thing I really
need:
*how does one freeze a row so that it doesn't scroll?*
The code to do this in the Spreadsheet::WriteExcel module is:
my $workbook = Spreadsheet::WriteExcel->new($out_file);
my $worksheet = $workbook->addworksheet("Primers");
# freeze the header row
$worksheet->freeze_panes(1, 0);
I don't see anything similar in HSSFSheet and HSSFRow. I'm hoping I just
missed it and there is a way to do it (as this is a crucial feature for my
users).
If it is not there, please consider this an enhancement request for one.
Thanks much,
Michael
-----------------------------
Michael Peterson
Systems Programmer, Scientific Computing Group
Syngenta, Inc.
Research Triangle Park, NC
http://www.syngenta.com
-----------------------------
"Five minutes after any agreement is signed with
Microsoft they'll be thinking of how to violate
the agreements. They're predators. They crush their
competition. They crush new ideas. They stifle
innovation. That's what they do."
-Thomas Reilly, attorney general of Massachusetts
http://www.newsobserver.com/thursday/news/editorials/Story/839842p-827111c.html
