in reply to Spreadsheet::WriteExcel and displaying a specific column in split_panes
Hello,
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
Best regards,
perl -e "s>>*F>e=>y)\*martinF)stronat)=>print,print v8.8.8.32.11.32"
|
---|