Laravel Packages

Lightweight Spreadsheets for Laravel

Published
Lightweight Spreadsheets for Laravel image

If you're looking for a lightweight package that can read and write spreadsheets, Chris Morrell's Linen package is a lightweight spreadsheet package for Laravel. This package is a wrapper for the openspout/openspout package which lets you read and write spreadsheets in a fast and scalable way.

Here are a few examples of how you can use the Linen package to read and write spreadsheets:

use Glhd\Linen\CsvReader;
use Glhd\Linen\ExcelReader;

$data = [
    ['user_id' => 1, 'name' => 'Chris', 'nullable' => null, 'number' => 40.2],
    ['user_id' => 10, 'name' => 'Bogdan', 'nullable' => 'not null', 'number' => -37],
];

// CSV
$collection = CsvReader::from('basic.csv')->collect();
$tempfile = CsvWriter::for($data)->writeToTemporaryFile();

// Excel
$collection = ExcelReader::from('basic.xlsx')->collect();
$tempfile = ExcelWriter::for($data)->writeToTemporaryFile();

Linen provides some conveniences on top of the Openspout package, such as using Laravel's LazyCollection class when reading spreadsheets. You can get started with this package by installing it via composer:

composer require glhd/linen

The readme and source code is available on GitHub at glhd/linen.

Paul Redmond photo

Staff writer at Laravel News. Full stack web developer and author.

Sponsored

acquaintsoft logo
Acquaint Softtech

Hire Laravel developers with AI expertise at $20/hr. Get started in 48 hours.

Visit Acquaint Softtech

The latest

View all →
pgjumbo: A PostgreSQL Client for macOS, Windows, and Linux image

pgjumbo: A PostgreSQL Client for macOS, Windows, and Linux

Read article
Laranon: Reversible PII Anonymization for Laravel and LLMs image

Laranon: Reversible PII Anonymization for Laravel and LLMs

Read article
PHP 8.6 is released!  image

PHP 8.6 is released!

Read article
Laravel Warrant: Row-Level Permissions With Eloquent image

Laravel Warrant: Row-Level Permissions With Eloquent

Read article
JSON Schema Validation Rules and a RetryFor Attribute in Laravel 13.43 image

JSON Schema Validation Rules and a RetryFor Attribute in Laravel 13.43

Read article
Durable Workflow: Long-Running Workflows for Laravel image

Durable Workflow: Long-Running Workflows for Laravel

Read article