ExcelAnt

Simple yet powerful Excel manipulation library for PHP 5.4+

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 !

Code Quality Rank: L5

Programming language: PHP

License: GNU General Public License v3.0 or later

Tags: Office     Excel    

Latest version: v1.0.2

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

1. Install composer : curl -s http://getcomposer.org/installer | php (more info at getcomposer.org)
2. Create a composer.json file in your project root : (or add only the excelant line in your existing composer file)

  {
    "require": {
      "wisembly/excelant": "*",
    }
  }

1. 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.

Running ExcelAnt Tests