1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
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
===============
simple.pl An example of some of the basic features.
regions.pl Demonstrates multiple worksheets.
stats.pl Basic formulas and functions.
formats.pl Creates a demo of the available formatting.
demo.pl Creates a demo of some of the features.
Advanced
========
sales.pl An example of a simple sales spreadsheet.
stocks.pl Demonstrates conditional formatting.
headers.pl Examples of worksheet headers and footers.
write_array.pl Example of writing 1D or 2D arrays of data.
chess.pl An example of formatting using properties.
colors.pl Demo of the colour palette and named colours.
images.pl Adding bitmap images to worksheets.
stats_ext.pl Same as stats.pl with external references.
cgi.pl A simple CGI program.
mod_perl.pl A simple mod_perl program.
hyperlink1.pl Shows how to create web hyperlinks.
hyperlink2.pl Examples of internal and external hyperlinks.
merge1.pl A simple example of cell merging.
merge2.pl A more advanced example of cell merging.
merge3.pl Merge hyperlinks and merge vertically.
textwrap.pl Demonstrates text wrapping options.
panes.pl An examples of how to create panes.
protection.pl Example of cell locking and formula hiding.
copyformat.pl Example of copying a cell format.
win32ole.pl A sample Win32::OLE example for comparison.
easter_egg.pl Expose the Excel97 flight simulator. A must see.
Utility
=======
convertA1.pl Helper functions for dealing with A1 notation.
lecxe.pl Convert Excel to WriteExcel using Win32::OLE.
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.
writemany.pl Write an 2d array of values in one go.
Developer
=========
function_locale.pl Add non-English function names to Formula.pm.
filehandle.pl Examples of working with filehandles.
writeA1.pl Example of how to extend the module.
comments.pl Add cell comments to Excel 5 worksheets.
bigfile.pl Write past the 7MB limit with OLE::Storage_Lite.
|
