in reply to Adding Borders to Cells using Excel::Writer::XLSX

GuiPerl:

It works for me. Are you specifying the format when you write to the spreadsheet?

my $fmt_hdr = $workbook->add_format( border=>1, color=>'blue' );
my $fmt_cell = $workbook->add_format( border=>1, color=>'black' );
. . .
$worksheet->write($row, $col, "HDR", $fmt_hdr);
$worksheet->write($row+1, $col, "value", $fmt_cell);

[download]

...roboticus

When your only tool is a hammer, all problems look like your thumb.

Replies are listed 'Best First'.
Re^2: Adding Borders to Cells using Excel::Writer::XLSX
by GuiPerl (Acolyte) on Jul 07, 2014 at 17:14 UTC
    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.
[reply]
[d/l]
      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]

In Section Seekers of Perl Wisdom