natanaugusto/easyspreadsheets

A easy way to handle spreadsheets with PHP

0.0.2 2018-07-25 00:53 UTC

Requires

• phpoffice/phpspreadsheet: ^1.2

Requires (Dev)

• phpunit/phpunit: 3.7.*

MIT

• Natan Augusto

README

That's a easy way to use PhpSpreadsheet.

What you can do with this:

• Load a spreadsheet very easily.
• Read spreadsheets with header
• Read cells colors
• Read rows associated with their headers
• Paint cells and texts
• That's it for now

Install:

composer require natanaugusto/easyspreadsheets

Begins:

require_once('../vendor/autoload.php');

use EasySpreadsheets\Handler as EasySpreadsheet;
$file = dirname(__FILE__) . DIRECTORY_SEPARATOR . 'example.xlsx';

$spread = new EasySpreadsheet;
$spread->load($file);

Load without header on spreadsheet:

$spread->load($file, false);

Get all rows:

$spread->getRows()

Get the current row:

$spread->getRow()

Get a especific row:

$spread->getRow(2)

(Yes, my English is a very bad shit)