Re^2: Adding Borders to Cells using Excel::Writer::XLSX

I had to change coding. This little example will work:


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

my $workbook  = Excel::Writer::XLSX->new( "Cell_Borders.xlsx" );
my $worksheet = $workbook->add_worksheet();

my $textbox1 ="Hello World!";


    my $format_box = $workbook->add_format();
        
    $format_box->set_top('5');
    $format_box->set_bottom('5');
    $worksheet->merge_range( 'A8:B8', "$textbox1", $format_box );
[download]

This will add a border on the top and bottom cell.

To fix the problem, I had to add the formatting calls individual (i.e. $format_box->set_top()) and not the to add_format() method.

Comment on Re^2: Adding Borders to Cells using Excel::Writer::XLSX Download Code

Replies are listed 'Best First'.
Re^3: Adding Borders to Cells using Excel::Writer::XLSX by poj (Abbot) on Jul 07, 2014 at 17:23 UTC
`set_border(), set_top(), etc` are `FORMAT` methods not `WORKSHEET or WORKBOOK` methods. `#!perl use strict; use Excel::Writer::XLSX; my $workbook = Excel::Writer::XLSX->new( 'borders.xlsx' ); my $worksheet = $workbook->add_worksheet(); my $fmt_top = $workbook->add_format(); $fmt_top->set_top(); $worksheet->set_column( 'A:B', 30, $fmt_top );` [download] see Excel::Writer::XLSX poj	[reply] [d/l] [select]