hikaru / php-excel
fork from asan/phpexcel and fix some excel2007 bug
v2.0.1
2018-07-23 01:42 UTC
Requires
- php: >=7.0
This package is auto-updated.
Last update: 2025-07-10 21:06:37 UTC
README
A lightweight PHP library for reading spreadsheet files
- Based on GeneratorăSeekableIterator and Countable
- Support for reading by line, read data only
Requirements
- PHP 7.0 or higher
Installation
composer require asan/phpexcel
Usage
csv
// Simple setting
$reader = Asan\PHPExcel\Excel::load('files/02.csv', 'GBK');
// Flexible setting
$reader = Asan\PHPExcel\Excel::load('files/01.csv', function(Asan\PHPExcel\Reader\Csv $reader) {
// Set row limit
$reader->setRowLimit(10);
// Set column limit
$reader->setColumnLimit(10);
// Ignore emoty row
$reader->ignoreEmptyRow(true);
// Set encoding
//$reader->setInputEncoding('GBK');
// Set delimiter
$reader->setDelimiter("\t");
}, 'GBK');
// skip to row 50
$reader->seek(50);
// Get the current row data
$current = $reader->current();
// Get row count
$count = $reader->count();
xls
$reader = Asan\PHPExcel\Excel::load('files/01.xls', function(Asan\PHPExcel\Reader\Xls $reader) {
// Set row limit
$reader->setRowLimit(10);
// Set column limit
$reader->setColumnLimit(10);
// Ignore emoty row
$reader->ignoreEmptyRow(true);
// Select sheet index
$reader->setSheetIndex(1);
});
// skip to row 50
$reader->seek(50);
// Get the current row data
$current = $reader->current();
// Get row count
$count = $reader->count();
// Get all sheets info
$sheets = $reader->sheets();
xlsx
$reader = Asan\PHPExcel\Excel::load('files/01.xlsx', function(Asan\PHPExcel\Reader\Xlsx $reader) {
// Set row limit
$reader->setRowLimit(10);
// Set column limit
$reader->setColumnLimit(10);
// Ignore emoty row
$reader->ignoreEmptyRow(true);
// Select sheet index
$reader->setSheetIndex(0);
});
// skip to row 50
$reader->seek(50);
// Get the current row data
$current = $reader->current();
// Get row count
$count = $reader->count();
// Get all sheets info
$sheets = $reader->sheets();