NAME
Excel::Writer::XLSX - Create a new file in the Excel 2007+ XLSX format.
DESCRIPTION
The Excel::Writer::XLSX module can be used to create a new Excel file
in the 2007+ XLSX format.
Multiple worksheets can be added to a workbook and formatting
can be applied to cells. Text, numbers, and formulas can be
written to the cells.
Excel::Writer::XLSX uses the same interface as Spreadsheet::WriteExcel
but not all of its features are currently implemented. See the
"Compatibility with Spreadsheet::WriteExcel" section of the main
documentation for details.
SYNOPSIS
To write a string, a formatted string, a number and a formula to
the first worksheet in an Excel XML spreadsheet called perl.xls:
use Excel::Writer::XLSX;
# Create a new Excel workbook
my $workbook = Excel::Writer::XLSX->new("perl.xls");
# Add a worksheet
$worksheet = $workbook->add_worksheet();
# Add and define a format
$format = $workbook->add_format(); # Add a format
$format->set_bold();
$format->set_color('red');
$format->set_align('center');
# Write a formatted and unformatted string, row and column notation.
$col = $row = 0;
$worksheet->write($row, $col, "Hi Excel!", $format);
$worksheet->write(1, $col, "Hi Excel!");
# Write a number and a formula using A1 notation
$worksheet->write('A3', 1.2345);
$worksheet->write('A4', '=SIN(PI()/4)');
INSTALLATION
Use the standard Unix style installation.
Unzip and untar the module as follows:
tar -zxvf Excel-XLSX-Writer-0.xx.tar.gz
The module can be installed using the standard Perl procedure:
perl Makefile.PL
make
make test
make install # As sudo/root
AUTHOR
John McNamara (jmcnamara@cpan.org)