/usr/share/doc/libspreadsheet-writeexcel-perl/html/index.html

<!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-&#62;new(&#39;simple.xls&#39;);
my $worksheet = $workbook-&#62;add_worksheet();

# The general syntax is write($row, $column, $token).
# Note that row and column are zero indexed.

# Write some text.
$worksheet-&#62;write(0, 0,  &#39;Hi Excel!&#39;);


# Write some numbers.
$worksheet-&#62;write(2, 0,  3);          # Writes 3
$worksheet-&#62;write(3, 0,  3.00000);    # Writes 3
$worksheet-&#62;write(4, 0,  3.00001);    # Writes 3.00001
$worksheet-&#62;write(5, 0,  3.14159);    # An approximation


# Write some formulas.
$worksheet-&#62;write(7, 0,  &#39;=A3 + A6&#39;);
$worksheet-&#62;write(8, 0,  &#39;=IF(A5&#62;3,&#34;Yes&#34;, &#34;No&#34;)&#39;);


# Write a hyperlink.
$worksheet-&#62;write(10, 0, &#39;"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&amp;business=jmcnamara%40cpan%2eorg&amp;item_name=Spreadsheet%3a%3aWriteExcel&amp;no_shipping=1&amp;cn=Optional%20note%20with%20donation&amp;tax=0&amp;currency_code=USD&amp;charset=UTF%2d8&amp;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>
libspreadsheet-writeexcel-perl 2.37-1 / usr / share / doc / libspreadsheet-writeexcel-perl / html / index.html
