Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP

Fetching latest commit…

Cannot retrieve the latest commit at this time

..
Failed to load latest commit information.
README
a_simple.pl
autofilter.pl
autofit.pl
bigfile.pl
bug_report.pl
cgi.pl
chart_area.pl
chart_bar.pl
chart_column.pl
chart_line.pl
chart_pie.pl
chart_scatter.pl
chart_stock.pl
chess.pl
colors.pl
comments1.pl
comments2.pl
convertA1.pl
copyformat.pl
csv2xls.pl
data_validate.pl
date_time.pl
datecalc1.pl
datecalc2.pl
defined_name.pl
demo.pl
diag_border.pl
easter_egg.pl
filehandle.pl
formats.pl
formula_result.pl
function_locale.pl
gen_examples_pod.pl
headers.pl
hide_sheet.pl
hyperlink1.pl
hyperlink2.pl
images.pl
indent.pl
lecxe.pl
merge1.pl
merge2.pl
merge3.pl
merge4.pl
merge5.pl
merge6.pl
mod_perl1.pl
mod_perl2.pl
outline.pl
outline_collapsed.pl
panes.pl
properties.pl
protection.pl
regions.pl
repeat.pl
republic.png
right_to_left.pl
row_wrap.pl
sales.pl
sendmail.pl
stats.pl
stats_ext.pl
stocks.pl
tab2xls.pl
tab_colors.pl
textwrap.pl
unicode_2022_jp.pl
unicode_2022_jp.txt
unicode_8859_11.pl
unicode_8859_11.txt
unicode_8859_7.pl
unicode_8859_7.txt
unicode_big5.pl
unicode_big5.txt
unicode_cp1251.pl
unicode_cp1251.txt
unicode_cp1256.pl
unicode_cp1256.txt
unicode_cyrillic.pl
unicode_koi8r.pl
unicode_koi8r.txt
unicode_list.pl
unicode_polish_utf8.pl
unicode_polish_utf8.txt
unicode_shift_jis.pl
unicode_shift_jis.txt
unicode_utf16.pl
unicode_utf16_japan.pl
win32ole.pl
writeA1.pl
write_arrays.pl
write_handler1.pl
write_handler2.pl
write_handler3.pl
write_handler4.pl
write_to_scalar.pl

README

The following is a description of the example files that are provided
with Spreadsheet::WriteExcel. They are intended to demonstrate the
different features and options of the module.


Getting started
===============
a_simple.pl             A get started example with some basic features.
demo.pl                 A demo of some of the available features.
regions.pl              A simple example of multiple worksheets.
stats.pl                Basic formulas and functions.
formats.pl              All the available formatting on several worksheets.
bug_report.pl           A template for submitting bug reports.


Advanced
========
autofilter.pl           Examples of worksheet autofilters.
autofit.pl              Simulate Excel's autofit for column widths.
bigfile.pl              Write past the 7MB limit with OLE::Storage_Lite.
cgi.pl                  A simple CGI program.
chart_area.pl           A demo of area style charts.
chart_bar.pl            A demo of bar (vertical histogram) style charts.
chart_column.pl         A demo of column (histogram) style charts.
chart_line.pl           A demo of line style charts.
chart_pie.pl            A demo of pie style charts.
chart_scatter.pl        A demo of scatter style charts.
chart_stock.pl          A demo of stock style charts.
chess.pl                An example of reusing formatting via properties.
colors.pl               A demo of the colour palette and named colours.
comments1.pl            Add comments to worksheet cells.
comments2.pl            Add comments with advanced options.
copyformat.pl           Example of copying a cell format.
data_validate.pl        An example of data validation and dropdown lists.
date_time.pl            Write dates and times with write_date_time().
defined_name.pl         Example of how to create defined names.
diag_border.pl          A simple example of diagonal cell borders.
easter_egg.pl           Expose the Excel97 flight simulator.
filehandle.pl           Examples of working with filehandles.
formula_result.pl       Formulas with user specified results.
headers.pl              Examples of worksheet headers and footers.
hide_sheet.pl           Simple example of hiding a worksheet.
hyperlink1.pl           Shows how to create web hyperlinks.
hyperlink2.pl           Examples of internal and external hyperlinks.
images.pl               Adding images to worksheets.
indent.pl               An example of cell indentation.
merge1.pl               A simple example of cell merging.
merge2.pl               A simple example of cell merging with formatting.
merge3.pl               Add hyperlinks to merged cells.
merge4.pl               An advanced example of merging with formatting.
merge5.pl               An advanced example of merging with formatting.
merge6.pl               An example of merging with Unicode strings.
mod_perl1.pl            A simple mod_perl 1 program.
mod_perl2.pl            A simple mod_perl 2 program.
outline.pl              An example of outlines and grouping.
outline_collapsed.pl    An example of collapsed outlines.
panes.pl                An examples of how to create panes.
properties.pl           Add document properties to a workbook.
protection.pl           Example of cell locking and formula hiding.
repeat.pl               Example of writing repeated formulas.
right_to_left.pl        Change default sheet direction to right to left.
row_wrap.pl             How to wrap data from one worksheet onto another.
sales.pl                An example of a simple sales spreadsheet.
sendmail.pl             Send an Excel email attachment using Mail::Sender.
stats_ext.pl            Same as stats.pl with external references.
stocks.pl               Demonstrates conditional formatting.
tab_colors.pl           Example of how to set worksheet tab colours.
textwrap.pl             Demonstrates text wrapping options.
win32ole.pl             A sample Win32::OLE example for comparison.
write_arrays.pl         Example of writing 1D or 2D arrays of data.
write_handler1.pl       Example of extending the write() method. Step 1.
write_handler2.pl       Example of extending the write() method. Step 2.
write_handler3.pl       Example of extending the write() method. Step 3.
write_handler4.pl       Example of extending the write() method. Step 4.
write_to_scalar.pl      Example of writing an Excel file to a Perl scalar.


Unicode
=======
unicode_utf16.pl        Simple example of using Unicode UTF16 strings.
unicode_utf16_japan.pl  Write Japanese Unicode strings using UTF-16.
unicode_cyrillic.pl     Write Russian Cyrillic strings using UTF-8.
unicode_list.pl         List the chars in a Unicode font.
unicode_2022_jp.pl      Japanese: ISO-2022-JP to utf8 in perl 5.8.
unicode_8859_11.pl      Thai:     ISO-8859_11 to utf8 in perl 5.8.
unicode_8859_7.pl       Greek:    ISO-8859_7  to utf8 in perl 5.8.
unicode_big5.pl         Chinese:  BIG5        to utf8 in perl 5.8.
unicode_cp1251.pl       Russian:  CP1251      to utf8 in perl 5.8.
unicode_cp1256.pl       Arabic:   CP1256      to utf8 in perl 5.8.
unicode_koi8r.pl        Russian:  KOI8-R      to utf8 in perl 5.8.
unicode_polish_utf8.pl  Polish :  UTF8        to utf8 in perl 5.8.
unicode_shift_jis.pl    Japanese: Shift JIS   to utf8 in perl 5.8.


Utility
=======
csv2xls.pl              Program to convert a CSV file to an Excel file.
tab2xls.pl              Program to convert a tab separated file to xls.
datecalc1.pl            Convert Unix/Perl time to Excel time.
datecalc2.pl            Calculate an Excel date using Date::Calc.
lecxe.pl                Convert Excel to WriteExcel using Win32::OLE.


Developer
=========
convertA1.pl            Helper functions for dealing with A1 notation.
function_locale.pl      Add non-English function names to Formula.pm.
writeA1.pl              Example of how to extend the module.
Something went wrong with that request. Please try again.