Excel::Writer::XLSX - howto freeze first line

Question

I'm using the perl module Excel::Writer::XLSX. The following code snippet creates a header line in the result file.

use strict;
use warnings;
use Excel::Writer::XLSX;

my $workbook  = Excel::Writer::XLSX->new("myExcel.xlsx");
my $worksheet = $workbook->add_worksheet("Sheet1");
my $ccnt = 0;
foreach my $entry (('Head1','Head2','Head3')) {
    $worksheet->write(0,$ccnt++,$entry);
}
$workbook->close();

Now, I'd like to fix that first line to keep it visible while downscrolling. Although there is a bunch of good documentation on CPAN, I didn't find how to manage this.

leu leu · Accepted Answer · 2015-05-13T08:27:08

Answering my own question as victim of a wrong translation: The task is to freeze the first line of the Excel-sheet, not to fix it. (The question title already mentioned this :-(

The solution is as simple as follows. Add

$worksheet->freeze_panes(1);

right after creation of the worksheet.

Excel::Writer::XLSX - howto freeze first line

1 Answers