Download the PHP package pear/spreadsheet_excel_writer without Composer
On this page you can find all versions of the php package pear/spreadsheet_excel_writer. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Short Description Allows writing of Excel spreadsheets without the need for COM objects. Supports formulas, images (BMP) and all kinds of formatting for text and cells.
All versions of spreadsheet_excel_writer with dependencies
Informations about the package spreadsheet_excel_writer
Please report all new issues via the PEAR bug tracker.
If this package is marked as unmaintained and you have fixes, please submit your pull requests and start discussion on the pear-qa mailing list.
To test, run
To build, simply
$ pear package
To install from scratch
$ pear install package.xml
$ pear upgrade -f package.xml
This package comes with support for Composer.
To install from Composer
$ composer require pear/spreadsheet_excel_writer
To install the latest development version
$ composer require pear/spreadsheet_excel_writer:dev-master
- writing Excel (.XLS) spreadsheets
- support: strings (with formatting for text and cells), formulas, images (BMP)
Library support only 2 types of format for writing XLS, also known as Binary Interchange File Format (BIFF):
- BIFF5 (Excel 5.0 - Excel 95)
- BIFF8 (Excel 98 - Excel 2003)
Some important limitations:
|Maximum number of rows||16384||65535|
|Maximum number of columns||255||255|
|Maximum data size of a record||2080 bytes||8224 bytes|
|Unicode support||CodePage based character encoding||UTF-16LE|
Explanation of formats and specifications you can find here (section "Useful references")
Correct output only guaranteed with
mbstring.func_overload = 0 otherwise, you should use workround
Header usage (Sending HTTP header for download dialog)
Intel(R) Core(TM) i5-4670 CPU @ 3.40GHz
Write xls (BIFF8 format, UTF-8), by 5 cells (1x number, 4x string without format/styles, average line length = 120 char) in each row
|Number of rows||Time (seconds)||Peak memory usage (MB)|