Download the PHP package starlight93/html-pdf-excel without Composer
On this page you can find all versions of the php package starlight93/html-pdf-excel. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download starlight93/html-pdf-excel
More information about starlight93/html-pdf-excel
Files in starlight93/html-pdf-excel
Package html-pdf-excel
Short Description lightweight and fast library to render sheet-formatted-template to xlsx, pdf, and html easily. Really easy!
License MIT
Informations about the package html-pdf-excel
HTML-PDF-EXCEL
Thanks to TCPDF and PHPSpreadsheet. This library is a helper to generate html, pdf, and excel from excel-based template and array data.
Installation
Usage
Basic Syntax
Code | Description |
---|---|
v | text vertical |
t | text with no border |
r | align content to right |
l | align content to left |
c | align content to center |
b | bold |
h | header 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.000 |
w{number}% | width {number} %. Example: w25% will set the column width to 25 % of table width |
u | underline |
i | italic |
g | gray background |
y | yellow background |
Inside Looping Syntax
Code | Description |
---|---|
$dataIndex | key data index |
$detail.dataIndex | data index di detail |
? | space or empty cell |
! | grouping column and take the first cell value |
_number | autonumberer starts from 1 |
${looped_array_key}.{single_array_key} | Set value given from key |
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)
Below shows how to generate dynamic templates. Focus to .dynamic string which is shown in the picture
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:
All versions of html-pdf-excel with dependencies
phpoffice/phpspreadsheet Version ^1.21
mossadal/math-parser Version ^1.3