Description
ExcelAnt is an Excel manipulation library for PHP 5.4. It currently works on top of PHPExcel. If you want to add / use another library, feel free to fork and contribute !
ExcelAnt alternatives and similar libraries
Based on the "Office" category.
Alternatively, view ExcelAnt alternatives based on common mentions on social networks and blogs.
InfluxDB – Built for High-Performance Time Series Workloads
* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest.
Do you think we are missing an alternative of ExcelAnt or a related project?
README
| |
\ /
\_/
__ /^\ __
' `. \_/ ,' `
\/ \/
_,--./| |\.--._
_,' _.-\_/-._ `._
| / \ |
| / \ |
/ | | \
-' \___/ `-
ExcelAnt
ExcelAnt is an Excel manipulation library for PHP 5.4. It currently works on top of PHPExcel. If you want to add / use another library, feel free to fork and contribute !
Version
1.0.0
Installation
- Install composer :
curl -s http://getcomposer.org/installer | php(more info at getcomposer.org) - Create a
composer.jsonfile in your project root : (or add only the excelant line in your existing composer file)
{
"require": {
"wisembly/excelant": "*",
}
}
- Install via composer :
php composer.phar install
Use ExcelAnt
Create a simple Table :
use ExcelAnt\Adapter\PhpExcel\Workbook\Workbook,
ExcelAnt\Adapter\PhpExcel\Sheet\Sheet,
ExcelAnt\Adapter\PhpExcel\Writer\Writer,
ExcelAnt\Table\Table,
ExcelAnt\Coordinate\Coordinate;
Class Export
{
public function createExport(array $users)
{
$workbook = new Workbook();
$sheet = new Sheet($workbook);
$table = new Table();
foreach ($users as $user) {
$table->setRow([
$user->getName(),
$user->getEmail(),
]);
}
$sheet->addTable($table, new Coordinate(1, 1));
$workbook->addSheet($sheet);
}
}
Now, to export your Workbook, you need to create a Writer :
use ExcelAnt\Adapter\PhpExcel\Writer\WriterFactory,
ExcelAnt\Adapter\PhpExcel\Writer\PhpExcelWriter\Excel5;
$writer = (new WriterFactory())->createWriter(new Excel5('/path/to/myExport.xls'));
Convert your Worbook to create a PHPExcel object and export it :
$phpExcel = $writer->convert($workbook);
$writer->write($phpExcel);
Documentation
Coming soon...
Contributing
ExcelAnt is an open source project. If you would like to contribute, fork the repository and submit a pull request.