Skip to content

natanaugusto/easyspreadsheets

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

27 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

EasySpreadsheets

Total Downloads Latest Stable Version License Flying Donut

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)