PHPackages                             slam/openspout-helper - 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. [Utility & Helpers](/categories/utility)
4. /
5. slam/openspout-helper

ActiveLibrary[Utility & Helpers](/categories/utility)

slam/openspout-helper
=====================

PhpSpreadsheet helper to create organized data table

v3.0.0(5mo ago)915.5k↓75%1[1 PRs](https://github.com/Slamdunk/openspout-helper/pulls)MITPHPPHP ~8.4.0 || ~8.5.0CI passing

Since Mar 4Pushed 2mo ago1 watchersCompare

[ Source](https://github.com/Slamdunk/openspout-helper)[ Packagist](https://packagist.org/packages/slam/openspout-helper)[ Fund](https://paypal.me/filippotessarotto)[ GitHub Sponsors](https://github.com/Slamdunk)[ RSS](/packages/slam-openspout-helper/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (10)Dependencies (7)Versions (18)Used By (0)

Slam Openspout helper to create organized data table
====================================================

[](#slam-openspout-helper-to-create-organized-data-table)

[![Latest Stable Version](https://camo.githubusercontent.com/6db9d8c72e3b8c5af5a0713be4715fd108263c7768f3b90804c6c95c137ba886/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f736c616d2f6f70656e73706f75742d68656c7065722e737667)](https://packagist.org/packages/slam/openspout-helper)[![Downloads](https://camo.githubusercontent.com/ffd98de919e1c580a5739e37ab53e34d0145ec9fe7e9a5c84551103ae066a573/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f736c616d2f6f70656e73706f75742d68656c7065722e737667)](https://packagist.org/packages/slam/openspout-helper)[![CI](https://github.com/Slamdunk/openspout-helper/actions/workflows/ci.yaml/badge.svg)](https://github.com/Slamdunk/openspout-helper/actions/workflows/ci.yaml)[![Infection MSI](https://camo.githubusercontent.com/60ad70c7588c36d5248f2cd55bce9ce46a4cb7a200dd631a0181c6a9f6e1613d/68747470733a2f2f696d672e736869656c64732e696f2f656e64706f696e743f7374796c653d666c61742675726c3d687474707325334125324625324662616467652d6170692e737472796b65722d6d757461746f722e696f2532466769746875622e636f6d253246536c616d64756e6b2532466f70656e73706f75742d68656c7065722532466d61696e)](https://dashboard.stryker-mutator.io/reports/github.com/Slamdunk/openspout-helper/main)

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

[](#installation)

`composer require slam/openspout-helper`

Usage
-----

[](#usage)

```
use OpenSpout\Writer\Common\Creator\WriterEntityFactory;
use Slam\OpenspoutHelper as ExcelHelper;

require __DIR__ . '/vendor/autoload.php';

// Being an `iterable`, the data can be any dinamically generated content
// for example a PDOStatement set on unbuffered query
$users = [
    [
        'column_1' => 'John',
        'column_2' => '123.45',
        'column_3' => '2017-05-08',
    ],
    [
        'column_1' => 'Mary',
        'column_2' => '4321.09',
        'column_3' => '2018-05-08',
    ],
];

$columnCollection = new ExcelHelper\ColumnCollection(...[
    new ExcelHelper\Column('column_1',  'User',     10,     new ExcelHelper\CellStyle\Text()),
    new ExcelHelper\Column('column_2',  'Amount',   15,     new ExcelHelper\CellStyle\Amount()),
    new ExcelHelper\Column('column_3',  'Date',     15,     new ExcelHelper\CellStyle\Date()),
]);

$XLSXWriter  = WriterEntityFactory::createXLSXWriter();
$XLSXWriter->openToFile(__DIR__.'/test.xlsx');

$activeSheet = $XLSXWriter->getCurrentSheet();
$activeSheet->setName('My Users');
$table = new ExcelHelper\Table($activeSheet, 'My Heading', $users);
$table->setColumnCollection($columnCollection);

(new ExcelHelper\TableWriter())->writeTable($XLSXWriter, $table);
$XLSXWriter->close();
```

Result:

[![Example](https://raw.githubusercontent.com/Slamdunk/openspout-helper/master/example.png)](https://raw.githubusercontent.com/Slamdunk/openspout-helper/master/example.png)

###  Health Score

54

—

FairBetter than 97% of packages

Maintenance78

Regular maintenance activity

Popularity32

Limited adoption so far

Community13

Small or concentrated contributor base

Maturity75

Established project with proven stability

 Bus Factor1

Top contributor holds 83.8% 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.

###  Release Activity

Cadence

Every ~97 days

Recently: every ~265 days

Total

15

Last Release

168d ago

Major Versions

v0.1.3 → v1.0.02022-03-25

v1.0.1 → v2.0.02022-03-29

v2.5.0 → v3.0.02025-12-01

PHP version history (5 changes)v0.1.0PHP ~8.1.0

v2.2.0PHP ~8.1.0 || ~8.2.0

v2.3.0PHP ~8.2.0 || ~8.3.0

v2.4.0PHP ~8.3.0 || ~8.4.0

v2.5.0PHP ~8.4.0 || ~8.5.0

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/50348?v=4)[Sahn Lam](/maintainers/Slam)[@slam](https://github.com/slam)

---

Top Contributors

[![renovate[bot]](https://avatars.githubusercontent.com/in/2740?v=4)](https://github.com/renovate[bot] "renovate[bot] (284 commits)")[![Slamdunk](https://avatars.githubusercontent.com/u/152236?v=4)](https://github.com/Slamdunk "Slamdunk (45 commits)")[![dependabot[bot]](https://avatars.githubusercontent.com/in/29110?v=4)](https://github.com/dependabot[bot] "dependabot[bot] (8 commits)")[![bionda740](https://avatars.githubusercontent.com/u/71380556?v=4)](https://github.com/bionda740 "bionda740 (2 commits)")

###  Code Quality

TestsPHPUnit

Static AnalysisPHPStan

Type Coverage Yes

### Embed Badge

![Health badge](/badges/slam-openspout-helper/health.svg)

```
[![Health](https://phpackages.com/badges/slam-openspout-helper/health.svg)](https://phpackages.com/packages/slam-openspout-helper)
```

###  Alternatives

[laravel-enso/tables

Data Table library with server-side processing and a VueJS component

63153.4k49](/packages/laravel-enso-tables)[glhd/conveyor-belt

14797.0k](/packages/glhd-conveyor-belt)[instride/data-definitions

Data Definitions allows you to define your DataObject Imports and Exports using a nice GUI and re-run the definitions as often you like.

8117.7k](/packages/instride-data-definitions)[laravel-enso/data-import

Excel Importer dependency for Laravel Enso

2042.6k3](/packages/laravel-enso-data-import)

PHPackages © 2026

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