PHPackages                             conceptsandtraining/lib-excel-wrapper - 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. conceptsandtraining/lib-excel-wrapper

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

conceptsandtraining/lib-excel-wrapper
=====================================

1.0.1(1y ago)020.5k2GPL-3.0PHP

Since May 8Pushed 1y ago4 watchersCompare

[ Source](https://github.com/conceptsandtraining/lib-excel-wrapper)[ Packagist](https://packagist.org/packages/conceptsandtraining/lib-excel-wrapper)[ RSS](/packages/conceptsandtraining-lib-excel-wrapper/feed)WikiDiscussions master Synced 2w ago

READMEChangelogDependencies (4)Versions (6)Used By (0)

Excel wrapper
=============

[](#excel-wrapper)

*A wrapper for a streaming excel-writer.*

**Contacts:** [Richard Klees](https://github.com/klees)

Writing files
-------------

[](#writing-files)

An excel-write has to implement a kind of functionality as defined.

- Create a writer object
- Define style for single column at any time
- Fill the sheet row by row
- Create new sheets and switch by name
- Save to given folder and filename

To fill the sheet row by row is a recommended feature to increase the speed on mass export of data. It will not be possible to step back to rows or single columns to change values or something else.

```
public function addRow(array $values) {
    $this->writer->addRow($values);
}
```

For designing the sheet, it is possible to give any column at any time a new style. E.g. in row 1 to 5 the colum A is bold and left orientated. Starting with row 6 it will only left orientated and not longer bold. This gives the opportunity to design column headers or highlight special values.

```
public function setColumnStyle(Style $style, $column) {
    $this->writer->setColumnStyle($column, $style);
};
```

It is possible to create new sheets and switch them by name. If you creating a new sheet, it will be automaticly the current.

```
public function createSheet($name) {
    $this->writer->createSheet($name);
}

Public function selectSheet($name) {
    $this->writer->setCurrentSheet($name);
}
```

Define Styles
-------------

[](#define-styles)

A column can be styled in a lot of ways. This wrapper includes the mostly used.

- Font family
- Font size
- Bold
- Italic
- Underline
- Text color
- Background color
- Orientation
- Border
- Border color

```
public function getNewStyle() {
    $style = new Style();
    $style ->setFontFamily('Aarial')
           ->setFontSize(12)
           ->setItalic(false)
           ->setBorder(Style::TOP);

    return $style;
}
```

Example for use
---------------

[](#example-for-use)

This is a small example for using this wrapper.

```
public function exportData($file_name, $file_path, array $header, array $values) {
    $writer = new Writer();
    $writer->setFileName($file_name);
    $writer->setPath($file_path);

    $header_style = $this->getHeaderStyle();
    $writer->setColumnStyle('A', $header_style);
    $write->addRow($header);

    $bold_style = $this->getBoldStyle();
    $basic_style = $this->getBasicStyle();

    $writer->setColumnStyle('A', $bold_style);
    $writer->setColumnStyle('B', $basic_style);
    foreach($values as $value) {
        $write->addRow($value);
    }

    $writer->setColumnStyle('A', $basic_style);
    $writer->setColumnStyle('B', $bold_style);
    foreach($values as $value) {
        $write->addRow($value);
    }

    $writer->saveFile();
    $write->close();
}

protected function getHeaderStyle() {
    $style = new Style()
    $style->setBold(true)
          ->setItalic(true);

    return $style;
}

protected function getBoldStyle() {
    $style = new Style()
    $style->setBold(true)

    return $style;
}

protected function getBsicStyle() {
    return new Style();
}
```

The xlsx sheet result might be look like this.

R\\CAB1***Content for header***2**Content in the first column**Content in the second column3**Content in the first column**Content in the second column4Content in the first column**Content in the second column**5Content in the first column**Content in the second column**

###  Health Score

41

—

FairBetter than 87% of packages

Maintenance47

Moderate activity, may be stable

Popularity22

Limited adoption so far

Community18

Small or concentrated contributor base

Maturity67

Established project with proven stability

 Bus Factor1

Top contributor holds 84.2% 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 ~643 days

Total

5

Last Release

400d ago

Major Versions

v0.4.1 → 1.0.02025-05-21

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/10611082?v=4)[Richard Klees](/maintainers/klees)[@klees](https://github.com/klees)

![](https://avatars.githubusercontent.com/u/3328364?v=4)[Nils Haagen](/maintainers/nhaagen)[@nhaagen](https://github.com/nhaagen)

![](https://avatars.githubusercontent.com/u/12557020?v=4)[Stefan Hecken](/maintainers/shecken)[@shecken](https://github.com/shecken)

![](https://avatars.githubusercontent.com/u/22291200?v=4)[Daniel Weise](/maintainers/daniwe4)[@daniwe4](https://github.com/daniwe4)

---

Top Contributors

[![shecken](https://avatars.githubusercontent.com/u/12557020?v=4)](https://github.com/shecken "shecken (48 commits)")[![daniwe4](https://avatars.githubusercontent.com/u/22291200?v=4)](https://github.com/daniwe4 "daniwe4 (3 commits)")[![klees](https://avatars.githubusercontent.com/u/10611082?v=4)](https://github.com/klees "klees (3 commits)")[![tbongers-cat](https://avatars.githubusercontent.com/u/117283193?v=4)](https://github.com/tbongers-cat "tbongers-cat (3 commits)")

---

Tags

excellib

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/conceptsandtraining-lib-excel-wrapper/health.svg)

```
[![Health](https://phpackages.com/badges/conceptsandtraining-lib-excel-wrapper/health.svg)](https://phpackages.com/packages/conceptsandtraining-lib-excel-wrapper)
```

###  Alternatives

[rap2hpoutre/fast-excel

Fast Excel import/export for Laravel

2.3k26.3M51](/packages/rap2hpoutre-fast-excel)[spatie/simple-excel

Read and write simple Excel and CSV files

1.4k11.0M67](/packages/spatie-simple-excel)[unopim/unopim

UnoPim Laravel PIM

10.5k2.2k](/packages/unopim-unopim)[kimai/kimai

Kimai - Time Tracking

4.8k8.7k1](/packages/kimai-kimai)[flow-php/flow

PHP ETL - Extract Transform Load - Data processing framework

84735.1k](/packages/flow-php-flow)[laravel-enso/tables

Server-side data tables and export backend for Laravel Enso

63254.7k81](/packages/laravel-enso-tables)

PHPackages © 2026

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