PHPackages                             sivolobov94/fast-excel-writer - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [File & Storage](/categories/file-storage)
4. /
5. sivolobov94/fast-excel-writer

ActiveLibrary[File & Storage](/categories/file-storage)

sivolobov94/fast-excel-writer
=============================

Lightweight and very fast XLSX Excel Spreadsheet Writer in PHP

0317PHP

Since Dec 19Pushed 2y agoCompare

[ Source](https://github.com/sivolobov94/fast-excel-writer)[ Packagist](https://packagist.org/packages/sivolobov94/fast-excel-writer)[ RSS](/packages/sivolobov94-fast-excel-writer/feed)WikiDiscussions master Synced 2d ago

READMEChangelogDependenciesVersions (1)Used By (0)

[![Latest Stable Version](https://camo.githubusercontent.com/9a37fe4155c4304acb6103262941e6cc84f95f4350b6998f8e630d2815895392/687474703a2f2f706f7365722e707567782e6f72672f61766164696d2f666173742d657863656c2d7772697465722f76)](https://packagist.org/packages/avadim/fast-excel-writer)[![Total Downloads](https://camo.githubusercontent.com/1eb21df5ec47f279ecfde739d2b8497ac25e31397031e996c47a0817512804e9/687474703a2f2f706f7365722e707567782e6f72672f61766164696d2f666173742d657863656c2d7772697465722f646f776e6c6f616473)](https://packagist.org/packages/avadim/fast-excel-writer)[![License](https://camo.githubusercontent.com/a6086fc70dd808e68cf85a8cb0720539b08eec5506db5ac09721ef466d643e42/687474703a2f2f706f7365722e707567782e6f72672f61766164696d2f666173742d657863656c2d7772697465722f6c6963656e7365)](https://packagist.org/packages/avadim/fast-excel-writer)[![PHP Version Require](https://camo.githubusercontent.com/dd24537b1aa1cb6cdcda8999b8fb33aa5cd11afd75c270b2a639dd06e1c9759a/687474703a2f2f706f7365722e707567782e6f72672f61766164696d2f666173742d657863656c2d7772697465722f726571756972652f706870)](https://packagist.org/packages/avadim/fast-excel-writer)

FastExcelWriter
===============

[](#fastexcelwriter)

**FastExcelWriter** is a part of the **FastExcelPhp Project** which consists of

- [FastExcelWriter](https://packagist.org/packages/avadim/fast-excel-writer) - to create Excel spreadsheets
- [FastExcelReader](https://packagist.org/packages/avadim/fast-excel-reader) - to reader Excel spreadsheets
- [FastExcelTemplator](https://packagist.org/packages/avadim/fast-excel-templator) - to generate Excel spreadsheets from XLSX templates
- [FastExcelLaravel](https://packagist.org/packages/avadim/fast-excel-laravel) - special **Laravel** edition

Introduction
------------

[](#introduction)

This library is designed to be lightweight, super-fast and requires minimal memory usage.

**FastExcelWriter** creates Excel compatible spreadsheets in XLSX format (Office 2007+), 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 you XLSX-files
- Supports workbook and sheet protection with/without passwords
- Supports page settings - page margins, page size

Jump To:

- [Changes in version 4](#changes-in-version-4)
- [Simple Example](#simple-example)
- [Advanced Example](#advanced-example)
- [Row's settings](#rows-settings)
- [Column's settings](#columns-settings)
- [Define Named Ranges](#define-named-ranges)
- [Adding Notes](#adding-notes)
- [Adding Images](#adding-images)
- [Workbook](/docs/01-workbook.md)
    - [Workbook settings](/docs/01-workbook.md#workbook-settings)
    - [Sets metadata of workbook](/docs/01-workbook.md#sets-metadata-of-workbook)
    - [Set Directory For Temporary Files](/docs/01-workbook.md#set-directory-for-temporary-files)
    - [Helpers methods](/docs/01-workbook.md#helpers-methods)
- [Sheets](/docs/02-sheets.md)
    - [Create, select and remove sheet](/docs/02-sheets.md#create-select-and-remove-sheet)
    - [Sheet settings](/docs/02-sheets.md#sheet-settings)
    - [Page settings](/docs/02-sheets.md#page-settings)
    - [Freeze Panes and Autofilter](/docs/02-sheets.md#freeze-panes-and-autofilter)
    - [Setting Active Cells](/docs/02-sheets.md#setting-active-cells)
- [Writing](/docs/03-writing.md)
    - [Writing Row by Row vs Direct](/docs/03-writing.md#writing-row-by-row-vs-direct)
    - [Direct Writing To Cells](/docs/03-writing.md#direct-writing-to-cells)
    - [Writing Cell Values](/docs/03-writing.md#writing-cell-values)
    - [Merging Cells](/docs/03-writing.md#merging-cells)
    - [Cell Formats](/docs/03-writing.md#cell-formats)
    - [Formulas](/docs/03-writing.md#formulas)
    - [Hyperlinks](/docs/03-writing.md#hyperlinks)
- [Styles](/docs/04-styles.md)
    - [Cell Styles](/docs/04-styles.md#cell-styles)
    - [Row Styles](/docs/04-styles.md#row-styles)
    - [Column Styles](/docs/04-styles.md#column-styles)
    - [Other Columns Options](/docs/04-styles.md#other-columns-options)
    - [Apply Styles (The Fluent Interface)](/docs/04-styles.md#apply-styles--the-fluent-interface-)
    - [Apply Borders](/docs/04-styles.md#apply-borders)
    - [Apply Fonts](/docs/04-styles.md#apply-fonts)
    - [Apply Colors](/docs/04-styles.md#apply-colors)
    - [Apply Text Styles](/docs/04-styles.md#apply-text-styles)
- [Protection of workbook and sheets](/docs/05-protection.md)
    - [Workbook protection](/docs/05-protection.md#workbook-protection)
    - [Sheet protection](/docs/05-protection.md#sheet-protection)
    - [Cells locking/unlocking](/docs/05-protection.md#cells-lockingunlocking)
- [FastExcelWriter vs PhpSpreadsheet](#fastexcelwriter-vs-phpspreadsheet)
- [Do you want to support FastExcelWriter?](#do-you-want-to-support-fastexcelwriter)

Installation
------------

[](#installation)

Use `composer` to install **FastExcelWriter** into your project:

```
composer require Sivolobov/fast-excel-writer

```

Changes In Version 4
--------------------

[](#changes-in-version-4)

- Now the library works even faster
- Added a fluent interface for applying styles.
- New methods and code refactoring

Usage
-----

[](#usage)

You can find usage examples below or in */demo* folder

### Simple Example

[](#simple-example)

```
use \avadim\FastExcelWriter\Excel;

$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 heads
$sheet->writeRow(['Date', 'Name', 'Amount']);

// Write data
foreach($data as $rowData) {
    $rowOptions = [
        'height' => 20,
    ];
    $sheet->writeRow($rowData, $rowOptions);
}

$excel->save('simple.xlsx');
```

Also, you can download generated file to client (send to browser)

```
$excel->download('download.xlsx');
```

### Advanced Example

[](#advanced-example)

```
use \avadim\FastExcelWriter\Excel;

$head = ['Date', 'Name', 'Amount'];
$data = [
    ['2003-12-31', 'James', '220'],
    ['2003-8-23', 'Mike', '153.5'],
    ['2003-06-01', 'John', '34.12'],
];
$headStyle = [
    'font' => [
        'style' => 'bold'
    ],
    'text-align' => 'center',
    'vertical-align' => 'center',
    'border' => 'thin',
    'height' => 24,
];

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

// Write the head row (sets style via array)
$sheet->writeHeader($head, $headStyle);

// The same result with new fluent interface
$sheet->writeHeader($head)
    ->applyFontStyleBold()
    ->applyTextAlign('center', 'center')
    ->applyBorder(Style::BORDER_STYLE_THIN)
    ->applyRowHeight(24);

// Sets columns options - format and width (the first way)
$sheet
    ->setColFormats(['@date', '@text', '0.00'])
    ->setColWidths([12, 14, 5]);

// The seconds way to set columns options
$sheet
    // column and options
    ->setColOptions('A', ['format' => '@date', 'width' => 12])
    // column letter in lower case
    ->setColOptions('b', ['format' => '@text', 'width' => 24])
    // column can be specified by number
    ->setColOptions(3, ['format' => '0.00', 'width' => 15, 'color' => '#090'])
;

// The third way - all options in multilevel array (first level keys point to columns)
$sheet
    ->setColOptions([
        'A' => ['format' => '@date', 'width' => 12],
        'B' => ['format' => '@text', 'width' => 24],
        'C' => ['format' => '0.00', 'width' => 15, 'color' => '#090'],
    ]);

$rowNum = 1;
foreach($data as $rowData) {
    $rowOptions = [
        'height' => 20,
    ];
    if ($rowNum % 2) {
        $rowOptions['fill-color'] = '#eee';
    }
    $sheet->writeRow($rowData, $rowOptions);
}

$excel->save('simple.xlsx');
```

### Row's settings

[](#rows-settings)

You can set row options (styles and height) by the second argument when you use the function `writeRow()`. Note that in this case these styles will only be applied to those cells in the row where data is written

```
// Write row data and set height
$rowOptions = [
    'fill-color' => '#fffeee',
    'border' => 'thin',
    'height' => 28,
];
$sheet->writeRow(['aaa', 'bbb', 'ccc'], $rowOptions);
```

Other way with the same result

```
$sheet->writeRow(['aaa', 'bbb', 'ccc', null, 'eee'])
    ->applyFillColor('#fffeee')
    ->applyBorder('thin')
    ->applyRowHeight(28);
```

You can set row's height or visibility

```
// Set height of row 2 to 33
$sheet->setRowHeight(2, 33);

// Set height of rows 3,5 and 7 to 33
$sheet->setRowHeight([3, 5, 7], 33);

// Set heights of several rows
$sheet->setRowHeights([1 => 20, 2 => 33, 3 => 40]);

// Hide row 8
$sheet->setRowVisible(8, false);

// Other way
$sheet->setRowHidden(8);

// Hide rows 9, 10, 11
$sheet->setRowVisible([9, 10, 11], false);

// Show row 10
$sheet->setRowVisible(10, true);
```

IMPORTANT: You can only use the setRowXX() functions on rows numbered at least as high as the current one. See [Writing Row by Row vs Direct](/docs/03-writing.md#writing-row-by-row-vs-direct)Therefore, the following code will throw an error "Row number must be greater then written rows"

```
$sheet = $excel->sheet();
// Write row 1
$sheet->writeRow(['aaa1', 'bbb1', 'ccc1']);
// Write row 2
$sheet->writeRow(['aaa2', 'bbb2', 'ccc2']);
// Try to set height of previous row 1
$sheet->setRowHeight(1, 33);
```

### Column's settings

[](#columns-settings)

Column widths can be set in several ways

```
// Set width of column D to 24
$this->setColWidth('D', 24);
$this->setColOptions('D', ['width' => 24]);
// Set auto width
$this->setColWidth('D', 'auto');
$this->setColWidthAuto('D');
$this->setColOptions('D', ['width' => 'auto']);

// Set width of specific columns
$sheet->setColWidths(['B' => 10, 'C' => 'auto', 'E' => 30, 'F' => 40]);
// Set width of columns from 'A'
$sheet->setColWidths([10, 20, 30, 40], 24);

$colOptions = [
    'B' => ['width' => 10],
    'C' => ['width' => 'auto'],
    'E' => ['width' => 30],
    'F' => ['width' => 40],
];
$sheet->setColOptions($colOptions);
```

You can define a minimal width of columns. Note that the minimum value has higher priority

```
// Set minimum width to 20
$this->setColMinWidth('D', 20);
// The value 10 will not be set because it is less than the minimum value
$this->setColWidth('D', 10);
// But width 30 will be set
$this->setColWidth('D', 30);
// The column width will be set to the width of the content, but not less than 20
$this->setColWidthAuto('D');
```

### Define Named Ranges

[](#define-named-ranges)

FastExcelWriter supports *named ranges* and does not support *named formulae*. A *named ranges* provides a name reference to a cell or a range of cells. All *named ranges* are added to the workbook so all names must be unique, but you can define *named ranges* in a sheet or in a workbook.

Also range names must start with a letter or underscore, have no spaces, and be no longer than 255 characters.

```
$excel = Excel::create();
$excel->setFileName($outFileName);
$sheet = $excel->sheet();

// Named a single cell
$sheet->addNamedRange('B2', 'cell_name');

// Named range in a sheet
$sheet->addNamedRange('c2:e3', 'range_name');

// Add named range in a workbook (sheet name required)
$excel->addNamedRange('Sheet1!A1:F5', 'A1_F5');

// You can define name using applyNamedRange()
$sheet->writeCell(1000)->applyNamedRange('Value');
$sheet->writeCell(0.12)->applyNamedRange('Rate');
// Add the formula using names
$sheet->writeCell('=Value*Rate');
```

### Adding Notes

[](#adding-notes)

There are currently two types of comments in Excel - **comments** and **notes**(see [The difference between threaded comments and notes](https://support.microsoft.com/en-us/office/the-difference-between-threaded-comments-and-notes-75a51eec-4092-42ab-abf8-7669077b7be3)). Notes are old style comments in Excel (text on a light yellow background). You can add notes to any cells using method `addNote()`

```
$sheet->writeCell('Text to A1');
$sheet->addNote('A1', 'This is a note for cell A1');

$sheet->writeCell('Text to B1')->addNote('This is a note for B1');
$sheet->writeTo('C4', 'Text to C4')->addNote('Note for C1');

// If you specify a range of cells, then the note will be added to the left top cell
$sheet->addNote('E4:F8', "This note\nwill added to E4");

// You can split text into multiple lines
$sheet->addNote('D7', "Line 1\nLine 2");
```

You can change some note options. Allowed options of a note are:

- **width** - default value is `'96pt'`
- **height** - default value is `'55.5pt'`
- **fill\_color** - default value is `'#FFFFE1'`
- **show** - default value is `false`

```
$sheet->addNote('A1', 'This is a note for cell A1', ['width' => '200pt', 'height' => '100pt', 'fill_color' => '#ffcccc']);

// Parameters "width" and "height" can be numeric, by default these values are in points
// The "fill_color" parameter can be shortened
$noteStyle = [
    'width' => 200, // equivalent to '200pt'
    'height' => 100, // equivalent to '100pt'
    'fill_color' => 'fcc', // equivalent to '#ffcccc'
];
$sheet->writeCell('Text to B1')->addNote('This is a note for B1', $noteStyle);

// This note is visible when the Excel workbook is displayed
$sheet->addNote('C8', 'This note is always visible', ['show' => true]);
```

### Adding Images

[](#adding-images)

```
// Insert an image to the cell A1
$sheet->addImage('A1', 'path/to/file');

// Insert an image to the cell B2 and set with to 150 pixels (height will change proportionally)
$sheet->addImage('B2', 'path/to/file', ['width' => 150]);

// Set height to 150 pixels (with will change proportionally)
$sheet->addImage('C3', 'path/to/file', ['height' => 150]);

// Set size in pixels
$sheet->addImage('D4', 'path/to/file', ['width' => 150, 'height' => 150]);
```

**FastExcelWriter** vs **PhpSpreadsheet**
-----------------------------------------

[](#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 (P) and FastExcelWriter (F), spreadsheet generation without styles

Rows x ColsTime **P**Time **F**Memory **P**Memory **F**1000 x 50.98 sec0.19 sec2,048 Kb2,048 Kb1000 x 254.68 sec1.36 sec14,336 Kb2,048 Kb5000 x 2523.19 sec3.61 sec77,824 Kb2,048 Kb10000 x 50105.8 sec13.02 sec256,000 Kb2,048 KbDo you want to support FastExcelWriter?
---------------------------------------

[](#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 :)

###  Health Score

17

—

LowBetter than 6% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity16

Limited adoption so far

Community11

Small or concentrated contributor base

Maturity20

Early-stage or recently created project

 Bus Factor1

Top contributor holds 92.4% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/25684296?v=4)[sivolobov94](/maintainers/sivolobov94)[@sivolobov94](https://github.com/sivolobov94)

---

Top Contributors

[![aVadim483](https://avatars.githubusercontent.com/u/2246758?v=4)](https://github.com/aVadim483 "aVadim483 (122 commits)")[![jarrod-colluco](https://avatars.githubusercontent.com/u/94315760?v=4)](https://github.com/jarrod-colluco "jarrod-colluco (6 commits)")[![xdrew](https://avatars.githubusercontent.com/u/1220667?v=4)](https://github.com/xdrew "xdrew (2 commits)")[![albertbrufau](https://avatars.githubusercontent.com/u/590087?v=4)](https://github.com/albertbrufau "albertbrufau (1 commits)")[![maciejstepien-arch](https://avatars.githubusercontent.com/u/234204112?v=4)](https://github.com/maciejstepien-arch "maciejstepien-arch (1 commits)")

### Embed Badge

![Health badge](/badges/sivolobov94-fast-excel-writer/health.svg)

```
[![Health](https://phpackages.com/badges/sivolobov94-fast-excel-writer/health.svg)](https://phpackages.com/packages/sivolobov94-fast-excel-writer)
```

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)