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

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?

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

Replies are listed 'Best First'.
Re^6: Spreadsheet::ParseExcel / WriteExcel question .... by beech (Parson) on Dec 04, 2017 at 00:00 UTC
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	[reply]
Re^7: Spreadsheet::ParseExcel / WriteExcel question .... by jhalbrook (Initiate) on Dec 05, 2017 at 02:31 UTC
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!	[reply]