Skip to content

Latest commit

 

History

History
79 lines (46 loc) · 3.85 KB

README.md

File metadata and controls

79 lines (46 loc) · 3.85 KB

Laravel Simplesheet

🚀 Easy and performant Excel exports and imports in Laravel

Latest Version on Packagist GitHub Tests Action Status Total Downloads

Laravel Simplesheet

TODO

  • 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

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.

This package use Openspout (formerly known as Box Spout) to easy and performant Excel exports and imports in Laravel.

Features

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

Installation

You can install the package via composer:

composer require rabiloo/laravel-simplesheet

Usage

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

Changelog

Please see CHANGELOG for more information on what has changed recently.

Contributing

Please see CONTRIBUTING for details.

Security Vulnerabilities

Please review our security policy on how to report security vulnerabilities.

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!

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.

License

The MIT License (MIT). Please see License File for more information.