addHtml

When adding HTML contents, a whole cell position is filled when transforming block contents such as paragrahs, headings or links. Multiple span tags can be added in the same cell position. Each new block content is added after the previous cell position.

To embed accents and other non-ASCII characters such as á or ü, please check that the PHP Tidy extension and the PHP mbstring extension are installed and enabled.

Parameters

html

HTML and CSS content to be transformed.

position

Cell position in the active sheet: A1, C3, AB7...

options

The possible keys and values are:

Key	Type	Description
disableWrapValue	bool	If true disable using a wrap value with Tidy to prevent extra blank spaces. Default as false.
forceNotTidy	bool	False as default. If true, avoid using Tidy. Only recommended if Tidy can't be installed.
insertMode	string	Insert mode if the position contains an existing content: 'replace', 'ignore'. Default as replace.

Supported HTML contents and CSS styles

a tags. A link is added as block content and fills a cell position due to XLSX requirements
- see text element styles
p, h1, h2, h3, h4, h5, h6 tags
- background-color
- border: color, width
- dir: ltr, rtl
- text-align: left, center, right
- vertical-align: top, center, bottom
span, b, cite, em, i, s, strong, sub, sup, var tags
- see text element styles
table, tr, td, th tags
- background-color
- dir: ltr, rtl
- text-align: left, center, right
- vertical-align: top, center, bottom
th tags are added as column names.
text element styles
- color
- font-family
- font-size
- font-style: italic, oblique
- font-weight: bold, bolder, 700, 800, 900
- text-decoration: line-through, underline
- vertical-align: sub, sup

Exceptions

PHP Tidy is not enabled.

Code samples

Example #1

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsx();

$html = '<p>Lorem ipsum</p>';
$xlsx->addHtml($html, 'A1');

$html = '<style>
    p {
        font-family: Arial;
        font-style: italic;
        text-decoration: underline;
        color: #2CA87A;
        vertical-align: bottom;
    }
</style>
<p>Lorem ipsum with Arial font</p>';
$xlsx->addHtml($html, 'A3');

$html = '<a href="https://www.phpxlsx.com">Link to phpxlsx</a>';
$xlsx->addHtml($html, 'B5');

$html = '<style>
    p {
        background-color: #AEBF7A;
    }
    .c1 {
        text-decoration: underline;
        font-size: 16pt;
    }
</style>
<p>
    <b>phpxlsx</b> can transform <span class="c1">HTML to XLSX</span>.
</p>
';
$xlsx->addHtml($html, 'A10');

$xlsx->saveXlsx('output');

The resulting XLSX looks like:

Example #2

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsx();

$html = '
<style>
    #i1 {
        font-size: 18px;
    }
    .c1 {
        text-decoration: underline;
    }
    .c2 {
        color: #2CA87A;
    }
</style>
<p>
    <p>
        <b>phpxlsx</b> can transform <span class="c1">HTML to XLSX</span>.
    </p>
    <p id="i1" class="c2">
        <span class="c1">CSS styles</span> using ids and classes are supported.
    </p>
    <p class="c2">
        CSS styles classes are supported.
    </p>
</p>
<p>Links can be added:</p>
<a href="https://www.phpxlsx.com">Link</a>
<p>Heading tags are added as block elements:</p>
<h1>Heading 1</h1>
<h2>Heading 2</h2>
<h3>Heading 3</h3>
<h4>Heading 4</h4>
<h5>Heading 5</h5>
<h6>Heading 6</h6>
';
$xlsx->addHtml($html, 'A1');

$xlsx->saveXlsx('output');

The resulting XLSX looks like:

Release notes

phpxlsx 3.5: default HTML content when adding an empty content.
phpxlsx 2.5: tables.
phpxlsx 2.0: sup and sub tags and vertical-align style.
phpxlsx 1.0: new method.