Your skill will accomplish what the force of many cannot |
|
PerlMonks |
Preserving merged cells when using Spreadsheet::WriteExcel and ParseExcelby metaperl (Curate) |
on Sep 30, 2011 at 15:18 UTC ( [id://928832]=perlquestion: print w/replies, xml ) | Need Help?? |
metaperl has asked for the wisdom of the Perl Monks concerning the following question:
I'm attempting to modify an Excel spreadhsheet which
spreadsheet has a merged cell at D8.
I wrote a small program which reads the format of D8 and writes some data back to D8 in a new sheet with that formatting:
However, the new sheet has all the merged cells unmerged. Is there a way to preserve merged cells when updating/modifying cells in the template spreadsheet? Both the program and the initial spreadsheet are here
Back to
Seekers of Perl Wisdom
|
|