nikazooz/laravel-simplesheet

This package is abandoned and no longer maintained. No replacement package was suggested.

Simple, powerful and memory-efficient spreadsheet exports and imports in Laravel

2.0.2 2021-04-15 20:18 UTC

Requires

• php: ^7.2|^8.0
• ext-json: *
• box/spout: ^3.2
• illuminate/support: ^5.5|^6.0|^7.0|^8.0

Requires (Dev)

• orchestra/database: ^3.5|^4.0|^5.0|^6.0
• orchestra/testbench: ^3.5|^4.0|^5.0|^6.0
• phpunit/phpunit: ~6.0|^7.0|^8.0|^9.0

MIT

• Nenad Živanović

• php
• excel
• spreadsheet
• csv
• import
• export
• laravel
• batch
• box
• spout
• simplesheet

README

THIS PACKAGE HAS BEEN ABANDONED

Laravel Simplesheet

Wrapper around Box Spout with the goal of simplifying exports and imports in Laravel.

Quickstart · Documentation · Contributing · Support

Credits

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!

Rationale

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.

✨ Features

• Easily export from different sources: an array, Laravel Collection or query, to different supported formats

• 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.

🎓 Using Laravel Simplesheet

You can find the full documentation of Laravel Simplesheet on the website.

Suggestions for improving the docs are welcome. The documentation repository can be found at https://github.com/nikazooz/laravel-simplesheet-docs.

License

This software is open source and licensed under the MIT license.

🔧 Supported Versions

Versions will be supported for a limited amount of time.

Version	Laravel Version	Php Version	Box Spout	Support
1.*	5.5 - 8.*	^7.1	^2.7	No further support
2.*	5.5 - 8.*	>=7.2	^3.2	No further support