Practical phpxlsx

HTML and CSS

Introduction

phpxlsx can transform HTML and CSS to create new contents.

HTML and CSS

addHtml is the method to add HTML:

public function addHtml($html, $position, $options = array())

This method includes the following parameters:

$html: HTML/CSS to transform
$position: cell position in the active sheet (A1, C3, AB7...)
$options: array to set extra options

XLSX spreadsheets don't support the same contents and styles that can be added with DOCX documents. XLSX supports a limited content types and styles when transforming HTML and CSS. On the addHtml API page are detailed the supported contents and styles.

Each new release of phpxlsx includes support for new contents and styles when transforming HTML and CSS.

When inserting 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 created after the previous cell position.

The following code adds a HTML content applying CSS styles:

$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');

Tips and tricks

Install and enable Tidy and mbstring PHP extensions to transform HTML.

Next - Tables