Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Spreadsheet::ParseExcel::SaveParser - unable to copy border formatting

by kira_marom (Initiate)
on Aug 07, 2012 at 07:10 UTC ( #985897=perlquestion: print w/replies, xml ) Need Help??
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);
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 (Deacon) 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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://985897]
Approved by Corion
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (8)
As of 2016-09-28 22:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Extraterrestrials haven't visited the Earth yet because:







    Results (541 votes). Check out past polls.