How to retain background colors when pasting between documents in Excel

How to retain background colors when pasting between documents in Excel

I have a script that programatically generates excel spreadsheets - cleaning up ugly reports that are given to us from another organisation. For interests sake; I'm using PHPExcel to generate the "clean" reports.