Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
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
Replies are listed 'Best First'.
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 chilling in the Monastery: (12)
As of 2015-07-31 16:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (279 votes), past polls