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? | [reply] |
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] |