Have you read the Spreadsheet::WriteExcel documentation? If you look at Spreadsheet::WriteExcel::Examples, you will find the answers for the column width and how to write to an Excel sheet. To calculate a percentage, you will either have to do the calculation in Perl and write the result to an Excel cell, or you will have to write a formula into the Excel sheet.