Download the PHP package avadim/fast-excel-laravel without Composer

FastExcelLaravel

Lightweight and very fast XLSX Excel Spreadsheet read/write library for Laravel in pure PHP (wrapper around FastExcelWriter and FastExcelReader)

Introduction

Exporting data from your Laravel application has never been so fast! Importing models into your Laravel application has never been so easy!

This library is a wrapper around avadim/fast-excel-writer and avadim/fast-excel-reader, so it's also lightweight, fast, and requires a minimum of memory. Using this library, you can export arrays, collections and models to a XLSX-file from your Laravel application, and you can import data to Laravel application.

Features

• Easily export models, collections and arrays to Excel
• Export huge datasets with very fast, and using a minimum of memory
• Сan create multiple sheets and supports basic column, row and cell styling
• You can set the height of the rows and the width of the columns (including auto width calculation)
• Import workbooks and worksheets to Eloquent models very quickly and with minimal memory usage
• Automatic field detection from imported table headers
• Mapping import/export data
• Supports auto formatter and custom formatter of datetime values for import data
• The library can define and extract images from XLSX files
• You can add active hyperlinks, formulas, notes, charts and images to output XLSX-files
• Supports workbook and sheet protection with/without passwords
• Supports page settings - page margins, page size

Installation

Install via composer:

And then you can use facade

Jump To:

• Export Data
  • Export a Model
  • Export Any Collections and Arrays
  • Mapping Export Data
  • Advanced Usage for Data Export
• Import Data
  • Import a Model
  • Mapping Import Data
  • Advanced Usage for Data Import
• More Features
• Do you want to support FastExcelLaravel?

Export Data

Export a Model

Easy and fast export of a model. This way you export only model data without headers and without any styling

The following code will write the field names and styles (font and borders) to the first row, and then export all the data of the User model

Mapping Export Data

You can map the data that needs to be added as row

Export Any Collections and Arrays

Advanced Usage for Data Export

See detailed documentation for avadim/fast-excel-writer here: https://github.com/aVadim483/fast-excel-writer/tree/master#readme

Import Data

Import a Model

To import models, you can use method . If the first row contains the names of the fields you can apply these using method

You can define the columns or cells from which you will import

In the last two examples, we also assume that the first row of imported data (row 4) is the names of the attributes.

Mapping Import Data

However, you can set the correspondence between columns and field names yourself.

Advanced Usage for Data Import

See detailed documentation for avadim/fast-excel-reader here: https://github.com/aVadim483/fast-excel-reader/tree/master#readme

More Features

You can see more features for export in the documentation for FastExcelWriter.

You can see more features for import in the documentation for FastExcelReader)

Do you want to support FastExcelLaravel?

if you find this package useful you can support and donate to me for a cup of coffee:

• USDT (TRC20) TSsUFvJehQBJCKeYgNNR1cpswY6JZnbZK7
• USDT (ERC20) 0x5244519D65035aF868a010C2f68a086F473FC82b
• ETH 0x5244519D65035aF868a010C2f68a086F473FC82b

Or just give me a star on GitHub :)