I had a similar problem once which boiled down to using

$worksheet->write_string
[download]

instead of

$worksheet->write
[download]

Be sure to read the WORKSHEET METHODS and CELL FORMATTING sections in the Spreadsheet::WriteExcel documentation.