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 you 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

PHP Version Support

Currently, the required PHP minimum version is PHP 7.4

Documentation

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

Changelog is here.

Installation

Use composer to install FastExcelWriter into your project:

Changes In Version 6

• Data Validation support

Important changes in version 6.1

• , , and
  are deprecated, instead of them you should use other functions: , , , , , , ,
• The behavior of the and has changed, they now set styles for the entire row or column (even if they are empty)

Changes In Version 5

• The general news is Chart support

Important changes in version 5.8

Before v.5.8

In version 5.8 and later

If you want to keep the previous behavior for backward compatibility, you should use option 'auto_convert_number' when creating a workbook.

Changes In Version 4

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

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)

Benchmark of FastExcelWriter (generation without styles)

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