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

Re: How to Modify and Rewrite Excel Files in perl

by Corion (Pope)
on May 22, 2012 at 13:58 UTC ( #971796=note: print w/ replies, xml ) Need Help??


in reply to How to Modify and Rewrite Excel Files in perl

Have you read what the Spreadsheet::WriteExcel documentation has to say about Modifying and Rewriting Excel Files? What parts of it do you have problems with?


Comment on Re: How to Modify and Rewrite Excel Files in perl
Re^2: How to Modify and Rewrite Excel Files in perl
by bimleshsharma (Beadle) on May 23, 2012 at 06:37 UTC
    I am getting format of cell but i am unknown about the actual properties. Because i have to use same format for other cell if bg_color=red. I am using code below to get format..
    # Get the format from the cell my $format = $template->{Worksheet}[$sheet] ->{Cells}[$row][$col] ->{FormatNo};

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (7)
As of 2014-08-22 04:42 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (146 votes), past polls