🚀 Easy and performant Excel exports and imports in Laravel
- Change package name
- Change namespace
- Change from box/spout to openspout/openspout
- Update to openspout/openspout:4.x
- Update and refactor code and tests
- Update GitHub workflow
- Update README, LICENSE, CHANGELOG
- Update documents
- Release first version
Laravel Excel is an amazing package and I highly recommend it. One problem I've had with it comes from using PhpSpreadsheet: working with really big datasets requires a lot of memory, even when the exports/imports are chunked. Some of the features provided by PhpSpreadsheet, like cell mapping and formulas, require it to hold entire document represented by objects in memory.
This package use Openspout (formerly known as Box Spout) to easy and performant Excel exports and imports in Laravel.
-
Easily export from different sources: an array, Laravel Collection or query, to different supported formats (CSV, ODS, TSV, XLSX)
-
Supercharged imports import of workbooks and worksheets to Eloquent models with batch inserts! Have large files? Your entire import can happen in the background. If you like, you can even handle each row youself!
-
Memory efficient. Using Box Spout allows this package to use considerably less memory than some alternatives.
Compared to Laravel Excel, this package provides less features because it uses a different library for working with spreadsheets under the hood. However it assures that exports and imports are fast and require less memory.
You can install the package via composer:
composer require rabiloo/laravel-simplesheetYou can find the full documentation of Laravel Simplesheet on the website.
Please see CHANGELOG for more information on what has changed recently.
Please see CONTRIBUTING for details.
Please review our security policy on how to report security vulnerabilities.
This package uses a lot of code copied from Laravel Excel and probably wouldn't exist without it, so a big thanks to the Laravel Excel team for their work on that amazing package. Make sure to check it out!
This package was created by Nenad Živanović. Thanks him so much.
From 2022, after this package had been abandoned, Oanh Nguyen and his team continue to maintain and develop it.
The MIT License (MIT). Please see License File for more information.