nikookherad/spreadsheet

This service is for easy work with Excel files

v1.1.0 2022-12-30 20:44 UTC

Requires

• php: >=7.4
• laravel/framework: ^9.19
• phpoffice/phpspreadsheet: ^1.9

Requires (Dev)

• phpunit/phpunit: ~6.0 || ~7.0 || ~9.0

MIT

• Ali Nikookherad

• excel
• spreadsheet

README

Summery:

This service is for easy work with Excel files

Notice: This service needs PhpOffice\PhpSpreadsheet package

This service has six methods that can be used in a chain

• Purify method: Takes from you the Excel file's address:

  $excelFile=Excel\Excel::purify(string $excelFileStoragePath,string $extension = null);

and other methods come after that

  $excelFileRows=$excelFile->rows(): array;

  list($head,$rows)=$excelFile->read(): array;

  $records=$excelFile->records(): array;

  $excelFilesRowsJustFirstRow=$excelFile->header(): array;

  $excelFilesRowsWithoutFirstRow=$excelFile->body(): array;