Documentation

Html extends BaseWriter
in package

Application

Constants

BODY_LINE = ' <body>' . PHP_EOL
BORDER_ARR = [\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_NONE => self::BORDER_NONE, \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DASHDOT => '1px dashed', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DASHDOTDOT => '1px dotted', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DASHED => '1px dashed', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DOTTED => '1px dotted', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DOUBLE => '3px double', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_HAIR => '1px solid', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_MEDIUM => '2px solid', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_MEDIUMDASHDOT => '2px dashed', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_MEDIUMDASHDOTDOT => '2px dotted', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_SLANTDASHDOT => '2px dashed', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THICK => '3px solid']
BORDER_NONE = 'none'
COMMENT_HTML_TAGS_PLAINTEXT = true: Migration aid to tell if html tags will be treated as plaintext in comments.
CUSTOM_TO_META = [\PhpOffice\PhpSpreadsheet\Document\Properties::PROPERTY_TYPE_BOOLEAN => 'bool', \PhpOffice\PhpSpreadsheet\Document\Properties::PROPERTY_TYPE_DATE => 'date', \PhpOffice\PhpSpreadsheet\Document\Properties::PROPERTY_TYPE_FLOAT => 'float', \PhpOffice\PhpSpreadsheet\Document\Properties::PROPERTY_TYPE_INTEGER => 'int', \PhpOffice\PhpSpreadsheet\Document\Properties::PROPERTY_TYPE_STRING => 'string']
DEFAULT_CELL_WIDTH_PIXELS = 56
DEFAULT_CELL_WIDTH_POINTS = 42

Properties

$conditionalFormatting : bool: Conditional Formatting Enables conditional formatting in writer, disabled here, must be enabled in writer via a setter.
$embedImages : bool: embed images, or link to images.
$fileHandle : resource
$includeCharts : bool: Write charts that are defined in the workbook? Identifies whether the Writer should write definitions for any charts that exist in the PhpSpreadsheet object.
$isPdf : bool: Is the current writer creating PDF?
$ltrSheets : bool
$preCalculateFormulas : bool: Pre-calculate formulas Forces PhpSpreadsheet to recalculate all formulae in a workbook when saving, so that the pre-calculated values are immediately available to MS Excel or other office spreadsheet viewer when opening the file.
$rtlSheets : bool
$spreadsheet : Spreadsheet: Spreadsheet object.
$tableFormats : bool: Table formats Enables table formats in writer, disabled here, must be enabled in writer via a setter.
$betterBoolean : bool
$columnWidths : array<string|int, array<string|int, float|int>>: Array of column widths in points.
$cssStyles : array<string|int, array<string|int, string>>: Array of CSS styles.
$defaultFont : Font: Default font.
$diskCachingDirectory : string: Disk caching directory.
$editHtmlCallback : null|callable(string): string: Callback for editing generated html.
$generateSheetNavigationBlock : bool: Generate the Navigation block.
$getFalse : string
$getTrue : string
$imagesRoot : string: Images root.
$isBaseCell : array<string|int, array<string|int, array<string|int, array<string|int, int>>>>: Excel cells that are upper-left corner in a cell merge.
$isSpannedCell : array<string|int, array<string|int, array<string|int, array<string|int, mixed>>>>: Excel cells that should not be written as HTML cells.
$isSpannedRow : array<string|int, array<string|int, mixed>>: Excel rows that should not be written as HTML rows.
$sheetCharts : array<string|int, Chart>
$sheetDrawings : array<string|int, BaseDrawing>
$sheetIndex : int|null: Sheet index to write.
$shouldCloseFile : bool
$spansAreCalculated : bool: Flag whether spans have been calculated.
$useDiskCaching : bool: Use disk caching where possible?
$useInlineCss : bool: Use inline CSS?

Methods

__construct() : mixed: Create a new HTML.
buildCSS() : array<string|int, array<string|int, string>>: Build CSS styles.
formatColor() : string: Add color to formatted string as inline style.
formatColorStatic() : string: Add color to formatted string as inline style.
generateHtmlAll() : string: Save Spreadsheet as html to variable.
generateHTMLFooter() : string: Generate HTML footer.
generateHTMLHeader() : string: Generate HTML header.
generateNavigation() : string: Generate sheet tabs.
generateSheetData() : string: Generate sheet data.
generateStyles() : string: Generate CSS styles.
getBetterBoolean() : bool
getConditionalFormatting() : bool
getDiskCachingDirectory() : string: Get disk caching directory.
getEmbedImages() : bool: Get embed images.
getGenerateSheetNavigationBlock() : bool: Get sheet index.
getImagesRoot() : string: Get images root.
getIncludeCharts() : bool: Write charts in workbook? If this is true, then the Writer will write definitions for any charts that exist in the PhpSpreadsheet object.
getOrientation() : string|null
getPreCalculateFormulas() : bool: Get Pre-Calculate Formulas flag If this is true (the default), then the writer will recalculate all formulae in a workbook when saving, so that the pre-calculated values are immediately available to MS Excel or other office spreadsheet viewer when opening the file If false, then formulae are not calculated on save. This is faster for saving in PhpSpreadsheet, but slower when opening the resulting file in MS Excel, because Excel has to recalculate the formulae itself.
getSheetIndex() : int|null: Get sheet index.
getTableFormats() : bool
getUseDiskCaching() : bool: Get use disk caching where possible?
getUseInlineCss() : bool: Get use inline CSS?
openFileHandle() : void: Open file handle.
save() : void: Save Spreadsheet to file.
setBetterBoolean() : self
setConditionalFormatting() : self
setEditHtmlCallback() : void: Set a callback to edit the entire HTML.
setEmbedImages() : $this: Set embed images.
setGenerateSheetNavigationBlock() : $this: Set sheet index.
setImagesRoot() : $this: Set images root.
setIncludeCharts() : $this: Set write charts in workbook Set to true, to advise the Writer to include any charts that exist in the PhpSpreadsheet object.
setPreCalculateFormulas() : $this: Set Pre-Calculate Formulas Set to true (the default) to advise the Writer to calculate all formulae on save Set to false to prevent precalculation of formulae on save.
setSheetIndex() : $this: Set sheet index.
setTableFormats() : self
setUseDiskCaching() : $this: Set use disk caching where possible?
setUseInlineCss() : $this: Set use inline CSS?
winFileToUrl() : string: Convert Windows file name to file protocol URL.
writeAllSheets() : $this: Write all sheets (resets sheetIndex to NULL).
checkRtlAndLtr() : void
maybeCloseFileHandle() : void: Close file handle only if we opened it ourselves.
processFlags() : void
adjustRendererPositions() : void
assembleCSS() : string: Takes array where of CSS properties / values and converts to CSS string.
buildCssPerSheet() : void
buildCssRowHeights() : void
calculateSpans() : void: Calculate information about HTML colspan and rowspan which is not always the same as Excel's.
calculateSpansOmitRows() : void
createCSSStyle() : array<string|int, string>: Create CSS style.
createCSSStyleAlignment() : array<string|int, string>: Create CSS style.
createCSSStyleBorder() : string: Create CSS style.
createCSSStyleBorders() : array<string|int, string>: Create CSS style.
createCSSStyleFill() : array<string|int, string>: Create CSS style (Fill).
createCSSStyleFont() : array<string|int, string>: Create CSS style.
extendRowsAndColumns() : void
generateMeta() : string
generatePageDeclarations() : string: Generate @page declarations.
generateRow() : string: Generate row.
generateRowCellCss() : Cell, : array{}|string, : non-empty-string}
generateRowCellData() : string
generateRowCellDataValue() : void
generateRowCellDataValueRich() : string
generateRowIncludeCharts() : string
generateRowSpans() : string
generateRowStart() : string: Generate row start.
generateRowWriteCell() : void
generateSheetPrep() : array<string|int, Worksheet>
generateSheetStarts() : array{: int, : int, : int}
generateSheetTags() : array{: string, : string, : string}
generateTableFooter() : string: Generate table footer.
generateTableHeader() : string: Generate table header.
generateTableTag() : void
generateTableTagInline() : string
getDir() : string
getFloat() : string
mapBorderStyle() : string: Map border style.
mapHAlign() : string: Map HAlign.
mapVAlign() : string: Map VAlign.
replaceControlChars() : string
replaceNonAscii() : string
shouldGenerateColumn() : bool
shouldGenerateRow() : bool
styleBorder() : void
writeChartInCell() : string: Generate chart tag in cell.
writeComment() : string: Write a comment in the same format as LibreOffice.
writeImageInCell() : string: Generate image tag in cell.

BODY_LINE


    public
        mixed
    BODY_LINE
    = '  <body>' . PHP_EOL

BORDER_ARR


    public
        mixed
    BORDER_ARR
    = [\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_NONE => self::BORDER_NONE, \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DASHDOT => '1px dashed', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DASHDOTDOT => '1px dotted', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DASHED => '1px dashed', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DOTTED => '1px dotted', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DOUBLE => '3px double', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_HAIR => '1px solid', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_MEDIUM => '2px solid', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_MEDIUMDASHDOT => '2px dashed', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_MEDIUMDASHDOTDOT => '2px dotted', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_SLANTDASHDOT => '2px dashed', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THICK => '3px solid']

BORDER_NONE


    public
        mixed
    BORDER_NONE
    = 'none'

COMMENT_HTML_TAGS_PLAINTEXT

Migration aid to tell if html tags will be treated as plaintext in comments.


    public
        mixed
    COMMENT_HTML_TAGS_PLAINTEXT
    = true

if ( defined( \PhpOffice\PhpSpreadsheet\Writer\Html::class . '::COMMENT_HTML_TAGS_PLAINTEXT' ) ) { new logic with styling in TextRun elements } else { old logic with styling via Html tags }.

CUSTOM_TO_META


    private
        mixed
    CUSTOM_TO_META
    = [\PhpOffice\PhpSpreadsheet\Document\Properties::PROPERTY_TYPE_BOOLEAN => 'bool', \PhpOffice\PhpSpreadsheet\Document\Properties::PROPERTY_TYPE_DATE => 'date', \PhpOffice\PhpSpreadsheet\Document\Properties::PROPERTY_TYPE_FLOAT => 'float', \PhpOffice\PhpSpreadsheet\Document\Properties::PROPERTY_TYPE_INTEGER => 'int', \PhpOffice\PhpSpreadsheet\Document\Properties::PROPERTY_TYPE_STRING => 'string']

DEFAULT_CELL_WIDTH_PIXELS


    private
        mixed
    DEFAULT_CELL_WIDTH_PIXELS
    = 56

DEFAULT_CELL_WIDTH_POINTS


    private
        mixed
    DEFAULT_CELL_WIDTH_POINTS
    = 42

$conditionalFormatting

Conditional Formatting Enables conditional formatting in writer, disabled here, must be enabled in writer via a setter.


    protected
        bool
    $conditionalFormatting
     = false

$embedImages

embed images, or link to images.


    protected
        bool
    $embedImages
     = false

$fileHandle


    protected
        resource
    $fileHandle

$includeCharts

Write charts that are defined in the workbook? Identifies whether the Writer should write definitions for any charts that exist in the PhpSpreadsheet object.


    protected
        bool
    $includeCharts
     = false

$isPdf

Is the current writer creating PDF?


    protected
        bool
    $isPdf
     = false

$ltrSheets


    protected
        bool
    $ltrSheets
     = false

$preCalculateFormulas

Pre-calculate formulas Forces PhpSpreadsheet to recalculate all formulae in a workbook when saving, so that the pre-calculated values are immediately available to MS Excel or other office spreadsheet viewer when opening the file.


    protected
        bool
    $preCalculateFormulas
     = true

$rtlSheets


    protected
        bool
    $rtlSheets
     = false

$spreadsheet

Spreadsheet object.


    protected
        Spreadsheet
    $spreadsheet

$tableFormats

Table formats Enables table formats in writer, disabled here, must be enabled in writer via a setter.


    protected
        bool
    $tableFormats
     = false

$betterBoolean


    private
        bool
    $betterBoolean
     = true

$columnWidths

Array of column widths in points.


    private
        array<string|int, array<string|int, float|int>>
    $columnWidths

$cssStyles

Array of CSS styles.


    private
        array<string|int, array<string|int, string>>
    $cssStyles
     = null

$defaultFont

Default font.


    private
        Font
    $defaultFont

$diskCachingDirectory

Disk caching directory.


    private
        string
    $diskCachingDirectory
     = './'

$editHtmlCallback

Callback for editing generated html.


    private
        null|callable(string): string
    $editHtmlCallback

$generateSheetNavigationBlock

Generate the Navigation block.


    private
        bool
    $generateSheetNavigationBlock
     = true

$getFalse


    private
        string
    $getFalse
     = 'FALSE'

$getTrue


    private
        string
    $getTrue
     = 'TRUE'

$imagesRoot

Images root.


    private
        string
    $imagesRoot
     = ''

$isBaseCell

Excel cells that are upper-left corner in a cell merge.


    private
        array<string|int, array<string|int, array<string|int, array<string|int, int>>>>
    $isBaseCell
     = []

$isSpannedCell

Excel cells that should not be written as HTML cells.


    private
        array<string|int, array<string|int, array<string|int, array<string|int, mixed>>>>
    $isSpannedCell
     = []

$isSpannedRow

Excel rows that should not be written as HTML rows.


    private
        array<string|int, array<string|int, mixed>>
    $isSpannedRow
     = []

$sheetCharts


    private
        array<string|int, Chart>
    $sheetCharts

$sheetDrawings


    private
        array<string|int, BaseDrawing>
    $sheetDrawings

$sheetIndex

Sheet index to write.


    private
        int|null
    $sheetIndex
     = 0

$shouldCloseFile


    private
        bool
    $shouldCloseFile

$spansAreCalculated

Flag whether spans have been calculated.


    private
        bool
    $spansAreCalculated
     = false

$useDiskCaching

Use disk caching where possible?


    private
        bool
    $useDiskCaching
     = false

$useInlineCss

Use inline CSS?


    private
        bool
    $useInlineCss
     = false

__construct()

Create a new HTML.


    public
                    __construct(Spreadsheet $spreadsheet) : mixed

Parameters

$spreadsheet : Spreadsheet: The spreadsheet that we want to save using this Writer

buildCSS()

Build CSS styles.


    public
                    buildCSS([bool $generateSurroundingHTML = true ]) : array<string|int, array<string|int, string>>

Parameters

$generateSurroundingHTML : bool = true: Generate surrounding HTML style? (html { })

Return values

array<string|int, array<string|int, string>>

formatColor()

Add color to formatted string as inline style.


    public
                    formatColor(string $value, string $format) : string

Parameters

$value : string: Plain formatted value without color
$format : string: Format code

Return values

string

formatColorStatic()

Add color to formatted string as inline style.


    public
            static        formatColorStatic(string $value, string $format) : string

Parameters

$value : string: Plain formatted value without color
$format : string: Format code

Return values

string

generateHtmlAll()

Save Spreadsheet as html to variable.


    public
                    generateHtmlAll() : string

Return values

string

generateHTMLFooter()

Generate HTML footer.


    public
                    generateHTMLFooter() : string

Return values

string

generateHTMLHeader()

Generate HTML header.


    public
                    generateHTMLHeader([bool $includeStyles = false ]) : string

Parameters

$includeStyles : bool = false: Include styles?

Return values

string

generateNavigation()

Generate sheet tabs.


    public
                    generateNavigation() : string

Return values

string

generateSheetData()

Generate sheet data.


    public
                    generateSheetData() : string

Return values

string

generateStyles()

Generate CSS styles.


    public
                    generateStyles([bool $generateSurroundingHTML = true ]) : string

Parameters

$generateSurroundingHTML : bool = true: Generate surrounding HTML tags? (<style> and </style>)

Return values

string

getBetterBoolean()


    public
                    getBetterBoolean() : bool

Return values

bool

getConditionalFormatting()


    public
                    getConditionalFormatting() : bool

Return values

bool

getDiskCachingDirectory()

Get disk caching directory.


    public
                    getDiskCachingDirectory() : string

Return values

string

getEmbedImages()

Get embed images.


    public
                    getEmbedImages() : bool

Return values

bool

getGenerateSheetNavigationBlock()

Get sheet index.


    public
                    getGenerateSheetNavigationBlock() : bool

Return values

bool

getImagesRoot()

Get images root.


    public
                    getImagesRoot() : string

Return values

string

getIncludeCharts()

Write charts in workbook? If this is true, then the Writer will write definitions for any charts that exist in the PhpSpreadsheet object.


    public
                    getIncludeCharts() : bool

If false (the default) it will ignore any charts defined in the PhpSpreadsheet object.

Return values

bool

getOrientation()


    public
                    getOrientation() : string|null

Return values

string|null

getPreCalculateFormulas()

Get Pre-Calculate Formulas flag If this is true (the default), then the writer will recalculate all formulae in a workbook when saving, so that the pre-calculated values are immediately available to MS Excel or other office spreadsheet viewer when opening the file If false, then formulae are not calculated on save. This is faster for saving in PhpSpreadsheet, but slower when opening the resulting file in MS Excel, because Excel has to recalculate the formulae itself.


    public
                    getPreCalculateFormulas() : bool

Return values

bool

getSheetIndex()

Get sheet index.


    public
                    getSheetIndex() : int|null

Return values

int|null

getTableFormats()


    public
                    getTableFormats() : bool

Return values

bool

getUseDiskCaching()

Get use disk caching where possible?


    public
                    getUseDiskCaching() : bool

Return values

bool

getUseInlineCss()

Get use inline CSS?


    public
                    getUseInlineCss() : bool

Return values

bool

openFileHandle()

Open file handle.


    public
                    openFileHandle(resource|string $filename) : void

Parameters

$filename : resource|string

save()

Save Spreadsheet to file.


    public
                    save(resource|string $filename[, int $flags = 0 ]) : void

Parameters

$filename : resource|string
$flags : int = 0: Flags that can change the behaviour of the Writer: self::SAVE_WITH_CHARTS Save any charts that are defined (if the Writer supports Charts) self::DISABLE_PRECALCULATE_FORMULAE Don't Precalculate formulae before saving the file

setBetterBoolean()


    public
                    setBetterBoolean(bool $betterBoolean) : self

Parameters

$betterBoolean : bool

Return values

self

setConditionalFormatting()


    public
                    setConditionalFormatting(bool $conditionalFormatting) : self

Parameters

$conditionalFormatting : bool

Return values

self

setEditHtmlCallback()

Set a callback to edit the entire HTML.


    public
                    setEditHtmlCallback(callable|null $callback) : void

The callback must accept the HTML as string as first parameter, and it must return the edited HTML as string.

Parameters

$callback : callable|null

setEmbedImages()

Set embed images.


    public
                    setEmbedImages(bool $embedImages) : $this

Parameters

$embedImages : bool

Return values

$this

setGenerateSheetNavigationBlock()

Set sheet index.


    public
                    setGenerateSheetNavigationBlock(bool $generateSheetNavigationBlock) : $this

Parameters

$generateSheetNavigationBlock : bool: Flag indicating whether the sheet navigation block should be generated or not

Return values

$this

setImagesRoot()

Set images root.


    public
                    setImagesRoot(string $imagesRoot) : $this

Parameters

$imagesRoot : string

Return values

$this

setIncludeCharts()

Set write charts in workbook Set to true, to advise the Writer to include any charts that exist in the PhpSpreadsheet object.


    public
                    setIncludeCharts(bool $includeCharts) : $this

Set to false (the default) to ignore charts.

Parameters

$includeCharts : bool

Return values

$this

setPreCalculateFormulas()

Set Pre-Calculate Formulas Set to true (the default) to advise the Writer to calculate all formulae on save Set to false to prevent precalculation of formulae on save.


    public
                    setPreCalculateFormulas(bool $precalculateFormulas) : $this

Parameters

$precalculateFormulas : bool: Pre-Calculate Formulas?

Return values

$this

setSheetIndex()

Set sheet index.


    public
                    setSheetIndex(int $sheetIndex) : $this

Parameters

$sheetIndex : int: Sheet index

Return values

$this

setTableFormats()


    public
                    setTableFormats(bool $tableFormats) : self

Parameters

$tableFormats : bool

Return values

self

setUseDiskCaching()

Set use disk caching where possible?


    public
                    setUseDiskCaching(bool $useDiskCache[, string|null $cacheDirectory = null ]) : $this

Parameters

$useDiskCache : bool
$cacheDirectory : string|null = null: Disk caching directory

Return values

$this

setUseInlineCss()

Set use inline CSS?


    public
                    setUseInlineCss(bool $useInlineCss) : $this

Parameters

$useInlineCss : bool

Return values

$this

winFileToUrl()

Convert Windows file name to file protocol URL.


    public
            static        winFileToUrl(string $filename[, bool $mpdf = false ]) : string

Parameters

$filename : string: file name on local system
$mpdf : bool = false

Return values

string

writeAllSheets()

Write all sheets (resets sheetIndex to NULL).


    public
                    writeAllSheets() : $this

Return values

$this

checkRtlAndLtr()


    protected
                    checkRtlAndLtr() : void

maybeCloseFileHandle()

Close file handle only if we opened it ourselves.


    protected
                    maybeCloseFileHandle() : void

processFlags()


    protected
                    processFlags(int $flags) : void

Parameters

$flags : int

adjustRendererPositions()


    private
                    adjustRendererPositions(Chart $chart, Worksheet $sheet) : void

Parameters

$chart : Chart
$sheet : Worksheet

assembleCSS()

Takes array where of CSS properties / values and converts to CSS string.


    private
                    assembleCSS([array<string|int, string> $values = [] ]) : string

Parameters

$values : array<string|int, string> = []

Return values

string

buildCssPerSheet()


    private
                    buildCssPerSheet(Worksheet $sheet, array<string|int, array<string|int, string>> &$css) : void

Parameters

$sheet : Worksheet
$css : array<string|int, array<string|int, string>>

buildCssRowHeights()


    private
                    buildCssRowHeights(Worksheet $sheet, array<string|int, array<string|int, string>> &$css, int $sheetIndex) : void

Parameters

$sheet : Worksheet
$css : array<string|int, array<string|int, string>>
$sheetIndex : int

calculateSpans()

Calculate information about HTML colspan and rowspan which is not always the same as Excel's.


    private
                    calculateSpans() : void

calculateSpansOmitRows()


    private
                    calculateSpansOmitRows(Worksheet $sheet, int $sheetIndex, array<string|int, int> $candidateSpannedRow) : void

Parameters

$sheet : Worksheet
$sheetIndex : int
$candidateSpannedRow : array<string|int, int>

createCSSStyle()

Create CSS style.


    private
                    createCSSStyle(Style $style[, bool $conditional = false ]) : array<string|int, string>

Parameters

$style : Style
$conditional : bool = false

Return values

array<string|int, string>

createCSSStyleAlignment()

Create CSS style.


    private
                    createCSSStyleAlignment(Alignment $alignment) : array<string|int, string>

Parameters

$alignment : Alignment

Return values

array<string|int, string>

createCSSStyleBorder()

Create CSS style.


    private
                    createCSSStyleBorder(Border $border) : string

Parameters

$border : Border: Border

Return values

string

createCSSStyleBorders()

Create CSS style.


    private
                    createCSSStyleBorders(Borders $borders) : array<string|int, string>

Parameters

$borders : Borders: Borders

Return values

array<string|int, string>

createCSSStyleFill()

Create CSS style (Fill).


    private
                    createCSSStyleFill(Fill $fill) : array<string|int, string>

Parameters

$fill : Fill: Fill

Return values

array<string|int, string>

createCSSStyleFont()

Create CSS style.


    private
                    createCSSStyleFont(Font $font[, bool $useDefaults = false ][, bool $conditional = false ]) : array<string|int, string>

Parameters

$font : Font
$useDefaults : bool = false
$conditional : bool = false

Return values

array<string|int, string>

extendRowsAndColumns()


    private
                    extendRowsAndColumns(Worksheet $worksheet, int &$colMax, int &$rowMax) : void

Parameters

$worksheet : Worksheet
$colMax : int
$rowMax : int

generateMeta()


    private
            static        generateMeta(string|null $val, string $desc) : string

Parameters

$val : string|null
$desc : string

Return values

string

generatePageDeclarations()

Generate @page declarations.


    private
                    generatePageDeclarations(bool $generateSurroundingHTML) : string

Parameters

$generateSurroundingHTML : bool

Return values

string

generateRow()

Generate row.


    private
                    generateRow(Worksheet $worksheet, array<int, string> $values, int $row, string $cellType) : string

Parameters

$worksheet : Worksheet
$values : array<int, string>: Array containing cells in a row
$row : int: Row number (0-based)
$cellType : string: eg: 'td'

Return values

string

generateRowCellCss()


    private
                    generateRowCellCss(Worksheet $worksheet, string $cellAddress, int $row, int $columnNumber) : Cell, : array{}|string, : non-empty-string}

Parameters

$worksheet : Worksheet
$cellAddress : string
$row : int
$columnNumber : int

Return values

Cell, : array{}|string, : non-empty-string}

generateRowCellData()


    private
                    generateRowCellData(Worksheet $worksheet, null|Cell|string $cell, string|array<string|int, string> &$cssClass) : string

Parameters

$worksheet : Worksheet
$cell : null|Cell|string
$cssClass : string|array<string|int, string>

Return values

string

generateRowCellDataValue()


    private
                    generateRowCellDataValue(Worksheet $worksheet, Cell $cell, string &$cellData) : void

Parameters

$worksheet : Worksheet
$cell : Cell
$cellData : string

generateRowCellDataValueRich()


    private
                    generateRowCellDataValueRich(RichText $richText[, Font|null $defaultFont = null ]) : string

Parameters

$richText : RichText
$defaultFont : Font|null = null

Return values

string

generateRowIncludeCharts()


    private
                    generateRowIncludeCharts(Worksheet $worksheet, string $coordinate) : string

Parameters

$worksheet : Worksheet
$coordinate : string

Return values

string

generateRowSpans()


    private
                    generateRowSpans(string $html, int $rowSpan, int $colSpan) : string

Parameters

$html : string
$rowSpan : int
$colSpan : int

Return values

string

generateRowStart()

Generate row start.


    private
                    generateRowStart(Worksheet $worksheet, int $sheetIndex, int $row) : string

Parameters

$worksheet : Worksheet
$sheetIndex : int: Sheet index (0-based)
$row : int: row number

Return values

string

generateRowWriteCell()


    private
                    generateRowWriteCell(string &$html, Worksheet $worksheet, string $coordinate, string $cellType, string $cellData, int $colSpan, int $rowSpan, string|array<string|int, string> $cssClass, int $colNum, int $sheetIndex, int $row[, array<string|int, Conditional> $condStyles = [] ]) : void

Parameters

$html : string
$worksheet : Worksheet
$coordinate : string
$cellType : string
$cellData : string
$colSpan : int
$rowSpan : int
$cssClass : string|array<string|int, string>
$colNum : int
$sheetIndex : int
$row : int
$condStyles : array<string|int, Conditional> = []

generateSheetPrep()


    private
                    generateSheetPrep() : array<string|int, Worksheet>

Return values

array<string|int, Worksheet>

generateSheetStarts()


    private
                    generateSheetStarts(Worksheet $sheet, int $rowMin) : array{: int, : int, : int}

Parameters

$sheet : Worksheet
$rowMin : int

Return values

array{: int, : int, : int}

generateSheetTags()


    private
                    generateSheetTags(int $row, int $theadStart, int $theadEnd, int $tbodyStart) : array{: string, : string, : string}

Parameters

$row : int
$theadStart : int
$theadEnd : int
$tbodyStart : int

Return values

array{: string, : string, : string}

generateTableFooter()

Generate table footer.


    private
                    generateTableFooter() : string

Return values

string

generateTableHeader()

Generate table header.


    private
                    generateTableHeader(Worksheet $worksheet[, bool $showid = true ]) : string

Parameters

$worksheet : Worksheet: The worksheet for the table we are writing
$showid : bool = true: whether or not to add id to table tag

Return values

string

generateTableTag()


    private
                    generateTableTag(Worksheet $worksheet, string $id, string &$html, int $sheetIndex) : void

Parameters

$worksheet : Worksheet
$id : string
$html : string
$sheetIndex : int

generateTableTagInline()


    private
                    generateTableTagInline(Worksheet $worksheet, string $id) : string

Parameters

$worksheet : Worksheet
$id : string

Return values

string

getDir()


    private
                    getDir(Worksheet $worksheet) : string

Parameters

$worksheet : Worksheet

Return values

string

getFloat()


    private
                    getFloat(Worksheet $worksheet) : string

Parameters

$worksheet : Worksheet

Return values

string

mapBorderStyle()

Map border style.


    private
                    mapBorderStyle(int|string $borderStyle) : string

Parameters

$borderStyle : int|string: Sheet index

Return values

string

mapHAlign()

Map HAlign.


    private
                    mapHAlign(string $hAlign) : string

Parameters

$hAlign : string: Horizontal alignment

Return values

string

mapVAlign()

Map VAlign.


    private
                    mapVAlign(string $vAlign) : string

Parameters

$vAlign : string: Vertical alignment

Return values

string

replaceControlChars()


    private
            static        replaceControlChars(string $convert) : string

Parameters

$convert : string

Return values

string

replaceNonAscii()


    private
            static        replaceNonAscii(array<string|int, string> $matches) : string

Parameters

$matches : array<string|int, string>

Return values

string

shouldGenerateColumn()


    private
                    shouldGenerateColumn(Worksheet $sheet, string $colStr) : bool

Parameters

$sheet : Worksheet
$colStr : string

Return values

bool

shouldGenerateRow()


    private
                    shouldGenerateRow(Worksheet $sheet, int $row) : bool

Parameters

$sheet : Worksheet
$row : int

Return values

bool

styleBorder()


    private
                    styleBorder(array<string|int, string> &$css, string $index, Border $border) : void

Parameters

$css : array<string|int, string>
$index : string
$border : Border

writeChartInCell()

Generate chart tag in cell.


    private
                    writeChartInCell(Worksheet $worksheet, string $coordinates) : string

This code should be exercised by sample: Chart/32_Chart_read_write_PDF.php.

Parameters

$worksheet : Worksheet
$coordinates : string

Return values

string

writeComment()

Write a comment in the same format as LibreOffice.


    private
                    writeComment(Worksheet $worksheet, string $coordinate) : string

Parameters

$worksheet : Worksheet
$coordinate : string

Return values

string

writeImageInCell()

Generate image tag in cell.


    private
                    writeImageInCell(string $coordinates) : string

Parameters

$coordinates : string: Cell coordinates

Return values

string

Html extends BaseWriter in package Application

Table of Contents

Constants

Properties

Methods

Constants

BODY_LINE

BORDER_ARR

BORDER_NONE

COMMENT_HTML_TAGS_PLAINTEXT

CUSTOM_TO_META

DEFAULT_CELL_WIDTH_PIXELS

DEFAULT_CELL_WIDTH_POINTS

Properties

$conditionalFormatting

$embedImages

$fileHandle

$includeCharts

$isPdf

$ltrSheets

$preCalculateFormulas

$rtlSheets

$spreadsheet

$tableFormats

$betterBoolean

$columnWidths

$cssStyles

$defaultFont

$diskCachingDirectory

$editHtmlCallback

$generateSheetNavigationBlock

$getFalse

$getTrue

$imagesRoot

$isBaseCell

$isSpannedCell

$isSpannedRow

$sheetCharts

$sheetDrawings

$sheetIndex

$shouldCloseFile

$spansAreCalculated

$useDiskCaching

$useInlineCss

Methods

__construct()

Parameters

buildCSS()

Parameters

Return values

formatColor()

Parameters

Return values

formatColorStatic()

Parameters

Return values

generateHtmlAll()

Return values

generateHTMLFooter()

Return values

generateHTMLHeader()

Parameters

Return values

generateNavigation()

Return values

generateSheetData()

Return values

generateStyles()

Parameters

Return values

getBetterBoolean()

Return values

getConditionalFormatting()

Return values

getDiskCachingDirectory()

Return values

getEmbedImages()

Return values

getGenerateSheetNavigationBlock()

Return values

Html extends BaseWriter
in package

Application