endroid / simple-excel
Endroid Simple Spreadsheet
Fund package maintenance!
endroid
Installs: 2 522
Dependents: 0
Suggesters: 0
Security: 0
Stars: 14
Watchers: 5
Forks: 5
Open Issues: 0
Requires
- php: ^8.2
- phpoffice/phpspreadsheet: ^3.3
- symfony/http-foundation: ^5.4||^6.4||^7.0
Requires (Dev)
- endroid/quality: dev-main
Suggests
- roave/security-advisories: Avoids installation of package versions with vulnerabilities
README
By endroid
Library for quickly importing and exporting spreadsheet data. Data can be loaded from and converted from / to an array, an Excel/CSV file or Spreadsheet object.
The main advantage of this library is the small amount of code needed to perform an import or export of data, given one of the above formats.
Installation
Use Composer to install the library.
$ composer require endroid/simple-spreadsheet
Usage
<?php use Endroid\SimpleSpreadsheet\Adapter\FileAdapter; use Endroid\SimpleSpreadsheet\SimpleSpreadsheet; $spreadsheet = new SimpleSpreadsheet(); $spreadsheet->load('data.xlsx'); // Load all sheets from data.xlsx $spreadsheet->load([ 'Players' => [ ['name' => 'L. Messi', 'club' => 'Barcelona'], ['name' => 'C. Ronaldo', 'club' => 'Real Madrid'] ] ]); $spreadsheet->save(FileAdapter::class, ['Players'], ['filename' => 'players.csv']);
You can also use the saveToString
and getHeadersByFilename
methods to build a
Response object instead of directly outputting to the browser.
Versioning
Version numbers follow the MAJOR.MINOR.PATCH scheme. Backwards compatible changes will be kept to a minimum but be aware that these can occur. Lock your dependencies for production and test your code when upgrading.
License
This bundle is under the MIT license. For the full copyright and license information please view the LICENSE file that was distributed with this source code.