<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <title>Spreadsheet::WriteExcel</title> <head> <style type="text/css"> body { font-family: Arial, Helvetica, sans-serif; font-size: 20px; } #main_image { position: absolute; left: 20px; top: 10px; z-index: 1; } #inline_image { margin-left: 40px; } h1 { color: white; background-color: #A7C942; text-align: left; text-indent: 120px; vertical-align: top; font-family: Arial, Helvetica, sans-serif; font-size: 40px; padding: 42px; margin-top: 36px; } h2 { color: white; background-color: #A7C942; text-align: left; text-indent: 10px; vertical-align: top; font-family: Arial, Helvetica, sans-serif; font-size: 24px; padding: 10px; } pre { background: black; color: green; padding: 10px; margin: 40px; width: 620px; font-size: 15px; } </style> </head> <body> <img id="main_image" src="./images/swe.png" width="128" height="128" alt="Spreadsheet::WriteExcel logo"/> <h1>Spreadsheet::WriteExcel</h1> <p> The <b>Spreadsheet::WriteExcel</b> 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. </p> <p> The file produced by this module is compatible with Excel 97, 2000, 2003 and 2007. </p> <p> 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. </p> <p> This module cannot be used to write to an existing Excel file (see the <i>Modifying and Rewriting Excel Files</i> section of the main documentation for more details). </p> <h2>An example</h2> <p>The following example shows some of the basic features of Spreadsheet::WriteExcel.</p> <pre> #!/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__ </pre> <p> This will generate an output file that looks like this: </p> <p id="inline_image"> <img src="./images/example.jpg" width="640" height="420" alt="Output from example" /> </p> <h2>Documentation</h2> <p>There is a lot of documentation for Spreadsheet::WriteExcel, both on-line:<p> <ul> <li>The <a href="http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel/lib/Spreadsheet/WriteExcel.pm">Spreadsheet::WriteExcel</a> documentation on CPAN.</li> <li>The <a href="http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel/lib/Spreadsheet/WriteExcel/Examples.pm">Example programs</a> (with screenshots).</li> <li>The <a href="http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel/lib/Spreadsheet/WriteExcel/Chart.pm">Chart</a> documentation.</li> </ul> <p>And locally:</p> <ul> <li>The <a href="./WriteExcel.html">Spreadsheet::WriteExcel</a> documentation (this is the same as the CPAN version).</li> <li>Some <a href="./WriteExcel_Install.html">installation instructions</a> for different platforms.</li> <li>Some information on <a href="./number_formats1.html">number</a> <a href="./number_formats2.html">formatting</a>.</li> <li>The Spreadsheet::WriteExcel <a href="./palette.html">Colour Palette</a>.</li> <li>An old <a href="Perl_Journal_Article.html">article</a> from The Perl Journal.</li> </ul> <h2>Other Resources</h2> <ul> <li><b>Downloads</b>: The <a href="http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel/">latest stable release</a> is always available for download from CPAN.</li> <li><b>Forum</b>: The Spreadsheet::WriteExcel <a href="http://groups.google.com/group/spreadsheet-writeexcel">Google Group</a> is available for asking questions and searching for previous answers.</li> <li><b>Source code</b>: Clone or download from the Spreadsheet::WriteExcel <a href="http://github.com/jmcnamara/spreadsheet-writeexcel">GitHub repository</a>.</li> <li><b>Contact</b>: Email the author <a href="mailto:jmcnamara@cpan.org">John McNamara</a> (but <a href="http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel/lib/Spreadsheet/WriteExcel/Examples.pm#Example:_bug_report.pl">see this first</a> for bug reports).</li> </ul> <h2>Donations</h2> <p> If you found Spreadsheet::WriteExcel useful and would like to donate to the project, you can do so via PayPal. </p> <p style="text-align:center;clear:both"><a style="border:0pt none;background-color:transparent;margin-left:1em;margin-right:1em" href="https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=jmcnamara%40cpan%2eorg&item_name=Spreadsheet%3a%3aWriteExcel&no_shipping=1&cn=Optional%20note%20with%20donation&tax=0&currency_code=USD&charset=UTF%2d8&charset=UTF%2d8"><img src="https://www.paypal.com/en_US/i/btn/x-click-but04.gif" style="border:0pt none" width="62" height="31"></a></p> <img alt="" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" border="0" height="1"> <h2>__END__</h2> </body> </html>