Maatwebsite/Laravel-Excel
Laravel Excel
Laravel-Excel is an integration library for importing and exporting spreadsheet data between Laravel applications and Excel or CSV files. It provides a suite of tools for bidirectional spreadsheet integration, including a system for reading workbooks and mapping data into database models.
The library distinguishes itself through a background processing system that handles large imports and exports using chunking and job queues. It supports template-driven exports by converting HTML tables from view templates into spreadsheet cells.
The toolset covers broad capabilities for large dataset processing, including asynchronous exports and model-based imports. These utilities allow for the conversion of database queries and collections into downloadable documents while maintaining a low memory footprint through segment-based reading.
Features
- Spreadsheet Generators - Provides comprehensive capabilities for programmatically creating and populating Excel and CSV files.
- Spreadsheets and Documents - Generates Excel and CSV files from application data and database queries for reporting.
- Chunked Processing Utilities - Implements chunked processing for large spreadsheets to maintain a low memory footprint during import.
- Spreadsheet Import Managers - Provides tools for uploading and parsing local Excel or CSV files as data sources.
- Model-Based Importers - Reads workbooks and worksheets into database models using chunked reading and batch inserts.
- Data Provider Exports - Allows populating spreadsheet rows by iterating through Laravel collections or database queries.
- Excel Automation - Converts database queries, collections, or HTML templates into downloadable Excel and CSV documents.
- Import Column Mappings - Maps spreadsheet columns directly to database model attributes for streamlined data ingestion.
- Asynchronous Generators - Converts database queries into Excel or CSV documents using automatic chunking and background queuing.
- Background Job Queues - Implements a background processing system for large spreadsheet imports and exports using job queues.
- Large Dataset Optimizations - Optimizes the processing of massive spreadsheets through chunking and background queuing to prevent memory exhaustion.
- Batch Processing - Offloads heavy import and export tasks to background workers to prevent request timeouts.
- Template-Driven Exports - Renders custom spreadsheet layouts by converting HTML tables from view templates into Excel files.
- HTML-to-Spreadsheet Converters - Transforms rendered HTML table templates into spreadsheet cells by parsing DOM elements.
- Media and Files - Imports and exports Excel and CSV files.
