Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Can I Create Reports and Charts Through Perl?

by Nkuvu (Priest)
on Feb 24, 2003 at 21:27 UTC ( [id://238242]=note: print w/replies, xml ) Need Help??


in reply to Can I Create Reports and Charts Through Perl?

The short answer is Yes.

The longer answer is that you can directly create the Excel spreadsheet, either via Win32::OLE (requires Office to be installed on the system) or the SpreadSheet::WriteExcel and SpreadSheet::ParseExcel modules from CPAN. Note that if you are using ActivePerl on Windows Win32::OLE is already installed (unless they've changed something since I last installed. ;) ).

With OLE, you can do anything in Excel that has a similar VB control. Try perldoc Win32::OLE if you are on Windows. There's also a quick and dirty reference for Win32::OLE on this page that I have used frequently.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others sharing their wisdom with the Monastery: (6)
As of 2024-04-24 06:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found