http://www.perlmonks.org?node_id=352412


in reply to Losing EXCEL cell formats on save.

I would give this Spreadsheet-WriteExcel-0.43 module a shot. It might have already solved your problems. Be ware because I have not used the module myself.