in reply to Spreadsheet::WriteExcel and displaying a specific column in split_panes
maybe ExcelPerl will help you (or at least some of the codes inside). It is a kind of sed/awk-like program (or like perl -ane) that lets you change values and formats of an existing excel file on the fly...
It isn't based on the SpreadSheet::*Excel modules but on Win32::OLE... so it will only run under Win and require an installed Excel version...
You can get it from http://www.fabiani.net/downloads.html#excelPerl
perl -e "s>>*F>e=>y)\*martinF)stronat)=>print,print v22.214.171.124.11.32"