arodiss/xls-bundle

Excel files manipulation for Symfony2

Tuesday, December 26, 2017
by arodiss
Repository
4 Watchers
2 Stars
18,390 Installations

PHP
0 Dependents
0 Suggesters
8 Forks
1 Open issues
23 Versions
13 % Grown

The README.md

Xls Bundle

Trivia read and write of .xls files for Symfony2, built on top of the PHPExcel, _(*1)

Installation

Via composer:, _(*2)

require: {
    ...
    "arodiss/xls-bundle": "*@stable"
}

Usage examples:

Read a small file

$reader = $container->get("arodiss.xls.reader");
$content = $reader->readAll("/path/to/file.xls");
var_dump($content);
//array(2) =>
//    array(2) =>
//        0 => string(10) "First line"
//        1 => null
//    array(2) =>
//        0 => string(10) "Line number"
//        1 => int 2

Read a big file

Previous method can exhaust your memory if the file is big. However this is safe:, _(*3)

$reader = $container->get("arodiss.xls.reader");
$iterator = $reader->getReadIterator("/path/to/file.xls");
while($iterator->valid())
{
    var_dump($iterator->current());
    $iterator->next();
}
//same output format

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, _(*4)

$reader = $container->get("arodiss.xls.reader.python");
$iterator = $reader->getReadIterator("/path/to/file.xls");
while($iterator->valid())
{
    var_dump($iterator->current());
    $iterator->next();
}
//same output format

Return XLS file from Symfony controller

$file = $container
    ->get("arodiss.xls.builder")
    ->buildXlsFromArray(array(
        array("row one field one", "row one field two"),
        array("row two field one")
    ))
;

//now $file is path to tmp file with data

$response = new Response();
$response->headers->set("Content-Type", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
$response->headers->set("Content-Disposition", "attachment;filename=excelfile.xlsx");
$response->setContent(file_get_contents($file));
return $response;

Write in a file (recommended)

$writer = $container->get("arodiss.xls.writer.buffered");
$writer->create("users.xls", array("name", "email")); //second argument represents first row

foreach ($userProvider->getUsers() as $user) {
    $writer->appendRow("users.xls", array($user->getName(), $user->getEmail()));
}
$writer->flush();

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., _(*5)

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., _(*6)

The Versions

26/12 2017

dev-master

9999999-dev https://github.com/arodiss/xls-bundle

Excel files manipulation for Symfony2

symfony-bundle xls-bundle

Excel files manipulation for Symfony2

arodiss/xls-bundle

The README.md

Xls Bundle

Installation

Usage examples:

Read a small file

Read a big file

Read even a bigger file

Return XLS file from Symfony controller

Write in a file (recommended)

Write in a file (not recommended)

Formats supported

The Versions

dev-master

The Requires

by Sidora Gleb

v0.5.12

The Requires

by Sidora Gleb

v0.5.11

The Requires

by Sidora Gleb

v0.5.10

The Requires

by Sidora Gleb

v0.5.9

The Requires

by Sidora Gleb

v0.5.8

The Requires

by Sidora Gleb

v0.5.7

The Requires

by Sidora Gleb

v0.5.6

The Requires

by Sidora Gleb

0.5.6

The Requires

by Sidora Gleb

v0.5.5

The Requires

by Sidora Gleb

v0.5.4

The Requires

by Sidora Gleb

v0.5.3

The Requires

by Sidora Gleb

v0.5.2

The Requires

by Sidora Gleb

v0.5.1

The Requires

by Sidora Gleb

v0.4.3

The Requires

The Development Requires

by Sidora Gleb

v0.4.2

The Requires

The Development Requires

by Sidora Gleb

v0.4.1

The Requires

The Development Requires

by Sidora Gleb

v0.4

The Requires

The Development Requires

by Sidora Gleb

0.3.1

The Requires

The Development Requires

by Sidora Gleb

0.3

The Requires

The Development Requires