Changes for version 2.15
- ! Changed OLE container stream name from "Book" to "Workbook" for compatibility with some third party apps.
- Thanks Wieland Pusch and Kevin McMahon.
- ! Fixed bug that caused all worksheets to be selected in OpenOfficeOrg causing strange linking of data between Worksheets. Thanks M. Brodbelt. See http://rt.cpan.org/NoAuth/Bug.html?id=14094 http://www.openoffice.org/issues/show_bug.cgi?id=52955
- ! Changed file creation from end of program to the start of program in order to avoid race conditions and extra file creation on VMS.
- Added optional user supplied results for formulas as a workaround for uncalcuated values in some non-Excel apps. Added formula_result.pl example of above.
Documentation
A utility to extract charts from an Excel file for insertion into a Spreadsheet::WriteExcel file.
A utility to extract charts from an Excel file for insertion into a Spreadsheet::WriteExcel file.
Modules
Write to a cross-platform Excel binary file.
An abstract base class for Excel workbooks and worksheets.
A class for creating Excel files > 7MB.
A writer class for Excel Charts.
A class for defining Excel formatting.
A class for generating Excel formulas
A writer class to store BIFF data in a OLE compound storage file.
Helper functions for Spreadsheet::WriteExcel.
A writer class for Excel Workbooks.
A writer class for Excel Workbooks > 7MB.
A writer class for Excel Worksheets.
Examples
- doc/examples.html
- examples/README
- examples/bigfile.pl
- examples/bug_report.pl
- examples/cgi.pl
- examples/chess.pl
- examples/colors.pl
- examples/convertA1.pl
- examples/copyformat.pl
- examples/csv2xls.pl
- examples/date_time.pl
- examples/datecalc1.pl
- examples/datecalc2.pl
- examples/demo.pl
- examples/diag_border.pl
- examples/easter_egg.pl
- examples/filehandle.pl
- examples/formats.pl
- examples/formula_result.pl
- examples/function_locale.pl
- examples/headers.pl
- examples/hide_sheet.pl
- examples/hyperlink1.pl
- examples/hyperlink2.pl
- examples/images.pl
- examples/indent.pl
- examples/lecxe.pl
- examples/merge1.pl
- examples/merge2.pl
- examples/merge3.pl
- examples/merge4.pl
- examples/merge5.pl
- examples/mod_perl1.pl
- examples/mod_perl2.pl
- examples/outline.pl
- examples/panes.pl
- examples/protection.pl
- examples/regions.pl
- examples/repeat.pl
- examples/republic.bmp
- examples/sales.pl
- examples/sendmail.pl
- examples/simple.pl
- examples/stats.pl
- examples/stats_ext.pl
- examples/stocks.pl
- examples/tab2xls.pl
- examples/textwrap.pl
- examples/unicode.pl
- examples/unicode_2022_jp.pl
- examples/unicode_2022_jp.txt
- examples/unicode_8859_11.pl
- examples/unicode_8859_11.txt
- examples/unicode_8859_7.pl
- examples/unicode_8859_7.txt
- examples/unicode_big5.pl
- examples/unicode_big5.txt
- examples/unicode_cp1251.pl
- examples/unicode_cp1251.txt
- examples/unicode_cp1256.pl
- examples/unicode_cp1256.txt
- examples/unicode_cyrillic.pl
- examples/unicode_japan.pl
- examples/unicode_koi8r.pl
- examples/unicode_koi8r.txt
- examples/unicode_list.pl
- examples/unicode_polish_utf8.pl
- examples/unicode_polish_utf8.txt
- examples/unicode_shift_jis.pl
- examples/unicode_shift_jis.txt
- examples/win32ole.pl
- examples/writeA1.pl
- examples/write_arrays.pl
- examples/write_handler1.pl
- examples/write_handler2.pl
- examples/write_handler3.pl
- examples/write_handler4.pl
- examples/write_to_scalar.pl