PHPackages                             starlight93/html-pdf-excel - 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. starlight93/html-pdf-excel

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

starlight93/html-pdf-excel
==========================

lightweight and fast library to render sheet-formatted-template to xlsx, pdf, and html easily. Really easy!

v1.0.3(1y ago)3168MITPHP

Since Aug 22Pushed 1y ago1 watchersCompare

[ Source](https://github.com/starlight93/php-html-pdf-excel)[ Packagist](https://packagist.org/packages/starlight93/html-pdf-excel)[ RSS](/packages/starlight93-html-pdf-excel/feed)WikiDiscussions development Synced today

READMEChangelog (4)Dependencies (3)Versions (6)Used By (0)

HTML-PDF-EXCEL
--------------

[](#html-pdf-excel)

Thanks to [TCPDF](https://github.com/tecnickcom/TCPDF) and [PHPSpreadsheet](https://github.com/PHPOffice/PhpSpreadsheet). This library is a helper to generate html, pdf, and excel from excel-based template and array data.

[![Example](testing/example-design.png)](testing/example-design.png)

### Installation

[](#installation)

```
composer require starlight93/html-pdf-excel

```

### Usage

[](#usage)

```
//  your array of data, see: /testing/1data.json
$data = [
    'key'=>'value',
    'detail' => [
        [
            'key_detail1'   => 'value1',
            'amount'    => 2000
        ],[
            'key_detail1'   => 'value2',
            'amount'    => 1000
        ]
    ]
];

//  example: function to get string from a text file
public function getFromFile( $path ){
    $file = fopen( $path, "r" );
    $dt =  fread( $file ,filesize($path) ) ;
    fclose($file);
    return $dt;
}

//  your template string, see: /testing/1template.txt
$template = getFromFile(  "your text file path" );

$renderer = new \Starlight93\HtmlPdfExcel\Renderer;
//  if you want to try with /testing data dan template just pass true to Renderer Construct
// $renderer = new \Starlight93\HtmlPdfExcel\Renderer( true );
// with parameter true will take the data and template from /testing dir, so you can focus on config only

//  ======================= example rendering PDF start
$renderer->renderPDF(data: $data, template: $template, config: [
    'title' =>'testing',
    'break' => true,
    'left'  => 10,
    'top'   => 10,
    'right' => 12,
    'orientation'   =>'L',
    'size'  => [210, 297], // can be A4, F4, etc
    'fontSize'  => 10,
    'callback' => function( $pdf ){
        //  see tcpdf documentation for any available property and function
    },
    'header_callback' => function( $hd ){
        //  see tcpdf documentation for any available property and function
    },

    'footer_callback' => function( $ft ){
        //  see tcpdf documentation for any available property and function
    },
]);
//  ======================= end

//  ======================= example rendering XLS start
$renderer->renderXls(data: $data, template: $template, config: [
    'title' => 'testing',
    'break' => true, // to separate into
    'orientation'   =>'L',
    'size'  => 9, // see https://github.com/PHPOffice/PhpSpreadsheet/blob/master/src/PhpSpreadsheet/Worksheet/PageSetup.php
    'fontSize'  => 10
]);
//  ======================= end

//  ======================= example rendering XLS start
$renderer->renderHtml(data: $data, template: $template, config: [
    'title' =>'testing',
    // 'orientation'   =>'L',
    // 'size'  => 'A4',
    'fontSize'  => 10
]);
//  ======================= end
```

### Basic Syntax

[](#basic-syntax)

CodeDescriptionvtext verticalttext with no borderralign content to rightlalign content to leftcalign content to centerb**bold**hheader or column head+border all sides\[border left side\]border right side-border top side\_border bottom side=border doubled.number separator formatting, Example result: from 1000000 becomes 1.000.000w{number}%width {number} %. Example: w25% will set the column width to 25 % of table widthuunderlinei*italic*g[![#616469](https://camo.githubusercontent.com/9ca4c940b4a56b29a46ad4b061643e6d0413ed81bbf7fb24800ddde057ef4f3c/68747470733a2f2f7669612e706c616365686f6c6465722e636f6d2f31352f3631363436392f3030303030303f746578743d2b)](https://camo.githubusercontent.com/9ca4c940b4a56b29a46ad4b061643e6d0413ed81bbf7fb24800ddde057ef4f3c/68747470733a2f2f7669612e706c616365686f6c6465722e636f6d2f31352f3631363436392f3030303030303f746578743d2b) `gray background`y[![#e8ff17](https://camo.githubusercontent.com/8e479e0f000c724255a462f9281cde2fe424318887c2e12961e3a7d658d317cc/68747470733a2f2f7669612e706c616365686f6c6465722e636f6d2f31352f6538666631372f3030303030303f746578743d2b)](https://camo.githubusercontent.com/8e479e0f000c724255a462f9281cde2fe424318887c2e12961e3a7d658d317cc/68747470733a2f2f7669612e706c616365686f6c6465722e636f6d2f31352f6538666631372f3030303030303f746578743d2b) `yellow background`### Inside Looping Syntax

[](#inside-looping-syntax)

CodeDescription$dataIndexkey data index$detail.dataIndexdata index di detail?space or empty cell!grouping column and take the first cell value\_numberautonumberer starts from 1${looped\_array\_key}.{single\_array\_key}Set value given from key### Additional Features

[](#additional-features)

You can also use any mathematic formula to get dynamic value as the image above such as summary or etc.

### Dynamic Columns (table)

[](#dynamic-columns-table)

Below shows how to generate dynamic templates. Focus to *.dynamic* string which is shown in the picture

[![Example](testing/example-dynamic-design.png)](testing/example-dynamic-design.png)

```
//  your array of data for dynamic columns
$data = [
    'key'=>'value',
    'details' => [
        [
            'key_detail1'   => 'value1',
            'amount'    => 2000,
            'another1'    => 5000,
            'another2'    => 1000,
        ],[
            'key_detail1'   => 'value2',
            'amount'    => 1000,
            'amount'    => 2000,
            'another1'    => 2000,
            'another2'    => 4000
        ],[
            'key_detail1'   => 'value2',
            'amount'    => 1000,
            'amount'    => 2000,
            'another1'    => 3000,
            'another2'    => 2000
        ]
    ],

    // key below is to generate dynamic columns
    'dynamic' => [
        "Col Dynamic 1"=>"\$details.another1",
        "Col Dynamic 2"=>"\$details.another2",
    ]
];
```

By using data array above, the .dynamic header in the template will be replaced with the following dynamic key in the data array. So the final template result will be like this picture shown below:

[![Example](testing/example-dynamic-design-result.png)](testing/example-dynamic-design-result.png)

###  Health Score

29

—

LowBetter than 57% of packages

Maintenance31

Infrequent updates — may be unmaintained

Popularity16

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity51

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 88.9% 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 ~234 days

Total

4

Last Release

708d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/9cb446cdac2621d90e9d45cd7db6a49cbcba044da0bb6d2e1f85b15981ecb8b7?d=identicon)[starlight93](/maintainers/starlight93)

---

Top Contributors

[![starlight93](https://avatars.githubusercontent.com/u/4595828?v=4)](https://github.com/starlight93 "starlight93 (8 commits)")[![furatamasensei](https://avatars.githubusercontent.com/u/42239243?v=4)](https://github.com/furatamasensei "furatamasensei (1 commits)")

### Embed Badge

![Health badge](/badges/starlight93-html-pdf-excel/health.svg)

```
[![Health](https://phpackages.com/badges/starlight93-html-pdf-excel/health.svg)](https://phpackages.com/packages/starlight93-html-pdf-excel)
```

###  Alternatives

[maatwebsite/excel

Supercharged Excel exports and imports in Laravel

12.9k157.3M896](/packages/maatwebsite-excel)[matomo/matomo

Matomo is the leading Free/Libre open analytics platform

21.7k38.9k](/packages/matomo-matomo)[civicrm/civicrm-core

Open source constituent relationship management for non-profits, NGOs and advocacy organizations.

751291.4k43](/packages/civicrm-civicrm-core)[prestashop/prestashop

PrestaShop is an Open Source e-commerce platform, committed to providing the best shopping cart experience for both merchants and customers.

9.1k17.8k](/packages/prestashop-prestashop)[craftcms/cms

Craft CMS

3.6k3.6M3.1k](/packages/craftcms-cms)[solspace/craft-freeform

The most flexible and user-friendly form building plugin!

54681.3k19](/packages/solspace-craft-freeform)

PHPackages © 2026

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