PHP code example of endroid / simple-excel
1. Go to this page and download the library: Download endroid/simple-excel library. Choose the download type require. 2. Extract the ZIP file and open the index.php. 3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
endroid / simple-excel example snippets
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']);