PHPackages                             elearning-ag/exceldatatables - 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 &amp; Document Generation](/categories/documents)
4. /
5. elearning-ag/exceldatatables

Abandoned → [svrnm/exceldatatables](/?search=svrnm%2Fexceldatatables)Library[PDF &amp; Document Generation](/categories/documents)

elearning-ag/exceldatatables
============================

Replace a worksheet within an Excel workbook (.xlsx) without changing any other properties of the file

v0.2.2(9y ago)2717918[1 issues](https://github.com/eLearningAG/exceldatatables/issues)Apache-2.0PHPPHP &gt;=5.3.0CI passing

Since Oct 21Pushed 4mo ago5 watchersCompare

[ Source](https://github.com/eLearningAG/exceldatatables)[ Packagist](https://packagist.org/packages/elearning-ag/exceldatatables)[ RSS](/packages/elearning-ag-exceldatatables/feed)WikiDiscussions master Synced today

READMEChangelog (8)Dependencies (2)Versions (7)Used By (0)

ExcelDataTables
===============

[](#exceldatatables)

Replace a worksheet within an Excel workbook (`.xlsx`) without changing any other properties of the file.

License
-------

[](#license)

This program is free software; see [LICENSE](./LICENSE) for more details.

Details
-------

[](#details)

The main purpose of this library is adding a "data table" to an existing excel file without modifying any other components. This is especially useful if you have a template file, e.g. for reporting including "advanced" features like charts, pivot tables, macros and you'd like to change a base data table within a PHP application.

Setup
-----

[](#setup)

Use composer to add this repository to your dependencies:

```
{
  "require": {
    "svrnm/exceldatatables": "dev-master"
  }
}
```

If you use the [Laravel framework](https://laravel.io/) you can additionally add the `ServiceProvider` to your `config/app.php`:

```
...
'providers' => array(
  ...
  'Svrnm\ExcelDataTables\ExcelDataTablesServiceProvider'
)
...
```

Example
-------

[](#example)

The following example demonstrates how to use ExcelDataTables. The following is also contained as `example.php` within the folder `examples/`:

```
