kira_marom has asked for the wisdom of the Perl Monks concerning the following question:

I'm trying to add data to an existing excel worksheet : 
$cell = $worksheet->get_cell($line, $col-1);
if(defined $cell) {
    my $format = $cell->get_format();
}
$worksheet->AddCell($line, $col, $val, $format);

[download]
but some of the borders get overridden i.e. the cell is written without borders. Any ideas how to solve this ?
  • Comment on Spreadsheet::ParseExcel::SaveParser - unable to copy border formatting
  • Download Code

Replies are listed 'Best First'.
Re: Spreadsheet::ParseExcel::SaveParser - unable to copy border formatting
by stefbv (Priest) on Aug 08, 2012 at 07:18 UTC

    Please, post code that we can actually run.

    Because of 'my' in the scope of 'if', the $format variable in the last line, probably doesn't contain what you think it is.

    Regards, Stefan.

[reply]

Back to Seekers of Perl Wisdom