ticketpark/htmlphpexcel

A php library based on PHPExcel to convert html tables to Excel files, including styling.

HtmlPhpExcel

, _(*1)

This is a php library based on FastExcelWriter, simplifying converting html tables to excel files. It allows styling right within the html template with specific attributes., _(*2)

Installation

Add HtmlPhpExcel to your composer.json:, _(*3)

composer require ticketpark/htmlphpexcel

Simple example

<?php

require_once('vendor/autoload.php');

$html = '

For a more complex example see example directory., _(*4)

Styling

Styles are set with an html attribute _excel-styles. The attribute expects the content to be in json format., _(*5)

Example:, _(*6)

<table>
    <tr _excel-styles='{"height": 50}'>
        <td _excel-styles='{"font-size": 16, "font-color": "#FF0000", "width": 200}'>
            Cell value
        </td>
    </tr>
</table>

You can use any style supported by fast-excel-writer, of which the most common are:, _(*7)

• border-color
• border-style
• fill-color
• fill-pattern
• font-color
• font-size
• format
• format-text-wrap
• height
• hyperlink
• text-align
• text-color
• text-rotation
• text-wrap
• vertical-align
• width

More information (though unfortunately limited) is available in the docs of FastExcelWriter., _(*8)

Adding links to cells

Links are treated like styles and added with the hyperlink key:, _(*9)

Example:, _(*10)

<table>
    <tr>
        <td _excel-styles='{"hyperlink": "http://www.google.com"}'>
            Cell value
        </td>
    </tr>
</table>

Adding comments to cells

To add comments, use the _excel-comment attribute., _(*11)

Example:, _(*12)

<table>
    <tr >
        <td _excel-comment="This is a comment.">
            Cell value
        </td>
    </tr>
</table>

History

• v2.x of this library is based on FastExcelWriter
• v1.x of this library was based on PhpSpreadsheet
• v0.x of this library was based on PhpExcel