Re^5: Spreadsheet::ParseExcel / WriteExcel question ....

[jhalbrook]

Having all kinds of problems with Win32::OLE (mostly me, I'm a perl newbie). Would anyone have an example using Spreadsheet::ParseExcel and Spreadsheet::WriteExcel where they simply read in an existing spreadsheet and output a new spreadsheet identical to the original, but perhaps changing the font color and fill color of a few cells?

Another way of asking, is how do I preserve all of the existing formatting of a cell and simply change one or more attributes such as a font color or fill color on some cells?

[beech]

Hi,

See Getting the background color of a cell in an existing Excel spreadsheet found with ?node_id=3989;BIT=Spreadsheet%3A%3AParseExcel%20Spreadsheet%3A%3AWriteExcel;HIT=excel

[jhalbrook]

Hi beech,

Thank you for the link. That's actually where I started weeks back. :-) The code was used as a basis for my script, but I still don't have it working for exactly replicating an existing sheet. 95% is close but, in this case, it must be 100% accurate. I'll keep plugging away at it, until I figure it out.

Yet, I thank you for the help!