dutchcodingcompany / csv-collection
Read and write large csv files using Laravel's Illuminate Collections
Installs: 2 622
Dependents: 0
Suggesters: 0
Security: 0
Stars: 11
Watchers: 5
Forks: 2
Open Issues: 0
Requires
- php: ^7.4|^8.0
- illuminate/collections: ^6.0|^7.0|^8.0|^9.0|^10.0|^11.0
Requires (Dev)
README
This package provides a simple but powerful way to read and write large CSV files using the power of Laravel's lazy collections.
Installation
You can install the package via composer:
composer require dutchcodingcompany/csv-collection
Usage
You may create a collection using the new
keyword or the make
method.
CsvCollection::make();
This gives you access to all Collection and Lazy Collection methods.
Open
To open a file and load it's content into a new collection you may use the open
method on the collection.
use DutchCodingCompany\CsvCollection\CsvCollection; CsvCollection::make() ->open('path/to/file.csv') ->count();
Save
To save the collection items to a file you may use the save
method on the collection.
use DutchCodingCompany\CsvCollection\CsvCollection; CsvCollection::make(static function () { yield [ 'key' => 'value', ]; }) ->save('path/to/file.csv');
Model exports
When exporting models a memory efficient method is to lazily iterate through the models and yield
it's content.
use DutchCodingCompany\CsvCollection\CsvCollection; CsvCollection::make(static function () { $models = Model::query()->lazy(); foreach ($models as $model){ yield $model->only([ 'id', // ]); } }) ->save('path/to/file.csv');
Options
The following options are available to suit your needs:
header
, default:true
delimiter
, default:,
enclosure
, default:"
escape
, default:\\
These options could be passed to the open
and save
methods, be set using the options
method, or be set as the
global default using the static defaults
method.
The delimiter can be detected for a file by using the detectDelimiter
method like this:
CsvCollection::detectDelimiter($path);
Header
When using a header, lines will contain an associated array. Otherwise, lines will contain an indexed array.
// Without header [ 0 => 'John', 1 => 'Doe', ] // With header [ 'first_name' => 'John', 'last_name' => 'Doe', ]
Note: When saving a collection to a file the keys of the first element in the collection will be used as the header.
Testing
composer test
Credits
License
The MIT License (MIT). Please see License File for more information.