README
1======================================================================
2NAME
3
4 Spreadsheet::WriteExcelXML - Create an Excel file in XML format.
5
6======================================================================
7DESCRIPTION
8
9 The Spreadsheet::WriteExcelXML module can be used to create an
10 Excel file in XML format. The Excel XML format is supported in
11 Excel 2002 and 2003.
12
13 Multiple worksheets can be added to a workbook and formatting
14 can be applied to cells. Text, numbers, and formulas can be
15 written to the cells. The module supports strings up to 32,767
16 characters and the strings can be in UTF8 format.
17
18 Spreadsheet::WriteExcelXML uses the same interface as
19 Spreadsheet::WriteExcel.
20
21 This module cannot, as yet, be used to write to an existing
22 Excel XML file.
23
24
25======================================================================
26SYNOPSIS
27
28 To write a string, a formatted string, a number and a formula to
29 the first worksheet in an Excel XML spreadsheet called perl.xls:
30
31 use Spreadsheet::WriteExcelXML;
32
33 # Create a new Excel workbook
34 my $workbook = Spreadsheet::WriteExcelXML->new("perl.xls");
35
36 # Add a worksheet
37 $worksheet = $workbook->add_worksheet();
38
39 # Add and define a format
40 $format = $workbook->add_format(); # Add a format
41 $format->set_bold();
42 $format->set_color('red');
43 $format->set_align('center');
44
45 # Write a formatted and unformatted string, row and column notation.
46 $col = $row = 0;
47 $worksheet->write($row, $col, "Hi Excel!", $format);
48 $worksheet->write(1, $col, "Hi Excel!");
49
50 # Write a number and a formula using A1 notation
51 $worksheet->write('A3', 1.2345);
52 $worksheet->write('A4', '=SIN(PI()/4)');
53
54
55======================================================================
56REQUIREMENTS
57
58 This module requires Perl 5.005 (or later).
59
60
61======================================================================
62INSTALLATION
63
64 Use the standard Unix style installation, a ppm for Windows
65 users will be available in the next release:
66
67 Unzip and untar the module as follows or use winzip:
68
69 tar -zxvf Spreadsheet-WriteExcel-0.xx.tar.gz
70
71 The module can be installed using the standard Perl procedure:
72
73 perl Makefile.PL
74 make
75 make test
76 make install # You may need to be root
77 make clean # or make realclean
78
79
80======================================================================
81AUTHOR
82
83 John McNamara (jmcnamara@cpan.org)
84