in reply to a stubborn excel file

Spreadsheet::WriteExcel can not modify existing Excel spreadsheets. You will need Win32::OLE to accomplish this.

Have a look at Parse Excel Spreadsheets To Single before *potentially* reinventing the wheel.