PHPackages                             dcat-x/laravel-xlswriter-export - 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. [PDF & Document Generation](/categories/documents)
4. /
5. dcat-x/laravel-xlswriter-export

ActiveLibrary[PDF & Document Generation](/categories/documents)

dcat-x/laravel-xlswriter-export
===============================

A high-performance Excel export package for Laravel based on xlswriter extension, supporting large datasets with low memory usage.

v1.0.3(5mo ago)010MITPHPPHP ^8.2CI passing

Since Jan 13Pushed 5mo agoCompare

[ Source](https://github.com/dcat-x/laravel-xlswriter-export)[ Packagist](https://packagist.org/packages/dcat-x/laravel-xlswriter-export)[ Docs](https://github.com/dcat-x/laravel-xlswriter-export)[ RSS](/packages/dcat-x-laravel-xlswriter-export/feed)WikiDiscussions main Synced today

READMEChangelogDependencies (7)Versions (5)Used By (0)

Laravel Xlswriter Export
========================

[](#laravel-xlswriter-export)

 [![Tests](https://github.com/dcat-x/laravel-xlswriter-export/actions/workflows/tests.yml/badge.svg)](https://github.com/dcat-x/laravel-xlswriter-export/actions) [![Latest Stable Version](https://camo.githubusercontent.com/6b24aaf979ca52ac1f9d291c9ee6adcee02613000700bc872c9f37de12558ff1/68747470733a2f2f706f7365722e707567782e6f72672f646361742d782f6c61726176656c2d786c737772697465722d6578706f72742f762f737461626c65)](https://packagist.org/packages/dcat-x/laravel-xlswriter-export) [![Total Downloads](https://camo.githubusercontent.com/21c22babd3009741eaeb906a84011f2492b27dbbb5d77c9befdac8805381d1c7/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f646361742d782f6c61726176656c2d786c737772697465722d6578706f72742e737667)](https://packagist.org/packages/dcat-x/laravel-xlswriter-export) [![PHP Version](https://camo.githubusercontent.com/a6cbb407d7c9516800449295b3078b103b2e1c766bafda03f7ceba178aee51b9/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f7068702d382e322b2d3539613966382e737667)](https://www.php.net/) [![Laravel Version](https://camo.githubusercontent.com/9429da85454daee5672bc536c99fa284dd523403bab5556f5710ff8281468f54/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c61726176656c2d31322b2d3539613966382e737667)](https://laravel.com/) [![License](https://camo.githubusercontent.com/7013272bd27ece47364536a221edb554cd69683b68a46fc0ee96881174c4214c/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4d49542d626c75652e737667)](LICENSE)

**基于 [xlswriter](https://xlswriter-docs.viest.me/) 扩展的 Laravel 高性能 Excel 导出工具**

目录
--

[](#目录)

- [特性](#%E7%89%B9%E6%80%A7)
- [环境要求](#%E7%8E%AF%E5%A2%83%E8%A6%81%E6%B1%82)
- [安装](#%E5%AE%89%E8%A3%85)
- [快速开始](#%E5%BF%AB%E9%80%9F%E5%BC%80%E5%A7%8B)
- [配置选项](#%E9%85%8D%E7%BD%AE%E9%80%89%E9%A1%B9)
- [高级用法](#%E9%AB%98%E7%BA%A7%E7%94%A8%E6%B3%95)
- [性能基准](#%E6%80%A7%E8%83%BD%E5%9F%BA%E5%87%86)
- [API 参考](#api-%E5%8F%82%E8%80%83)
- [常见问题](#%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98)
- [故障排查](#%E6%95%85%E9%9A%9C%E6%8E%92%E6%9F%A5)
- [贡献指南](#%E8%B4%A1%E7%8C%AE%E6%8C%87%E5%8D%97)
- [许可证](#%E8%AE%B8%E5%8F%AF%E8%AF%81)

特性
--

[](#特性)

- **高性能** - 基于 C 扩展 xlswriter，导出速度快，内存占用低
- **大数据支持** - 支持 50 万+ 行数据导出，分块处理避免内存溢出
- **多数据源** - 支持 Query Builder、Collection、Array 等多种数据源
- **样式定制** - 支持单元格合并、自定义样式、冻结窗格等
- **Swoole 兼容** - 完美支持 Swoole 协程环境
- **链式调用** - 优雅的 API 设计，支持链式配置

环境要求
----

[](#环境要求)

- PHP >= 8.2
- Laravel >= 12.0
- [xlswriter](https://xlswriter-docs.viest.me/) PHP 扩展

安装
--

[](#安装)

### 1. 安装 xlswriter 扩展

[](#1-安装-xlswriter-扩展)

在安装此包之前，需要先安装 xlswriter PHP 扩展。

**Linux (推荐)**```
# 使用 PECL 安装
pecl install xlswriter

# 或者从源码编译
git clone https://github.com/viest/php-ext-xlswriter.git
cd php-ext-xlswriter
phpize
./configure
make && make install
```

添加到 `php.ini`:

```
extension=xlswriter.so
```

**macOS**```
pecl install xlswriter
```

如果使用 Homebrew 安装的 PHP:

```
# 确保 pecl 可用
brew install php

pecl install xlswriter
```

**Windows**1. 访问 [xlswriter releases](https://github.com/viest/php-ext-xlswriter/releases)
2. 下载对应 PHP 版本的 DLL 文件
3. 将 DLL 放入 PHP 的 `ext` 目录
4. 在 `php.ini` 添加: `extension=xlswriter`

**Docker**```
FROM php:8.2-fpm

RUN pecl install xlswriter \
    && docker-php-ext-enable xlswriter
```

安装后运行 `php -m | grep xlswriter` 或查看 `phpinfo()` 确认扩展已启用。

### 2. 安装扩展包

[](#2-安装扩展包)

```
composer require dcat-x/laravel-xlswriter-export
```

快速开始
----

[](#快速开始)

### 基础导出

[](#基础导出)

创建一个继承 `BaseExport` 的导出类：

```