Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
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
Re: Spreadsheet::ParseExcel::SaveParser - unable to copy border formatting
by stefbv (Chaplain) 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 drinking their drinks and smoking their pipes about the Monastery: (5)
As of 2014-08-30 20:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (293 votes), past polls