in reply to Formatting excel sheet with column locks and data validation

Spreadsheet::WriteExcel only knows about the .xls format. There is a XLSX module on CPAN too. Even if that module does not work for you, .xlsx files are basically XML files, so you should be able to set the lock attributes on the corresponding tags yourself.