ParseExcel::SaveParser, colors & google docsby irDanR (Novice)
|on Aug 05, 2010 at 18:52 UTC||Need Help??|
irDanR has asked for the wisdom of the Perl Monks concerning the following question:
I'm trying to combine a single worksheet from each of a dozen different workbooks into a single new workbook. I can do this perfectly with ParseExcel and WriteExcel. However I need to retain the formatting of the original sheets.
(Basically copied from the synopsis.) Running it on an example workbook gives me almost perfect results. The cell size, border, font, etc. are all correct. However, the font color as well as background color change. As in, black font turns into impossible to read light blue or pink.
I notice that once the worksheet has been run through SaveParser, the colors stay the same in subsequent passes. This got some gears turning and I found that it only happens to an xls once after downloading from google docs.
Just to be painfully clear:
My situation requires that I download the docs from google and then combine into a new doc and then upload back to google weekly. Does anyone have any experience with this or have any suggestions for making the colors stay the same? I foresee this requiring me to become much more familiar with the google doc API...Update: An interesting find, using:
to get a number for the color - when I output the number to a file and then compare it before the color change and after the change, gives me the same number.