ANNOUNCE: Spread***::WriteExcelXML 0.02
From: John McNamara (jmcnamara_at_cpan.org)
Date: 04/29/04
- Next message: John McNamara: "ANNOUNCE: Spread***::WriteExcel 0.43"
- Previous message: John Bokma: "Re: CGI.pm - strange difference between CGI.pm version 2.81 and 2.36"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 28 Apr 2004 23:03:55 GMT
======================================================================
ANNOUNCE
Spread***::WriteExcel version 0.02 has been uploaded to CPAN.
http://search.cpan.org/~jmcnamara/Spread***-WriteExcelXML/
======================================================================
NAME
Spread***::WriteExcelXML - Create an Excel file in XML format.
======================================================================
DESCRIPTION
The Spread***::WriteExcelXML module can be used to create an
Excel file in XML format. The Excel XML format is supported in
Excel 2002 and 2003.
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. The module supports strings up to 32,767
characters and the strings can be in UTF8 format.
Spread***::WriteExcelXML uses the same interface as
Spread***::WriteExcel.
This module cannot, as yet, be used to write to an existing
Excel XML file.
======================================================================
SYNOPSIS
To write a string, a formatted string, a number and a formula to
the first work*** in an Excel XML spread*** called perl.xml:
use Spread***::WriteExcelXML;
# Create a new Excel workbook
my $workbook = Spread***::WriteExcelXML->new("perl.xml");
# Add a work***
$work*** = $workbook->add_work***();
# 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.
$col = $row = 0;
$work***->write($row, $col, "Hi Excel!", $format);
$work***->write(1, $col, "Hi Excel!");
# Write a number and a formula using A1 notation
$work***->write('A3', 1.2345);
$work***->write('A4', '=SIN(PI()/4)');
======================================================================
REQUIREMENTS
This module requires Perl 5.005 (or later).
======================================================================
INSTALLATION
Use the standard Unix style installation, a ppm for Windows
users will be available in the next release:
Unzip and untar the module as follows or use winzip:
tar -zxvf Spread***-WriteExcel-0.xx.tar.gz
The module can be installed using the standard Perl procedure:
perl Makefile.PL
make
make test
make install # You may need to be root
make clean # or make realclean
======================================================================
AUTHOR
John McNamara (jmcnamara@cpan.org)
--
- Next message: John McNamara: "ANNOUNCE: Spread***::WriteExcel 0.43"
- Previous message: John Bokma: "Re: CGI.pm - strange difference between CGI.pm version 2.81 and 2.36"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]