Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

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

by 2teez (Priest)
on Dec 18, 2012 at 06:51 UTC ( #1009290=note: print w/ replies, xml ) Need Help??


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

Hi gw1500se,

"..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?.."

To Update an existing Excel sheet Please see MODIFYING AND REWRITING EXCEL FILES

Spreadsheet::ParseExcel::SaveParser module can be used to read and rewrite an Excel file (i.e Rewrite an existing Excel file). Though this module is a wrapper around Spreadsheet::ParseExcel and Spreadsheet::WriteExcel. Spreadsheet::WriteExcel module cannot be used to write to an existing Excel file.

Please check the description of these modules: Spreadsheet::WriteExcel, Spreadsheet::ParseExcel and Spreadsheet::ParseExcel::SaveParser
Hope this helps

If you tell me, I'll forget.
If you show me, I'll remember.
if you involve me, I'll understand.
--- Author unknown to me


Comment on Re^3: Set Background Color Using Spreadsheet::SaveParser
Re^4: Set Background Color Using Spreadsheet::SaveParser
by gw1500se (Beadle) on Dec 18, 2012 at 13:06 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://1009290]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (6)
As of 2014-08-28 00:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (253 votes), past polls