2017 © Pedro Peláez
 

library oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL, Spout and PHP fputcsv

image

imtigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL, Spout and PHP fputcsv

  • Monday, March 12, 2018
  • by imtigger
  • Repository
  • 1 Watchers
  • 2 Stars
  • 2,255 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 3 Forks
  • 0 Open issues
  • 16 Versions
  • 16 % Grown

The README.md

OneExcel

Build Status Latest Stable Version Latest Unstable Version Total Downloads License, (*1)

PHP Excel read/write abstraction layer, support PhpSpreadSheet, LibXL, Spout and PHP fputcsv/fgetcsv, (*2)

Targets to simplify server compatibility issue between Excel libraries and performance issue in huge files., (*3)

Ideal for simple-formatted but huge spreadsheet files such as reporting., (*4)

Installation

Requirements

  • PHP >= 5.6.4
  • php_zip, php_xmlreader, php_simplexml enabled
  • (Recommended) LibXL installed & php_excel enabled

Composer

OneExcel can only be installed from Composer., (*5)

Run the following command:, (*6)

$ composer require imtigger/oneexcel

Writer

Basic Usage

$excel = OneExcelWriterFactory::create()
        ->toFile('excel.xlsx')
        ->make();

$excel->writeCell(1, 0, 'Hello');
$excel->writeCell(2, 1, 'World');
$excel->writeCell(3, 2, 3.141592653, ColumnType::NUMERIC);
$excel->writeRow(4, ['One', 'Excel']);
$excel->writeCell(4, 2, 'Test');

$excel->output();
```Selection](driver.md)

### Advanced Usage

```php
$excel = OneExcelWriterFactory::create()
        ->fromFile('template.xlsx', Format::XLSX)
        ->toStream('excel.csv', Format::CSV)
        ->withDriver(Driver::SPOUT)
        ->make();

$excel->writeCell(1, 0, 'Hello');
$excel->writeCell(2, 1, 'World');
$excel->writeCell(3, 2, 3.141592653, ColumnType::NUMERIC);
$excel->writeRow(4, ['One', 'Excel']);
$excel->writeCell(4, 2, 'Test');

$excel->output();

Reader

(Version 0.6+), (*7)

$excel = OneExcelReaderFactory::create()
        ->fromFile('excel.xlsx')
        // ->withDriver(Driver::SPOUT)
        ->make();

foreach ($excel->row() as $row) {
    //
}

$excel->close();

Documents

Auto Driver Selection, (*8)

Known Issues

  • Spout reader driver output empty rows as SINGLE column (Upstream problem?)
  • Spout do not support random read/write rows (Upstream limitation, Won't fix)
  • Spout do not support formula (Upstream limitation, Won't fix)
  • fputcsv driver ignores all ColumnType::* (File-type limitation, Won't fix)

The Versions

12/03 2018

dev-dev

dev-dev https://github.com/imTigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL, Spout and PHP fputcsv

  Sources   Download

MIT

The Requires

 

The Development Requires

by Tiger Fok

csv excel xls xlsx phpexcel ods spout libxl fputcsv

19/10 2017

dev-master

9999999-dev https://github.com/imTigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL, Spout and PHP fputcsv

  Sources   Download

MIT

The Requires

 

The Development Requires

by Tiger Fok

csv excel xls xlsx phpexcel ods spout libxl fputcsv

19/10 2017

v0.6.1

0.6.1.0 https://github.com/imTigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL, Spout and PHP fputcsv

  Sources   Download

MIT

The Requires

 

The Development Requires

by Tiger Fok

csv excel xls xlsx phpexcel ods spout libxl fputcsv

10/08 2017

v0.6.0

0.6.0.0 https://github.com/imTigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL, Spout and PHP fputcsv

  Sources   Download

MIT

The Requires

 

The Development Requires

by Tiger Fok

csv excel xls xlsx phpexcel ods spout libxl fputcsv

28/04 2017

v0.5.1

0.5.1.0 https://github.com/imTigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL, Spout and PHP fputcsv

  Sources   Download

MIT

The Requires

 

The Development Requires

by Tiger Fok

csv excel xls xlsx phpexcel ods spout libxl fputcsv

25/04 2017

v0.5.0

0.5.0.0 https://github.com/imTigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL, Spout and PHP fputcsv

  Sources   Download

MIT

The Requires

 

The Development Requires

by Tiger Fok

csv excel xls xlsx phpexcel ods spout libxl fputcsv

24/04 2017

v0.3.3

0.3.3.0 https://github.com/imTigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL and Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Tiger Fok

csv excel xls xlsx phpexcel ods spout libxl

29/03 2017

v0.3.2

0.3.2.0 https://github.com/imTigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL and Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Tiger Fok

csv excel xls xlsx phpexcel ods spout libxl

27/03 2017

v0.3.1

0.3.1.0 https://github.com/imTigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL and Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Tiger Fok

csv excel xls xlsx phpexcel ods spout libxl

27/03 2017

v0.3.0

0.3.0.0 https://github.com/imTigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL and Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Tiger Fok

csv excel xls xlsx phpexcel ods spout libxl

13/03 2017

v0.2.4

0.2.4.0 https://github.com/imTigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL and Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Tiger Fok

csv excel xls xlsx phpexcel ods spout libxl

13/03 2017

v0.2.3

0.2.3.0 https://github.com/imTigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL and Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Tiger Fok

csv excel xls xlsx phpexcel ods spout libxl

13/03 2017

v0.2.2

0.2.2.0 https://github.com/imTigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL and Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Tiger Fok

csv excel xls xlsx phpexcel ods spout libxl

13/03 2017

v0.2.1

0.2.1.0 https://github.com/imTigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL and Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Tiger Fok

excel phpexcel spout libxl

13/03 2017

v0.2

0.2.0.0 https://github.com/imTigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL and Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Tiger Fok

excel phpexcel spout libxl

13/03 2017

v0.1

0.1.0.0 https://github.com/imTigger/oneexcel

PHP Excel read/write abstraction layer, support PHPExcel, LibXL and Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Tiger Fok

excel phpexcel spout libxl