Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: Spreadsheet::WriteExcel and displaying a specific column in split_panes

by strat (Canon)
on Jul 18, 2012 at 12:07 UTC ( [id://982422]=note: print w/replies, xml ) Need Help??


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"

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://982422]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chilling in the Monastery: (5)
As of 2024-03-29 13:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found