Download the PHP package boenrobot/big-xlsx-bundle without Composer
On this page you can find all versions of the php package boenrobot/big-xlsx-bundle. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download boenrobot/big-xlsx-bundle
More information about boenrobot/big-xlsx-bundle
Files in boenrobot/big-xlsx-bundle
Package big-xlsx-bundle
Short Description Symfony2 Bundle for generating large multi-sheeted xlsx files with low memory usage. Fork of bassim/BigXlsxBundle, for compatibility with newer PHP versions.
License MIT
Homepage http://github.com/boenrobot/BigXlsxBundle
Informations about the package big-xlsx-bundle
BigXlsxBundle
Symfony2 Bundle for generating large multi-sheeted xlsx files with low memory usage.
This Bundle basically acts as a replacement for creating csv files with large datasets. This, because the CSV format can be troublesome when it comes to difference in default cell separators en line-endings on specific operating systems. Also, obviously, CSV cannot handle multiple sheets.
This bundle uses the 'codeplex/phpexcel' bundle but tries to get rid of the enormous execution time and memory consumption when one wants to store large datasets in a xlsx.
Installation
add this to your composer.json:
"bassim/big-xlsx-bundle": "dev-master"
add this to your AppKernel.php
new Bassim\BigXlsxBundle\BassimBigXlsxBundle(),
Basic Usage
/** @var $service BigXlsxService */
$service = $container->get('bassim_big_xlsx.service');
$data[] = array("id","name");
for ($i=0;$i<1;$i++) {
$data[] = array($i, "name_".$i);
}
$service->addSheet(0, "test Sheet_0", $data);
$file = $service->getFile();
Adding a custom sheet
/** @var $service BigXlsxService */
$service = $container->get('bassim_big_xlsx.service');
$data[] = array("id","name");
for ($i=0;$i<1;$i++) {
$data[] = array($i, "name_".$i);
}
$service->addSheet(0, "test Sheet_0", $data);
$objPHPExcel = $service->getPHPExcel();
//add custom sheet
$objPHPExcel->createSheet(1);
$objPHPExcel->setActiveSheetIndex(1);
$objPHPExcel->getActiveSheet()->setTitle("test");
// ....
$file = $service->getFile();