in reply to Modifying xlsx file with perl

Should you be on Windows and have Excel on your machine, have a look at Win32::OLE. There is a lot of material on PerlMonks and you can do everything that Excel can.