As pointed out above, autofit isn't possible using Spreadsheet::WriteExcel (since it isn't controlled by the file format).

However, here is a workaround that I posted to the Spreadsheet::WriteExcel Google-Group.

--
John.