README

FastExcelWriter v.6

FastExcelWriter is a part of the FastExcelPhp Project which consists of

FastExcelWriter - to create Excel spreadsheets
FastExcelReader - to read Excel spreadsheets
FastExcelTemplator - to generate Excel spreadsheets from XLSX templates
FastExcelLaravel - special Laravel edition

Introduction

Lightweight, powerful and very fast XLSX Spreadsheet Writer in pure PHP. This library is designed to be super-fast and requires minimal memory usage.

FastExcelWriter creates spreadsheets in XLSX format, compatible with MS Excel (Office 2007+), LibreOffice, OpenOffice and others, with many features supported:

Takes UTF-8 encoded input
Multiple worksheets
Supports currency/date/numeric cell formatting, formulas and active hyperlinks
Supports most styling options for cells, rows, columns - colors, borders, fonts, etc.
You can set the height of the rows and the width of the columns (including auto width calculation)
You can add formulas, notes and images in your XLSX-files
Supports workbook and sheet protection with/without passwords
Supports page settings - page margins, page size
Inserting multiple charts
Supports data validations and conditional formatting

Currently, the required PHP minimum version is PHP 7.4

Installation

Use composer to install FastExcelWriter into your project:

composer require avadim/fast-excel-writer

Quick Start

use \avadim\FastExcelWriter\Excel;
use \avadim\FastExcelWriter\Style\Style;

$data = [
    ['2003-12-31', 'James', '220'],
    ['2003-8-23', 'Mike', '153.5'],
    ['2003-06-01', 'John', '34.12'],
];

$excel = Excel::create(['Sheet1']);
$sheet = $excel->sheet();

// Write the head row and set styles via fluent interface
$sheet->writeHeader(['Date', 'Name', 'Amount'])
    ->applyFontStyleBold()
    ->applyBorder(Style::BORDER_STYLE_THIN);

// Set column formats and widths
$sheet
    ->setColFormats(['@date', '@text', '0.00'])
    ->setColWidths([12, 14, 8]);

// Write data
foreach ($data as $rowData) {
    $sheet->writeRow($rowData);
}

// Save to a file
$excel->save('simple.xlsx');

// ...or download generated file to client (send to browser)
// $excel->download('simple.xlsx');

Documentation

Read more in the documentation here or here. Or check out the API reference. Also, you can see examples in /demo folder.

Upgrading from an older version? See the upgrade guide.

Changelog is here.

FastExcelWriter vs PhpSpreadsheet

PhpSpreadsheet is a perfect library with wonderful features for reading and writing many document formats. FastExcelWriter can only write and only in XLSX format, but does it very fast and with minimal memory usage.

FastExcelWriter:

7-9 times faster
uses less memory by 8-10 times
supports writing huge 100K+ row spreadsheets

Benchmark of PhpSpreadsheet (generation without styles)

Rows x Cols	Time	Memory
1000 x 5	0.98 sec	2,048 Kb
1000 x 25	4.68 sec	14,336 Kb
5000 x 25	23.19 sec	77,824 Kb
10000 x 50	105.8 sec	256,000 Kb

Benchmark of FastExcelWriter (generation without styles)

Rows x Cols	Time	Memory
1000 x 5	0.19 sec	2,048 Kb
1000 x 25	1.36 sec	2,048 Kb
5000 x 25	3.61 sec	2,048 Kb
10000 x 50	13.02 sec	2,048 Kb

Do you want to support FastExcelWriter?

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 :)

avadim / fast-excel-writer

Maintainers

Package info

Statistics

Security