Spreadsheet::WriteExcel is excellent for this purpose. Of cause, you need to install this module first. Also the Parse::RecDescent module must be installed in order to write an Excel formula.
#!/usr/bin/perl -w use strict; use Spreadsheet::WriteExcel; # Create a new workbook called simple.xls and add a worksheet. my $workbook = Spreadsheet::WriteExcel->new('simple.xls'); my $worksheet = $workbook->add_worksheet(); # The general syntax is write($row, $column, $token). # Note that row and column are zero indexed. # Write some text. $worksheet->write(0, 0, 'Hi Excel!'); # Write some numbers. $worksheet->write(2, 0, 3); # Writes 3 $worksheet->write(3, 0, 3.00000); # Writes 3 $worksheet->write(4, 0, 3.00001); # Writes 3.00001 $worksheet->write(5, 0, 3.14159); # An approximation # Write some formulas. $worksheet->write(7, 0, '=A3 + A6'); $worksheet->write(8, 0, '=IF(A5>3,"Yes", "No")'); # Write a hyperlink. $worksheet->write(10, 0, '"http://www.perl.com/"');
- The Spreadsheet::WriteExcel documentation on CPAN.
- The Example programs (with screenshots).
- The Chart documentation.