in reply to spreadsheet writeexcel
IIRC Spreadsheet::WriteExcel::Examples provides working code which demonstrates all of these.