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

[gw1500se]

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?

[2teez]

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

[gw1500se]

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?