Inheritance diagram for PhpOffice\PhpSpreadsheet\Reader\Html:

Collaboration diagram for PhpOffice\PhpSpreadsheet\Reader\Html:

Public Member Functions
	__construct ()
	Create a new HTML Reader instance. More...

	canRead ($pFilename)
	Validate that the current file is an HTML file. More...

	load ($pFilename)
	Loads Spreadsheet from file. More...

	setInputEncoding ($pValue)
	Set input encoding. More...

	getInputEncoding ()
	Get input encoding. More...

	loadIntoExisting ($pFilename, Spreadsheet $spreadsheet)
	Loads PhpSpreadsheet from file into PhpSpreadsheet instance. More...

	loadFromString ($content, ?Spreadsheet $spreadsheet=null)
	Spreadsheet from content. More...

	getSheetIndex ()
	Get sheet index. More...

	setSheetIndex ($pValue)
	Set sheet index. More...

	getStyleColor ($value)
	Check if has #, so we can get clean hex. More...

	getBorderStyle ($style)
	Map html border style to PhpSpreadsheet border style. More...

Public Member Functions inherited from PhpOffice\PhpSpreadsheet\Reader\BaseReader
	__construct ()
	IReader constructor. More...

	getReadDataOnly ()
	Read data only? If this is true, then the Reader will only read data values for cells, it will not read any formatting information. More...

	setReadDataOnly ($pValue)
	Set read data only Set to true, to advise the Reader only to read data values for cells, and to ignore any formatting information. More...

	getReadEmptyCells ()
	Read empty cells? If this is true (the default), then the Reader will read data values for all cells, irrespective of value. More...

	setReadEmptyCells ($pValue)
	Set read empty cells Set to true (the default) to advise the Reader read data values for all cells, irrespective of value. More...

	getIncludeCharts ()
	Read charts in workbook? If this is true, then the Reader will include any charts that exist in the workbook. More...

	setIncludeCharts ($pValue)
	Set read charts in workbook Set to true, to advise the Reader to include any charts that exist in the workbook. More...

	getLoadSheetsOnly ()
	Get which sheets to load Returns either an array of worksheet names (the list of worksheets that should be loaded), or a null indicating that all worksheets in the workbook should be loaded. More...

	setLoadSheetsOnly ($value)
	Set which sheets to load. More...

	setLoadAllSheets ()
	Set all sheets to load Tells the Reader to load all worksheets from the workbook. More...

	getReadFilter ()
	Read filter. More...

	setReadFilter (IReadFilter $pValue)
	Set read filter. More...

	getSecurityScanner ()

	__construct ()
	IReader constructor. More...

	canRead ($pFilename)
	Can the current IReader read the file? More...

	getReadDataOnly ()
	Read data only? If this is true, then the Reader will only read data values for cells, it will not read any formatting information. More...

	setReadDataOnly ($pValue)
	Set read data only Set to true, to advise the Reader only to read data values for cells, and to ignore any formatting information. More...

	getReadEmptyCells ()
	Read empty cells? If this is true (the default), then the Reader will read data values for all cells, irrespective of value. More...

	setReadEmptyCells ($pValue)
	Set read empty cells Set to true (the default) to advise the Reader read data values for all cells, irrespective of value. More...

	getIncludeCharts ()
	Read charts in workbook? If this is true, then the Reader will include any charts that exist in the workbook. More...

	setIncludeCharts ($pValue)
	Set read charts in workbook Set to true, to advise the Reader to include any charts that exist in the workbook. More...

	getLoadSheetsOnly ()
	Get which sheets to load Returns either an array of worksheet names (the list of worksheets that should be loaded), or a null indicating that all worksheets in the workbook should be loaded. More...

	setLoadSheetsOnly ($value)
	Set which sheets to load. More...

	setLoadAllSheets ()
	Set all sheets to load Tells the Reader to load all worksheets from the workbook. More...

	getReadFilter ()
	Read filter. More...

	setReadFilter (IReadFilter $pValue)
	Set read filter. More...

	load ($pFilename)
	Loads PhpSpreadsheet from file. More...

Static Public Member Functions
static	getBorderMappings ()

Data Fields
const	TEST_SAMPLE_SIZE = 2048
	Sample size to read to determine if it's HTML or not. More...

Protected Member Functions
	setTableStartColumn ($column)

	getTableStartColumn ()

	releaseTableStartColumn ()

	flushCell (Worksheet $sheet, $column, $row, &$cellContent)

	processDomElement (DOMNode $element, Worksheet $sheet, int &$row, string &$column, string &$cellContent)

Protected Member Functions inherited from PhpOffice\PhpSpreadsheet\Reader\BaseReader
	openFile ($pFilename)
	Open file for reading. More...

Protected Attributes
	$inputEncoding = 'ANSI'

	$sheetIndex = 0

	$formats

	$rowspan = []

	$dataArray = []

	$tableLevel = 0

	$nestedColumn = ['A']

Protected Attributes inherited from PhpOffice\PhpSpreadsheet\Reader\BaseReader
	$readDataOnly = false

	$readEmptyCells = true

	$includeCharts = false

	$loadSheetsOnly

	$readFilter

	$fileHandle

	$securityScanner

Private Member Functions
	readBeginning ()

	readEnding ()

	processDomElementBody (Worksheet $sheet, int &$row, string &$column, string &$cellContent, DOMElement $child)

	processDomElementTitle (Worksheet $sheet, int &$row, string &$column, string &$cellContent, DOMElement $child, array &$attributeArray)

	processDomElementSpanEtc (Worksheet $sheet, int &$row, string &$column, string &$cellContent, DOMElement $child, array &$attributeArray)

	processDomElementHr (Worksheet $sheet, int &$row, string &$column, string &$cellContent, DOMElement $child, array &$attributeArray)

	processDomElementBr (Worksheet $sheet, int &$row, string &$column, string &$cellContent, DOMElement $child, array &$attributeArray)

	processDomElementA (Worksheet $sheet, int &$row, string &$column, string &$cellContent, DOMElement $child, array &$attributeArray)

	processDomElementH1Etc (Worksheet $sheet, int &$row, string &$column, string &$cellContent, DOMElement $child, array &$attributeArray)

	processDomElementLi (Worksheet $sheet, int &$row, string &$column, string &$cellContent, DOMElement $child, array &$attributeArray)

	processDomElementImg (Worksheet $sheet, int &$row, string &$column, string &$cellContent, DOMElement $child, array &$attributeArray)

	processDomElementTable (Worksheet $sheet, int &$row, string &$column, string &$cellContent, DOMElement $child, array &$attributeArray)

	processDomElementTr (Worksheet $sheet, int &$row, string &$column, string &$cellContent, DOMElement $child, array &$attributeArray)

	processDomElementThTdOther (Worksheet $sheet, int &$row, string &$column, string &$cellContent, DOMElement $child, array &$attributeArray)

	processDomElementBgcolor (Worksheet $sheet, int $row, string $column, array $attributeArray)

	processDomElementWidth (Worksheet $sheet, string $column, array $attributeArray)

	processDomElementHeight (Worksheet $sheet, int $row, array $attributeArray)

	processDomElementAlign (Worksheet $sheet, int $row, string $column, array $attributeArray)

	processDomElementVAlign (Worksheet $sheet, int $row, string $column, array $attributeArray)

	processDomElementDataFormat (Worksheet $sheet, int $row, string $column, array $attributeArray)

	processDomElementThTd (Worksheet $sheet, int &$row, string &$column, string &$cellContent, DOMElement $child, array &$attributeArray)

	loadDocument (DOMDocument $document, Spreadsheet $spreadsheet)
	Loads PhpSpreadsheet from DOMDocument into PhpSpreadsheet instance. More...

	applyInlineStyle (&$sheet, $row, $column, $attributeArray)
	Apply inline css inline style. More...

	insertImage (Worksheet $sheet, $column, $row, array $attributes)

	setBorderStyle (Style $cellStyle, $styleValue, $type)

Static Private Member Functions
static	startsWithTag ($data)

static	endsWithTag ($data)

static	containsTags ($data)

Static Private Attributes
static	$spanEtc = ['span', 'div', 'font', 'i', 'em', 'strong', 'b']

static	$h1Etc = ['h1', 'h2', 'h3', 'h4', 'h5', 'h6', 'ol', 'ul', 'p']

static	$borderMappings

Detailed Description

PhpSpreadsheet root directory.

Definition at line 22 of file Html.php.

Constructor & Destructor Documentation

◆ __construct()

PhpOffice\PhpSpreadsheet\Reader\Html::__construct ( )

Create a new HTML Reader instance.

Reimplemented from PhpOffice\PhpSpreadsheet\Reader\BaseReader.

Definition at line 130 of file Html.php.

    {
        parent::__construct();
        $this->securityScanner = XmlScanner::getInstance($this);
    }

References PhpOffice\PhpSpreadsheet\Reader\Security\XmlScanner\getInstance().

Here is the call graph for this function:

Member Function Documentation

◆ applyInlineStyle()

PhpOffice\PhpSpreadsheet\Reader\Html::applyInlineStyle	(	&	$sheet,
			$row,
			$column,
			$attributeArray
	)

private

Apply inline css inline style.

NOTES : Currently only intended for td & th element, and only takes 'background-color' and 'color'; property with HEX color

TODO :

Implement to other propertie, such as border

Parameters

Worksheet	$sheet
int	$row
string	$column
array	$attributeArray

Definition at line 743 of file Html.php.

                                                                              : void
    {
        if (!isset($attributeArray['style'])) {
            return;
        }
 
        if (isset($attributeArray['rowspan'], $attributeArray['colspan'])) {
            $columnTo = $column;
            for ($i = 0; $i < (int) $attributeArray['colspan'] - 1; ++$i) {
                ++$columnTo;
            }
            $range = $column . $row . ':' . $columnTo . ($row + (int) $attributeArray['rowspan'] - 1);
            $cellStyle = $sheet->getStyle($range);
        } elseif (isset($attributeArray['rowspan'])) {
            $range = $column . $row . ':' . $column . ($row + (int) $attributeArray['rowspan'] - 1);
            $cellStyle = $sheet->getStyle($range);
        } elseif (isset($attributeArray['colspan'])) {
            $columnTo = $column;
            for ($i = 0; $i < (int) $attributeArray['colspan'] - 1; ++$i) {
                ++$columnTo;
            }
            $range = $column . $row . ':' . $columnTo . $row;
            $cellStyle = $sheet->getStyle($range);
        } else {
            $cellStyle = $sheet->getStyle($column . $row);
        }
 
        // add color styles (background & text) from dom element,currently support : td & th, using ONLY inline css style with RGB color
        $styles = explode(';', $attributeArray['style']);
        foreach ($styles as $st) {
            $value = explode(':', $st);
            $styleName = isset($value[0]) ? trim($value[0]) : null;
            $styleValue = isset($value[1]) ? trim($value[1]) : null;
 
            if (!$styleName) {
                continue;
            }
 
            switch ($styleName) {
                case 'background':
                case 'background-color':
                    $styleColor = $this->getStyleColor($styleValue);
 
                    if (!$styleColor) {
                        continue 2;
                    }
 
                    $cellStyle->applyFromArray(['fill' => ['fillType' => Fill::FILL_SOLID, 'color' => ['rgb' => $styleColor]]]);
 
                    break;
                case 'color':
                    $styleColor = $this->getStyleColor($styleValue);
 
                    if (!$styleColor) {
                        continue 2;
                    }
 
                    $cellStyle->applyFromArray(['font' => ['color' => ['rgb' => $styleColor]]]);
 
                    break;
 
                case 'border':
                    $this->setBorderStyle($cellStyle, $styleValue, 'allBorders');
 
                    break;
 
                case 'border-top':
                    $this->setBorderStyle($cellStyle, $styleValue, 'top');
 
                    break;
 
                case 'border-bottom':
                    $this->setBorderStyle($cellStyle, $styleValue, 'bottom');
 
                    break;
 
                case 'border-left':
                    $this->setBorderStyle($cellStyle, $styleValue, 'left');
 
                    break;
 
                case 'border-right':
                    $this->setBorderStyle($cellStyle, $styleValue, 'right');
 
                    break;
 
                case 'font-size':
                    $cellStyle->getFont()->setSize(
                        (float) $styleValue
                    );
 
                    break;
 
                case 'font-weight':
                    if ($styleValue === 'bold' || $styleValue >= 500) {
                        $cellStyle->getFont()->setBold(true);
                    }
 
                    break;
 
                case 'font-style':
                    if ($styleValue === 'italic') {
                        $cellStyle->getFont()->setItalic(true);
                    }
 
                    break;
 
                case 'font-family':
                    $cellStyle->getFont()->setName(str_replace('\'', '', $styleValue));
 
                    break;
 
                case 'text-decoration':
                    switch ($styleValue) {
                        case 'underline':
                            $cellStyle->getFont()->setUnderline(Font::UNDERLINE_SINGLE);
 
                            break;
                        case 'line-through':
                            $cellStyle->getFont()->setStrikethrough(true);
 
                            break;
                    }
 
                    break;
 
                case 'text-align':
                    $cellStyle->getAlignment()->setHorizontal($styleValue);
 
                    break;
 
                case 'vertical-align':
                    $cellStyle->getAlignment()->setVertical($styleValue);
 
                    break;
 
                case 'width':
                    $sheet->getColumnDimension($column)->setWidth(
                        (float) str_replace(['px', 'pt'], '', $styleValue)
                    );
 
                    break;
 
                case 'height':
                    $sheet->getRowDimension($row)->setRowHeight(
                        (float) str_replace(['px', 'pt'], '', $styleValue)
                    );
 
                    break;
 
                case 'word-wrap':
                    $cellStyle->getAlignment()->setWrapText(
                        $styleValue === 'break-word'
                    );
 
                    break;
 
                case 'text-indent':
                    $cellStyle->getAlignment()->setIndent(
                        (int) str_replace(['px'], '', $styleValue)
                    );
 
                    break;
            }
        }
    }

References $i, $row, PhpOffice\PhpSpreadsheet\Reader\Html\getStyleColor(), and PhpOffice\PhpSpreadsheet\Reader\Html\setBorderStyle().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementThTd().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ canRead()

PhpOffice\PhpSpreadsheet\Reader\Html::canRead ( $pFilename )

Validate that the current file is an HTML file.

Parameters

string $pFilename

Returns: bool

Implements PhpOffice\PhpSpreadsheet\Reader\IReader.

Definition at line 143 of file Html.php.

    {
        // Check if file exists
        try {
            $this->openFile($pFilename);
        } catch (Exception $e) {
            return false;
        }
 
        $beginning = $this->readBeginning();
        $startWithTag = self::startsWithTag($beginning);
        $containsTags = self::containsTags($beginning);
        $endsWithTag = self::endsWithTag($this->readEnding());
 
        fclose($this->fileHandle);
 
        return $startWithTag && $containsTags && $endsWithTag;
    }

References PhpOffice\PhpSpreadsheet\Reader\Html\containsTags(), PhpOffice\PhpSpreadsheet\Reader\Html\endsWithTag(), PhpOffice\PhpSpreadsheet\Reader\BaseReader\openFile(), PhpOffice\PhpSpreadsheet\Reader\Html\readBeginning(), PhpOffice\PhpSpreadsheet\Reader\Html\readEnding(), and PhpOffice\PhpSpreadsheet\Reader\Html\startsWithTag().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\loadIntoExisting().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ containsTags()

static PhpOffice\PhpSpreadsheet\Reader\Html::containsTags ( $data )

staticprivate

Definition at line 199 of file Html.php.

    {
        return strlen($data) !== strlen(strip_tags($data));
    }

References $data.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\canRead().

Here is the caller graph for this function:

◆ endsWithTag()

static PhpOffice\PhpSpreadsheet\Reader\Html::endsWithTag ( $data )

staticprivate

Definition at line 194 of file Html.php.

    {
        return '>' === substr(trim($data), -1, 1);
    }

References $data.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\canRead().

Here is the caller graph for this function:

◆ flushCell()

PhpOffice\PhpSpreadsheet\Reader\Html::flushCell	(	Worksheet	$sheet,
			$column,
			$row,
		&	$cellContent
	)

protected

Definition at line 282 of file Html.php.

                                                                                : void
    {
        if (is_string($cellContent)) {
            //    Simple String content
            if (trim($cellContent) > '') {
                //    Only actually write it if there's content in the string
                //    Write to worksheet to be done here...
                //    ... we return the cell so we can mess about with styles more easily
                $sheet->setCellValue($column . $row, $cellContent);
                $this->dataArray[$row][$column] = $cellContent;
            }
        } else {
            //    We have a Rich Text run
            //    TODO
            $this->dataArray[$row][$column] = 'RICH TEXT: ' . $cellContent;
        }
        $cellContent = (string) '';
    }

References $row.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementBr(), PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementH1Etc(), PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementHr(), PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementLi(), PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementTable(), and PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementThTd().

Here is the caller graph for this function:

◆ getBorderMappings()

static PhpOffice\PhpSpreadsheet\Reader\Html::getBorderMappings ( )

static

Definition at line 985 of file Html.php.

                                              : array
    {
        return self::$borderMappings;
    }

References PhpOffice\PhpSpreadsheet\Reader\Html\$borderMappings.

◆ getBorderStyle()

PhpOffice\PhpSpreadsheet\Reader\Html::getBorderStyle ( $style )

Map html border style to PhpSpreadsheet border style.

Parameters

string $style

Returns: null|string

Definition at line 997 of file Html.php.

    {
        return (array_key_exists($style, self::$borderMappings)) ? self::$borderMappings[$style] : null;
    }

References $style.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\setBorderStyle().

Here is the caller graph for this function:

◆ getInputEncoding()

PhpOffice\PhpSpreadsheet\Reader\Html::getInputEncoding ( )

Get input encoding.

Returns: string

@codeCoverageIgnore

Deprecated:: no use is made of this property

Definition at line 247 of file Html.php.

    {
        return $this->inputEncoding;
    }

References PhpOffice\PhpSpreadsheet\Reader\Html\$inputEncoding.

◆ getSheetIndex()

PhpOffice\PhpSpreadsheet\Reader\Html::getSheetIndex ( )

Get sheet index.

Returns: int

Definition at line 709 of file Html.php.

    {
        return $this->sheetIndex;
    }

References PhpOffice\PhpSpreadsheet\Reader\Html\$sheetIndex.

◆ getStyleColor()

PhpOffice\PhpSpreadsheet\Reader\Html::getStyleColor ( $value )

Check if has #, so we can get clean hex.

Returns: null|string

Definition at line 915 of file Html.php.

    {
        if (strpos($value, '#') === 0) {
            return substr($value, 1);
        }
 
        return \PhpOffice\PhpSpreadsheet\Helper\Html::colourNameLookup((string) $value);
    }

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\applyInlineStyle(), PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementBgcolor(), and PhpOffice\PhpSpreadsheet\Reader\Html\setBorderStyle().

Here is the caller graph for this function:

◆ getTableStartColumn()

PhpOffice\PhpSpreadsheet\Reader\Html::getTableStartColumn ( )

protected

Definition at line 270 of file Html.php.

    {
        return $this->nestedColumn[$this->tableLevel];
    }

References PhpOffice\PhpSpreadsheet\Reader\Html\$tableLevel.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementTr().

Here is the caller graph for this function:

◆ insertImage()

PhpOffice\PhpSpreadsheet\Reader\Html::insertImage	(	Worksheet	$sheet,
			$column,
			$row,
		array	$attributes
	)

private

Parameters

string	$column
int	$row

Definition at line 928 of file Html.php.

                                                                                    : void
    {
        if (!isset($attributes['src'])) {
            return;
        }
 
        $src = urldecode($attributes['src']);
        $width = isset($attributes['width']) ? (float) $attributes['width'] : null;
        $height = isset($attributes['height']) ? (float) $attributes['height'] : null;
        $name = $attributes['alt'] ?? null;
 
        $drawing = new Drawing();
        $drawing->setPath($src);
        $drawing->setWorksheet($sheet);
        $drawing->setCoordinates($column . $row);
        $drawing->setOffsetX(0);
        $drawing->setOffsetY(10);
        $drawing->setResizeProportional(true);
 
        if ($name) {
            $drawing->setName($name);
        }
 
        if ($width) {
            $drawing->setWidth((int) $width);
        }
 
        if ($height) {
            $drawing->setHeight((int) $height);
        }
 
        $sheet->getColumnDimension($column)->setWidth(
            $drawing->getWidth() / 6
        );
 
        $sheet->getRowDimension($row)->setRowHeight(
            $drawing->getHeight() * 0.9
        );
    }

References $attributes, $name, and $row.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementImg().

Here is the caller graph for this function:

◆ load()

PhpOffice\PhpSpreadsheet\Reader\Html::load ( $pFilename )

Loads Spreadsheet from file.

Parameters

string $pFilename

Returns: Spreadsheet

Implements PhpOffice\PhpSpreadsheet\Reader\IReader.

Definition at line 211 of file Html.php.

    {
        // Create new Spreadsheet
        $spreadsheet = new Spreadsheet();
 
        // Load into this instance
        return $this->loadIntoExisting($pFilename, $spreadsheet);
    }

References PhpOffice\PhpSpreadsheet\Reader\Html\loadIntoExisting().

Here is the call graph for this function:

◆ loadDocument()

PhpOffice\PhpSpreadsheet\Reader\Html::loadDocument	(	DOMDocument	$document,
		Spreadsheet	$spreadsheet
	)

private

Loads PhpSpreadsheet from DOMDocument into PhpSpreadsheet instance.

Definition at line 684 of file Html.php.

                                                                                  : Spreadsheet
    {
        while ($spreadsheet->getSheetCount() <= $this->sheetIndex) {
            $spreadsheet->createSheet();
        }
        $spreadsheet->setActiveSheetIndex($this->sheetIndex);
 
        // Discard white space
        $document->preserveWhiteSpace = false;
 
        $row = 0;
        $column = 'A';
        $content = '';
        $this->rowspan = [];
        $this->processDomElement($document, $spreadsheet->getActiveSheet(), $row, $column, $content);
 
        // Return
        return $spreadsheet;
    }

References $row, PhpOffice\PhpSpreadsheet\Spreadsheet\createSheet(), PhpOffice\PhpSpreadsheet\Spreadsheet\getActiveSheet(), PhpOffice\PhpSpreadsheet\Spreadsheet\getSheetCount(), PhpOffice\PhpSpreadsheet\Reader\Html\processDomElement(), and PhpOffice\PhpSpreadsheet\Spreadsheet\setActiveSheetIndex().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\loadFromString(), and PhpOffice\PhpSpreadsheet\Reader\Html\loadIntoExisting().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ loadFromString()

PhpOffice\PhpSpreadsheet\Reader\Html::loadFromString	(		$content,
		?Spreadsheet	$spreadsheet = `null`
	)

Spreadsheet from content.

Parameters

string $content

Definition at line 664 of file Html.php.

                                                                              : Spreadsheet
    {
        //    Create a new DOM object
        $dom = new DOMDocument();
        //    Reload the HTML file into the DOM object
        try {
            $loaded = $dom->loadHTML(mb_convert_encoding($this->securityScanner->scan($content), 'HTML-ENTITIES', 'UTF-8'));
        } catch (Throwable $e) {
            $loaded = false;
        }
        if ($loaded === false) {
            throw new Exception('Failed to load content as a DOM Document', 0, $e ?? null);
        }
 
        return $this->loadDocument($dom, $spreadsheet ?? new Spreadsheet());
    }

References PhpOffice\PhpSpreadsheet\Reader\Html\loadDocument().

Here is the call graph for this function:

◆ loadIntoExisting()

PhpOffice\PhpSpreadsheet\Reader\Html::loadIntoExisting	(		$pFilename,
		Spreadsheet	$spreadsheet
	)

Loads PhpSpreadsheet from file into PhpSpreadsheet instance.

Parameters

string $pFilename

Returns: Spreadsheet

Definition at line 637 of file Html.php.

    {
        // Validate
        if (!$this->canRead($pFilename)) {
            throw new Exception($pFilename . ' is an Invalid HTML file.');
        }
 
        // Create a new DOM object
        $dom = new DOMDocument();
        // Reload the HTML file into the DOM object
        try {
            $loaded = $dom->loadHTML(mb_convert_encoding($this->securityScanner->scanFile($pFilename), 'HTML-ENTITIES', 'UTF-8'));
        } catch (Throwable $e) {
            $loaded = false;
        }
        if ($loaded === false) {
            throw new Exception('Failed to load ' . $pFilename . ' as a DOM Document', 0, $e ?? null);
        }
 
        return $this->loadDocument($dom, $spreadsheet);
    }

References PhpOffice\PhpSpreadsheet\Reader\Html\canRead(), and PhpOffice\PhpSpreadsheet\Reader\Html\loadDocument().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\load().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processDomElement()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElement	(	DOMNode	$element,
		Worksheet	$sheet,
		int &	$row,
		string &	$column,
		string &	$cellContent
	)

protected

Definition at line 613 of file Html.php.

                                                                                                                              : void
    {
        foreach ($element->childNodes as $child) {
            if ($child instanceof DOMText) {
                $domText = preg_replace('/\s+/u', ' ', trim($child->nodeValue));
                if (is_string($cellContent)) {
                    //    simply append the text if the cell content is a plain text string
                    $cellContent .= $domText;
                }
                //    but if we have a rich text run instead, we need to append it correctly
                //    TODO
            } elseif ($child instanceof DOMElement) {
                $this->processDomElementBody($sheet, $row, $column, $cellContent, $child);
            }
        }
    }

References $row, and PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementBody().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processDomElementA()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementA	(	Worksheet	$sheet,
		int &	$row,
		string &	$column,
		string &	$cellContent,
		DOMElement	$child,
		array &	$attributeArray
	)

private

Definition at line 381 of file Html.php.

                                                                                                                                                      : void
    {
        if ($child->nodeName === 'a') {
            foreach ($attributeArray as $attributeName => $attributeValue) {
                switch ($attributeName) {
                    case 'href':
                        $sheet->getCell($column . $row)->getHyperlink()->setUrl($attributeValue);
                        if (isset($this->formats[$child->nodeName])) {
                            $sheet->getStyle($column . $row)->applyFromArray($this->formats[$child->nodeName]);
                        }
 
                        break;
                    case 'class':
                        if ($attributeValue === 'comment-indicator') {
                            break; // Ignore - it's just a red square.
                        }
                }
            }
            // no idea why this should be needed
            //$cellContent .= ' ';
            $this->processDomElement($child, $sheet, $row, $column, $cellContent);
        } else {
            $this->processDomElementH1Etc($sheet, $row, $column, $cellContent, $child, $attributeArray);
        }
    }

References $row, PhpOffice\PhpSpreadsheet\Reader\Html\processDomElement(), and PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementH1Etc().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementBr().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processDomElementAlign()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementAlign	(	Worksheet	$sheet,
		int	$row,
		string	$column,
		array	$attributeArray
	)

private

Definition at line 541 of file Html.php.

                                                                                                              : void
    {
        if (isset($attributeArray['align'])) {
            $sheet->getStyle($column . $row)->getAlignment()->setHorizontal($attributeArray['align']);
        }
    }

References $row.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementThTd().

Here is the caller graph for this function:

◆ processDomElementBgcolor()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementBgcolor	(	Worksheet	$sheet,
		int	$row,
		string	$column,
		array	$attributeArray
	)

private

Definition at line 513 of file Html.php.

                                                                                                                : void
    {
        if (isset($attributeArray['bgcolor'])) {
            $sheet->getStyle("$column$row")->applyFromArray(
                [
                    'fill' => [
                        'fillType' => Fill::FILL_SOLID,
                        'color' => ['rgb' => $this->getStyleColor($attributeArray['bgcolor'])],
                    ],
                ]
            );
        }
    }

References PhpOffice\PhpSpreadsheet\Reader\Html\getStyleColor().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementThTd().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processDomElementBody()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementBody	(	Worksheet	$sheet,
		int &	$row,
		string &	$column,
		string &	$cellContent,
		DOMElement	$child
	)

private

Definition at line 301 of file Html.php.

                                                                                                                                 : void
    {
        $attributeArray = [];
        foreach ($child->attributes as $attribute) {
            $attributeArray[$attribute->name] = $attribute->value;
        }
 
        if ($child->nodeName === 'body') {
            $row = 1;
            $column = 'A';
            $cellContent = '';
            $this->tableLevel = 0;
            $this->processDomElement($child, $sheet, $row, $column, $cellContent);
        } else {
            $this->processDomElementTitle($sheet, $row, $column, $cellContent, $child, $attributeArray);
        }
    }

References $row, PhpOffice\PhpSpreadsheet\Reader\Html\processDomElement(), and PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementTitle().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElement().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processDomElementBr()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementBr	(	Worksheet	$sheet,
		int &	$row,
		string &	$column,
		string &	$cellContent,
		DOMElement	$child,
		array &	$attributeArray
	)

private

Definition at line 364 of file Html.php.

                                                                                                                                                       : void
    {
        if ($child->nodeName === 'br' || $child->nodeName === 'hr') {
            if ($this->tableLevel > 0) {
                //    If we're inside a table, replace with a \n and set the cell to wrap
                $cellContent .= "\n";
                $sheet->getStyle($column . $row)->getAlignment()->setWrapText(true);
            } else {
                //    Otherwise flush our existing content and move the row cursor on
                $this->flushCell($sheet, $column, $row, $cellContent);
                ++$row;
            }
        } else {
            $this->processDomElementA($sheet, $row, $column, $cellContent, $child, $attributeArray);
        }
    }

References $row, PhpOffice\PhpSpreadsheet\Reader\Html\flushCell(), and PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementA().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementHr().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processDomElementDataFormat()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementDataFormat	(	Worksheet	$sheet,
		int	$row,
		string	$column,
		array	$attributeArray
	)

private

Definition at line 555 of file Html.php.

                                                                                                                   : void
    {
        if (isset($attributeArray['data-format'])) {
            $sheet->getStyle($column . $row)->getNumberFormat()->setFormatCode($attributeArray['data-format']);
        }
    }

References $row.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementThTd().

Here is the caller graph for this function:

◆ processDomElementH1Etc()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementH1Etc	(	Worksheet	$sheet,
		int &	$row,
		string &	$column,
		string &	$cellContent,
		DOMElement	$child,
		array &	$attributeArray
	)

private

Definition at line 409 of file Html.php.

                                                                                                                                                          : void
    {
        if (in_array($child->nodeName, self::$h1Etc)) {
            if ($this->tableLevel > 0) {
                //    If we're inside a table, replace with a \n
                $cellContent .= $cellContent ? "\n" : '';
                $sheet->getStyle($column . $row)->getAlignment()->setWrapText(true);
                $this->processDomElement($child, $sheet, $row, $column, $cellContent);
            } else {
                if ($cellContent > '') {
                    $this->flushCell($sheet, $column, $row, $cellContent);
                    ++$row;
                }
                $this->processDomElement($child, $sheet, $row, $column, $cellContent);
                $this->flushCell($sheet, $column, $row, $cellContent);
 
                if (isset($this->formats[$child->nodeName])) {
                    $sheet->getStyle($column . $row)->applyFromArray($this->formats[$child->nodeName]);
                }
 
                ++$row;
                $column = 'A';
            }
        } else {
            $this->processDomElementLi($sheet, $row, $column, $cellContent, $child, $attributeArray);
        }
    }

References $row, PhpOffice\PhpSpreadsheet\Reader\Html\flushCell(), PhpOffice\PhpSpreadsheet\Reader\Html\processDomElement(), and PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementLi().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementA().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processDomElementHeight()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementHeight	(	Worksheet	$sheet,
		int	$row,
		array	$attributeArray
	)

private

Definition at line 534 of file Html.php.

                                                                                               : void
    {
        if (isset($attributeArray['height'])) {
            $sheet->getRowDimension($row)->setRowHeight($attributeArray['height']);
        }
    }

References $row.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementThTd().

Here is the caller graph for this function:

◆ processDomElementHr()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementHr	(	Worksheet	$sheet,
		int &	$row,
		string &	$column,
		string &	$cellContent,
		DOMElement	$child,
		array &	$attributeArray
	)

private

Definition at line 350 of file Html.php.

                                                                                                                                                       : void
    {
        if ($child->nodeName === 'hr') {
            $this->flushCell($sheet, $column, $row, $cellContent);
            ++$row;
            if (isset($this->formats[$child->nodeName])) {
                $sheet->getStyle($column . $row)->applyFromArray($this->formats[$child->nodeName]);
            }
            ++$row;
        }
        // fall through to br
        $this->processDomElementBr($sheet, $row, $column, $cellContent, $child, $attributeArray);
    }

References $row, PhpOffice\PhpSpreadsheet\Reader\Html\flushCell(), and PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementBr().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementSpanEtc().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processDomElementImg()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementImg	(	Worksheet	$sheet,
		int &	$row,
		string &	$column,
		string &	$cellContent,
		DOMElement	$child,
		array &	$attributeArray
	)

private

Definition at line 458 of file Html.php.

                                                                                                                                                        : void
    {
        if ($child->nodeName === 'img') {
            $this->insertImage($sheet, $column, $row, $attributeArray);
        } else {
            $this->processDomElementTable($sheet, $row, $column, $cellContent, $child, $attributeArray);
        }
    }

References $row, PhpOffice\PhpSpreadsheet\Reader\Html\insertImage(), and PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementTable().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementLi().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processDomElementLi()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementLi	(	Worksheet	$sheet,
		int &	$row,
		string &	$column,
		string &	$cellContent,
		DOMElement	$child,
		array &	$attributeArray
	)

private

Definition at line 437 of file Html.php.

                                                                                                                                                       : void
    {
        if ($child->nodeName === 'li') {
            if ($this->tableLevel > 0) {
                //    If we're inside a table, replace with a \n
                $cellContent .= $cellContent ? "\n" : '';
                $this->processDomElement($child, $sheet, $row, $column, $cellContent);
            } else {
                if ($cellContent > '') {
                    $this->flushCell($sheet, $column, $row, $cellContent);
                }
                ++$row;
                $this->processDomElement($child, $sheet, $row, $column, $cellContent);
                $this->flushCell($sheet, $column, $row, $cellContent);
                $column = 'A';
            }
        } else {
            $this->processDomElementImg($sheet, $row, $column, $cellContent, $child, $attributeArray);
        }
    }

References $row, PhpOffice\PhpSpreadsheet\Reader\Html\flushCell(), PhpOffice\PhpSpreadsheet\Reader\Html\processDomElement(), and PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementImg().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementH1Etc().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processDomElementSpanEtc()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementSpanEtc	(	Worksheet	$sheet,
		int &	$row,
		string &	$column,
		string &	$cellContent,
		DOMElement	$child,
		array &	$attributeArray
	)

private

Definition at line 332 of file Html.php.

                                                                                                                                                            : void
    {
        if (in_array($child->nodeName, self::$spanEtc)) {
            if (isset($attributeArray['class']) && $attributeArray['class'] === 'comment') {
                $sheet->getComment($column . $row)
                    ->getText()
                    ->createTextRun($child->textContent);
            }
            $this->processDomElement($child, $sheet, $row, $column, $cellContent);
 
            if (isset($this->formats[$child->nodeName])) {
                $sheet->getStyle($column . $row)->applyFromArray($this->formats[$child->nodeName]);
            }
        } else {
            $this->processDomElementHr($sheet, $row, $column, $cellContent, $child, $attributeArray);
        }
    }

References $row, PhpOffice\PhpSpreadsheet\Reader\Html\processDomElement(), and PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementHr().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementTitle().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processDomElementTable()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementTable	(	Worksheet	$sheet,
		int &	$row,
		string &	$column,
		string &	$cellContent,
		DOMElement	$child,
		array &	$attributeArray
	)

private

Definition at line 467 of file Html.php.

                                                                                                                                                          : void
    {
        if ($child->nodeName === 'table') {
            $this->flushCell($sheet, $column, $row, $cellContent);
            $column = $this->setTableStartColumn($column);
            if ($this->tableLevel > 1 && $row > 1) {
                --$row;
            }
            $this->processDomElement($child, $sheet, $row, $column, $cellContent);
            $column = $this->releaseTableStartColumn();
            if ($this->tableLevel > 1) {
                ++$column;
            } else {
                ++$row;
            }
        } else {
            $this->processDomElementTr($sheet, $row, $column, $cellContent, $child, $attributeArray);
        }
    }

References $row, PhpOffice\PhpSpreadsheet\Reader\Html\flushCell(), PhpOffice\PhpSpreadsheet\Reader\Html\processDomElement(), PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementTr(), PhpOffice\PhpSpreadsheet\Reader\Html\releaseTableStartColumn(), and PhpOffice\PhpSpreadsheet\Reader\Html\setTableStartColumn().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementImg().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processDomElementThTd()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementThTd	(	Worksheet	$sheet,
		int &	$row,
		string &	$column,
		string &	$cellContent,
		DOMElement	$child,
		array &	$attributeArray
	)

private

Definition at line 562 of file Html.php.

                                                                                                                                                         : void
    {
        while (isset($this->rowspan[$column . $row])) {
            ++$column;
        }
        $this->processDomElement($child, $sheet, $row, $column, $cellContent);
 
        // apply inline style
        $this->applyInlineStyle($sheet, $row, $column, $attributeArray);
 
        $this->flushCell($sheet, $column, $row, $cellContent);
 
        $this->processDomElementBgcolor($sheet, $row, $column, $attributeArray);
        $this->processDomElementWidth($sheet, $column, $attributeArray);
        $this->processDomElementHeight($sheet, $row, $attributeArray);
        $this->processDomElementAlign($sheet, $row, $column, $attributeArray);
        $this->processDomElementVAlign($sheet, $row, $column, $attributeArray);
        $this->processDomElementDataFormat($sheet, $row, $column, $attributeArray);
 
        if (isset($attributeArray['rowspan'], $attributeArray['colspan'])) {
            //create merging rowspan and colspan
            $columnTo = $column;
            for ($i = 0; $i < (int) $attributeArray['colspan'] - 1; ++$i) {
                ++$columnTo;
            }
            $range = $column . $row . ':' . $columnTo . ($row + (int) $attributeArray['rowspan'] - 1);
            foreach (Coordinate::extractAllCellReferencesInRange($range) as $value) {
                $this->rowspan[$value] = true;
            }
            $sheet->mergeCells($range);
            $column = $columnTo;
        } elseif (isset($attributeArray['rowspan'])) {
            //create merging rowspan
            $range = $column . $row . ':' . $column . ($row + (int) $attributeArray['rowspan'] - 1);
            foreach (Coordinate::extractAllCellReferencesInRange($range) as $value) {
                $this->rowspan[$value] = true;
            }
            $sheet->mergeCells($range);
        } elseif (isset($attributeArray['colspan'])) {
            //create merging colspan
            $columnTo = $column;
            for ($i = 0; $i < (int) $attributeArray['colspan'] - 1; ++$i) {
                ++$columnTo;
            }
            $sheet->mergeCells($column . $row . ':' . $columnTo . $row);
            $column = $columnTo;
        }
 
        ++$column;
    }

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementThTdOther().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processDomElementThTdOther()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementThTdOther	(	Worksheet	$sheet,
		int &	$row,
		string &	$column,
		string &	$cellContent,
		DOMElement	$child,
		array &	$attributeArray
	)

private

Definition at line 504 of file Html.php.

                                                                                                                                                              : void
    {
        if ($child->nodeName !== 'td' && $child->nodeName !== 'th') {
            $this->processDomElement($child, $sheet, $row, $column, $cellContent);
        } else {
            $this->processDomElementThTd($sheet, $row, $column, $cellContent, $child, $attributeArray);
        }
    }

References $row, PhpOffice\PhpSpreadsheet\Reader\Html\processDomElement(), and PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementThTd().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementTr().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processDomElementTitle()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementTitle	(	Worksheet	$sheet,
		int &	$row,
		string &	$column,
		string &	$cellContent,
		DOMElement	$child,
		array &	$attributeArray
	)

private

Definition at line 319 of file Html.php.

                                                                                                                                                          : void
    {
        if ($child->nodeName === 'title') {
            $this->processDomElement($child, $sheet, $row, $column, $cellContent);
            $sheet->setTitle($cellContent, true, true);
            $cellContent = '';
        } else {
            $this->processDomElementSpanEtc($sheet, $row, $column, $cellContent, $child, $attributeArray);
        }
    }

References $row, PhpOffice\PhpSpreadsheet\Reader\Html\processDomElement(), and PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementSpanEtc().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementBody().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processDomElementTr()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementTr	(	Worksheet	$sheet,
		int &	$row,
		string &	$column,
		string &	$cellContent,
		DOMElement	$child,
		array &	$attributeArray
	)

private

Definition at line 487 of file Html.php.

                                                                                                                                                       : void
    {
        if ($child->nodeName === 'tr') {
            $column = $this->getTableStartColumn();
            $cellContent = '';
            $this->processDomElement($child, $sheet, $row, $column, $cellContent);
 
            if (isset($attributeArray['height'])) {
                $sheet->getRowDimension($row)->setRowHeight($attributeArray['height']);
            }
 
            ++$row;
        } else {
            $this->processDomElementThTdOther($sheet, $row, $column, $cellContent, $child, $attributeArray);
        }
    }

References $row, PhpOffice\PhpSpreadsheet\Reader\Html\getTableStartColumn(), PhpOffice\PhpSpreadsheet\Reader\Html\processDomElement(), and PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementThTdOther().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementTable().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ processDomElementVAlign()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementVAlign	(	Worksheet	$sheet,
		int	$row,
		string	$column,
		array	$attributeArray
	)

private

Definition at line 548 of file Html.php.

                                                                                                               : void
    {
        if (isset($attributeArray['valign'])) {
            $sheet->getStyle($column . $row)->getAlignment()->setVertical($attributeArray['valign']);
        }
    }

References $row.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementThTd().

Here is the caller graph for this function:

◆ processDomElementWidth()

PhpOffice\PhpSpreadsheet\Reader\Html::processDomElementWidth	(	Worksheet	$sheet,
		string	$column,
		array	$attributeArray
	)

private

Definition at line 527 of file Html.php.

                                                                                                    : void
    {
        if (isset($attributeArray['width'])) {
            $sheet->getColumnDimension($column)->setWidth($attributeArray['width']);
        }
    }

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementThTd().

Here is the caller graph for this function:

◆ readBeginning()

PhpOffice\PhpSpreadsheet\Reader\Html::readBeginning ( )

private

Definition at line 162 of file Html.php.

    {
        fseek($this->fileHandle, 0);
 
        return fread($this->fileHandle, self::TEST_SAMPLE_SIZE);
    }

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\canRead().

Here is the caller graph for this function:

◆ readEnding()

PhpOffice\PhpSpreadsheet\Reader\Html::readEnding ( )

private

Definition at line 169 of file Html.php.

    {
        $meta = stream_get_meta_data($this->fileHandle);
        $filename = $meta['uri'];
 
        $size = filesize($filename);
        if ($size === 0) {
            return '';
        }
 
        $blockSize = self::TEST_SAMPLE_SIZE;
        if ($size < $blockSize) {
            $blockSize = $size;
        }
 
        fseek($this->fileHandle, $size - $blockSize);
 
        return fread($this->fileHandle, $blockSize);
    }

References $filename, $size, and PhpOffice\PhpSpreadsheet\Reader\Html\TEST_SAMPLE_SIZE.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\canRead().

Here is the caller graph for this function:

◆ releaseTableStartColumn()

PhpOffice\PhpSpreadsheet\Reader\Html::releaseTableStartColumn ( )

protected

Definition at line 275 of file Html.php.

    {
        --$this->tableLevel;
 
        return array_pop($this->nestedColumn);
    }

References PhpOffice\PhpSpreadsheet\Reader\Html\$tableLevel.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementTable().

Here is the caller graph for this function:

◆ setBorderStyle()

PhpOffice\PhpSpreadsheet\Reader\Html::setBorderStyle	(	Style	$cellStyle,
			$styleValue,
			$type
	)

private

Parameters

string	$styleValue
string	$type

Definition at line 1006 of file Html.php.

                                                                         : void
    {
        if (trim($styleValue) === Border::BORDER_NONE) {
            $borderStyle = Border::BORDER_NONE;
            $color = null;
        } else {
            $borderArray = explode(' ', $styleValue);
            $borderCount = count($borderArray);
            if ($borderCount >= 3) {
                $borderStyle = $borderArray[1];
                $color = $borderArray[2];
            } else {
                $borderStyle = $borderArray[0];
                $color = $borderArray[1] ?? null;
            }
        }
 
        $cellStyle->applyFromArray([
            'borders' => [
                $type => [
                    'borderStyle' => $this->getBorderStyle($borderStyle),
                    'color' => ['rgb' => $this->getStyleColor($color)],
                ],
            ],
        ]);
    }

References $type, PhpOffice\PhpSpreadsheet\Reader\Html\getBorderStyle(), and PhpOffice\PhpSpreadsheet\Reader\Html\getStyleColor().

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\applyInlineStyle().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ setInputEncoding()

PhpOffice\PhpSpreadsheet\Reader\Html::setInputEncoding ( $pValue )

Set input encoding.

Parameters

string $pValue Input encoding, eg: 'ANSI'

Returns: $this

@codeCoverageIgnore

Deprecated:: no use is made of this property

Definition at line 231 of file Html.php.

    {
        $this->inputEncoding = $pValue;
 
        return $this;
    }

◆ setSheetIndex()

PhpOffice\PhpSpreadsheet\Reader\Html::setSheetIndex ( $pValue )

Set sheet index.

Parameters

int $pValue Sheet index

Returns: $this

Definition at line 721 of file Html.php.

    {
        $this->sheetIndex = $pValue;
 
        return $this;
    }

◆ setTableStartColumn()

PhpOffice\PhpSpreadsheet\Reader\Html::setTableStartColumn ( $column )

protected

Definition at line 259 of file Html.php.

    {
        if ($this->tableLevel == 0) {
            $column = 'A';
        }
        ++$this->tableLevel;
        $this->nestedColumn[$this->tableLevel] = $column;
 
        return $this->nestedColumn[$this->tableLevel];
    }

References PhpOffice\PhpSpreadsheet\Reader\Html\$tableLevel.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\processDomElementTable().

Here is the caller graph for this function:

◆ startsWithTag()

static PhpOffice\PhpSpreadsheet\Reader\Html::startsWithTag ( $data )

staticprivate

Definition at line 189 of file Html.php.

    {
        return '<' === substr(trim($data), 0, 1);
    }

References $data.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\canRead().

Here is the caller graph for this function:

Field Documentation

◆ $borderMappings

PhpOffice\PhpSpreadsheet\Reader\Html::$borderMappings

staticprivate

Initial value:

= [
        'dash-dot' => Border::BORDER_DASHDOT,
        'dash-dot-dot' => Border::BORDER_DASHDOTDOT,
        'dashed' => Border::BORDER_DASHED,
        'dotted' => Border::BORDER_DOTTED,
        'double' => Border::BORDER_DOUBLE,
        'hair' => Border::BORDER_HAIR,
        'medium' => Border::BORDER_MEDIUM,
        'medium-dashed' => Border::BORDER_MEDIUMDASHED,
        'medium-dash-dot' => Border::BORDER_MEDIUMDASHDOT,
        'medium-dash-dot-dot' => Border::BORDER_MEDIUMDASHDOTDOT,
        'none' => Border::BORDER_NONE,
        'slant-dash-dot' => Border::BORDER_SLANTDASHDOT,
        'solid' => Border::BORDER_THIN,
        'thick' => Border::BORDER_THICK,
    ]

Definition at line 968 of file Html.php.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\getBorderMappings().

◆ $dataArray

PhpOffice\PhpSpreadsheet\Reader\Html::$dataArray = []

protected

Definition at line 253 of file Html.php.

◆ $formats

PhpOffice\PhpSpreadsheet\Reader\Html::$formats

protected

Definition at line 48 of file Html.php.

◆ $h1Etc

PhpOffice\PhpSpreadsheet\Reader\Html::$h1Etc = ['h1', 'h2', 'h3', 'h4', 'h5', 'h6', 'ol', 'ul', 'p']

staticprivate

Definition at line 407 of file Html.php.

◆ $inputEncoding

PhpOffice\PhpSpreadsheet\Reader\Html::$inputEncoding = 'ANSI'

protected

Definition at line 34 of file Html.php.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\getInputEncoding().

◆ $nestedColumn

PhpOffice\PhpSpreadsheet\Reader\Html::$nestedColumn = ['A']

protected

Definition at line 257 of file Html.php.

◆ $rowspan

PhpOffice\PhpSpreadsheet\Reader\Html::$rowspan = []

protected

Definition at line 125 of file Html.php.

◆ $sheetIndex

PhpOffice\PhpSpreadsheet\Reader\Html::$sheetIndex = 0

protected

Definition at line 41 of file Html.php.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\getSheetIndex().

◆ $spanEtc

PhpOffice\PhpSpreadsheet\Reader\Html::$spanEtc = ['span', 'div', 'font', 'i', 'em', 'strong', 'b']

staticprivate

Definition at line 330 of file Html.php.

◆ $tableLevel

PhpOffice\PhpSpreadsheet\Reader\Html::$tableLevel = 0

protected

Definition at line 255 of file Html.php.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\getTableStartColumn(), PhpOffice\PhpSpreadsheet\Reader\Html\releaseTableStartColumn(), and PhpOffice\PhpSpreadsheet\Reader\Html\setTableStartColumn().

◆ TEST_SAMPLE_SIZE

const PhpOffice\PhpSpreadsheet\Reader\Html::TEST_SAMPLE_SIZE = 2048

Sample size to read to determine if it's HTML or not.

Definition at line 27 of file Html.php.

Referenced by PhpOffice\PhpSpreadsheet\Reader\Html\readEnding().

The documentation for this class was generated from the following file:

libs/composer/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Html.php

Public Member Functions

Static Public Member Functions

Data Fields

Protected Member Functions

Protected Attributes

Private Member Functions

Static Private Member Functions

Static Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ applyInlineStyle()

◆ canRead()

◆ containsTags()

◆ endsWithTag()

◆ flushCell()

◆ getBorderMappings()

◆ getBorderStyle()

◆ getInputEncoding()

◆ getSheetIndex()

◆ getStyleColor()

◆ getTableStartColumn()

◆ insertImage()

◆ load()

◆ loadDocument()

◆ loadFromString()

◆ loadIntoExisting()

◆ processDomElement()

◆ processDomElementA()

◆ processDomElementAlign()

◆ processDomElementBgcolor()

◆ processDomElementBody()

◆ processDomElementBr()

◆ processDomElementDataFormat()

◆ processDomElementH1Etc()

◆ processDomElementHeight()

◆ processDomElementHr()

◆ processDomElementImg()

◆ processDomElementLi()

◆ processDomElementSpanEtc()

◆ processDomElementTable()

◆ processDomElementThTd()

◆ processDomElementThTdOther()

◆ processDomElementTitle()

◆ processDomElementTr()

◆ processDomElementVAlign()

◆ processDomElementWidth()

◆ readBeginning()

◆ readEnding()

◆ releaseTableStartColumn()

◆ setBorderStyle()

◆ setInputEncoding()

◆ setSheetIndex()

◆ setTableStartColumn()

◆ startsWithTag()

Field Documentation

◆ $borderMappings

◆ $dataArray

◆ $formats

◆ $h1Etc

◆ $inputEncoding

◆ $nestedColumn

◆ $rowspan

◆ $sheetIndex

◆ $spanEtc

◆ $tableLevel

◆ TEST_SAMPLE_SIZE