master |
develop |
|---|---|
 |
 |
 |
 |
 |
 |
Library providing an object modeling of a spreadsheet (all objects are immutable). It comes with objects to build a spreadsheet out of a file and dump a spreadsheet into a file.
composer require baptouuuu/spreadsheetuse Spreadsheet\{
Spreadsheet,
Sheet,
Cell,
Position
};
$sheet = new Sheet('sheet 1');
$sheet = $sheet
->add(
new Cell(
new Position('A', 1),
'A1 value'
)
)
->add(
new Cell(
new Position('B', 2),
'B2 value'
)
);
$spreadsheet = new Spreadsheet('My Spreadsheet');
$spreadsheet = $spreadsheet->add($sheet);use Spreadsheet\{
Writer\CsvWriter,
Formatter\FormatterInterface,
File\Csv
};
use Innmind\Immutable\Map;
$writer = new CsvWriter(';', true, new Map('string', FormatterInterface::class));
$file = $writer->write($spreadsheet);
$file instanceof Csv; //true
(string) $file->name(); //sheet 1.csv
(string) $file->content();
/*
A;B
A1;
;B2
*/In case your spreadsheet contains more than one sheet, the writer will return an instance of DirectoryInterface.
use Spreadsheet\{
Reader\CsvReader,
File\Csv,
Position
};
use Innmind\Filesystem\Stream\StringStream;
$reader = new CsvReader(';', true);
$spreadsheet = $reader->read(
new Csv(
'sheet.csv',
new StringStream(<<<CSV
A;B
A1;B1
CSV
)
)
);
$spreadsheet->name(); //sheet
$spreadsheet->get('sheet')->name(); //sheet
$spreadsheet->get('sheet')->get(new Position('A', 1))->value(); //A1
$spreadsheet->get('sheet')->get(new Position('B', 1))->value(); //B1If you give an instance of DirectoryInterface to the reader, each file will be a sheet in your spreadhseet.