1Simple(3)             User Contributed Perl Documentation            Simple(3)
2
3
4

NAME

6       Spreadsheet::WriteExcel::Simple - A simple single-sheet Excel document
7

SYNOPSIS

9         my $ss = Spreadsheet::WriteExcel::Simple->new;
10            $ss->write_bold_row(\@headings);
11            $ss->write_row(\@data);
12
13         print $ss->data;
14               # or
15               $ss->save("filename.xls");
16

DESCRIPTION

18       This provides an abstraction to the Spreadsheet::WriteExcel module for
19       easier creation of simple single-sheet Excel documents.
20
21       In its most basic form it provides two methods for writing data:
22       write_row and write_bold_row which write the data supplied to the next
23       row of the spreadsheet.
24
25       However, you can also use $ss->book and $ss->sheet to get at the under‐
26       lying workbook and worksheet from Spreadsheet::WriteExcel if you wish
27       to manipulate these directly.
28

METHODS

30       new
31
32         my $ss = Spreadsheet::WriteExcel::Simple->new;
33
34       Create a new single-sheet Excel document. You should not supply this a
35       filename or filehandle. The data is stored internally, and can be
36       retrieved later through the 'data' method or saved using the 'save'
37       method.
38
39       write_row / write_bold_row
40
41         $ss->write_bold_row(\@headings);
42         $ss->write_row(\@data);
43
44       These write the list of data into the next row of the spreadsheet.
45
46       Caveat: An internal counter is kept as to which row is being written
47       to, so if you mix these functions with direct writes of your own, these
48       functions will continue where they left off, not where you have written
49       to.
50
51       data
52
53         print $ss->data;
54
55       This returns the data of the spreadsheet. If you're planning to print
56       this to a web-browser, be sure to print an 'application/excel' header
57       first.
58
59       book / sheet
60
61         my $workbook  = $ss->book;
62         my $worksheet = $ss->sheet;
63
64       These return the underlying Spreadsheet::WriteExcel objects represent‐
65       ing the workbook and worksheet respectively. If you find yourself mak‐
66       ing more that a trivial amount of use of these, you probably shouldn't
67       be using this module, but using Spreadsheet::WriteExcel directly.
68
69       save
70
71               $ss->save("filename.xls");
72
73       Save the spreadsheet with the given filename.
74

BUGS

76       This can't yet handle dates in a sensible manner.
77

AUTHOR

79       Tony Bowden
80

BUGS and QUERIES

82       Please direct all correspondence regarding this module to:
83         bug-Spreadsheet-WriteExcel-Simple@rt.cpan.org
84

SEE ALSO

86       Spreadsheet::WriteExcel. John McNamara has done a great job with this
87       module.
88

90       Copyright (C) 2001-2005 Tony Bowden. All rights reserved.
91
92       This module is free software; you can redistribute it and/or modify it
93       under the same terms as Perl itself.
94
95
96
97perl v5.8.8                       2006-01-16                         Simple(3)
Impressum