Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^2: Set Background Color Using Spreadsheet::SaveParser

by gw1500se (Beadle)
on Dec 17, 2012 at 18:45 UTC ( #1009216=note: print w/replies, xml ) Need Help??


in reply to Re: Set Background Color Using Spreadsheet::SaveParser
in thread Set Background Color Using Spreadsheet::SaveParser

Thanks for the reply. Not exactly confused as much as not understanding the capabilities of each. I thought SaveParser was a combined ParseExcel and WriteExcel, rather than something completely different. Logically, it seems that if I can add rows with SaveParser then I should also be able to set attributes on those rows. In any case, how do I go about updating an existing spreadsheet if not with SaveParser? Do I need to instead use both ParseExcel and WriteExcel instead? Can WriteExcel update and existing spreadsheet?
  • Comment on Re^2: Set Background Color Using Spreadsheet::SaveParser

Replies are listed 'Best First'.
Re^3: Set Background Color Using Spreadsheet::SaveParser
by 2teez (Vicar) on Dec 18, 2012 at 06:51 UTC
      Thanks again for the reply but I'm still stuck. If WriteExcel does not let me rewrite and existing spreadsheet and SaveParser does not let me 'set_color' I only see a brute force method to do what I need. I would have to use WriteExcel to create a new spreadsheet, then delete the old one and rename the new one. It seems like I am missing something or there is a big hole in these modules.

      P.S. If there is no 'set_color' method in SaverParser, why am I not getting a run time error when I try to use it?

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (7)
As of 2020-11-27 14:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?