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"

  • Comment on Re: Spreadsheet::WriteExcel and displaying a specific column in split_panes