Download the PHP package arodiss/xls-bundle without Composer
On this page you can find all versions of the php package arodiss/xls-bundle. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package xls-bundle
Xls Bundle
Trivia read and write of .xls files for Symfony2, built on top of the PHPExcel
Installation
Via composer:
Usage examples:
Read a small file
Read a big file
Previous method can exhaust your memory if the file is big. However this is safe:
Read even a bigger file
Sometime PHPOffice just can't provide reasonable performance. For this case bundle provides alternative reader which wraps python implementation.
It is rudimentary in terms of functionality and especially interactions (like error handling), but performs faster, especially on large files.
In order to use it, you have to install openpyxl
(for xlsx) and xlrd (for xls) libraries, which you can easily do through pip package manager
Return XLS file from Symfony controller
Write in a file (recommended)
Write in a file (not recommended)
Write operations for xls format are extremely expensive, so previous example uses BufferedWriter which stores your data in buffer and writes in file only once, when flushing the buffer.
If for some reason this is not what you want to achieve, you may use service xls.writer
in stead of xls.writer.buffered
.
Formats supported
Files are always written in Excel2007 (.xlsx) format. Read operations, however, MAY work also for other formats supported by PHPExcel (Excel5, Office Open XML, SpreadsheetML, OASIS, CSV, Gnumeric, SYLK) however there is no guarantee for it.
All versions of xls-bundle with dependencies
symfony/framework-bundle Version ~2.3|~3.0|~4.0
symfony/process Version ~2.5|~3.0|~4.0
phpoffice/phpexcel Version 1.8.*