| René Nyffenegger's collection of things on the web | |
|
René Nyffenegger on Oracle - Most wanted - Feedback
|
Excel and PERL | ||
use warnings;
use strict;
use OLE;
my $excel = CreateObject OLE 'Excel.Application' or die $!;
$excel->{'Visible'} = 1;
my $workbook = $excel -> Workbooks -> Add;
$workbook -> ActiveSheet -> Range('A1')->{'Value'} = "Hello";
$workbook -> ActiveSheet -> Range('C2:D3')->{'Value'} = [
['one', 'two' ],
['three', 'four'],
];
$workbook -> SaveAs ('C:\\perl.xls') or die $!;
$excel -> Quit;
The excel object modelLinks
See also MS Knowledge Base Article 214797
See also Automating word with perl
Spreadsheet::WriteExcel: Write formatted text and numbers to a cross-platform Excel binary file.
|