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)