According to my exprience the following approach is the easiest/fastest:

• create the Excel-Sheet by hand, especially all the formatting like (chart-)colors, sizes .... use dummy-data instead of the real values.
• use perl just to overwrite the dummy-data with the real values

Maybe that approach works for you, too....

HTH, Rata