Spreadsheet::WriteExcel

The Spreadsheet::WriteExcel Perl module can be used to create an Excel binary file on any platform that perl runs on. Multiple worksheets can be added to a workbook and formatting can be applied to cells. Text, numbers, formulas, hyperlinks, images and charts can be added.

The file produced by this module is compatible with Excel 97, 2000, 2003 and 2007.

This module will work on Windows, Linux, UNIX and Mac platforms. Generated files are also compatible with the Linux/UNIX spreadsheet applications Gnumeric and OpenOffice.org.

This module cannot be used to write to an existing Excel file (see the Modifying and Rewriting Excel Files section of the main documentation for more details).

An example

The following example shows some of the basic features of Spreadsheet::WriteExcel.

#!/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/"

__END__

This will generate an output file that looks like this:

Documentation

There is a lot of documentation for Spreadsheet::WriteExcel, both on-line:

• The Spreadsheet::WriteExcel documentation on CPAN.
• The Example programs (with screenshots).
• The Chart documentation.

And locally:

• Some information on number formatting.
• The Spreadsheet::WriteExcel Colour Palette.
• An old article from The Perl Journal.

Other Resources

• Downloads: The latest stable release is always available for download from CPAN.
• Forum: The Spreadsheet::WriteExcel Google Group is available for asking questions and searching for previous answers.
• Source code: Clone or download from the Spreadsheet::WriteExcel GitHub repository.
• Contact: Email the author John McNamara (but see this first for bug reports).

Donations

If you found Spreadsheet::WriteExcel useful and would like to donate to the project, you can do so via PayPal.

__END__