VALIGN_ARR = [\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_BOTTOM => 'bottom', \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_TOP => 'top', \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER => 'middle', \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_JUSTIFY => 'middle']
HALIGN_ARR = [\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT => 'left', \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_RIGHT => 'right', \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER => 'center', \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER_CONTINUOUS => 'center', \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_JUSTIFY => 'justify']
BORDER_ARR = [\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_NONE => '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']
$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;.
$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.
$fileHandle : resource
$spreadsheet : \PhpOffice\PhpSpreadsheet\Spreadsheet
Spreadsheet object.
$isPdf : bool
Is the current writer creating PDF?
$useDiskCaching : bool
Use disk caching where possible?
$diskCachingDirectory : string
Disk caching directory.
$shouldCloseFile : bool
$sheetIndex : int
Sheet index to write.
$imagesRoot : string
Images root.
$embedImages : bool
embed images, or link to images.
$useInlineCss : bool
Use inline CSS?
$useEmbeddedCSS : bool
Use embedded CSS?
$cssStyles : array
Array of CSS styles.
$columnWidths : array
Array of column widths in points.
$defaultFont : \PhpOffice\PhpSpreadsheet\Style\Font
Default font.
$spansAreCalculated : bool
Flag whether spans have been calculated.
$isSpannedCell : array
Excel cells that should not be written as HTML cells.
$isBaseCell : array
Excel cells that are upper-left corner in a cell merge.
$isSpannedRow : array
Excel rows that should not be written as HTML rows.
$generateSheetNavigationBlock : bool
Generate the Navigation block.
$editHtmlCallback : null|callable
Callback for editing generated html.
setIncludeCharts(mixed $pValue) : \PhpOffice\PhpSpreadsheet\Writer\IWriter
Set write charts in workbook Set to true, to advise the Writer to include any charts that exist in the PhpSpreadsheet object.
Set to false (the default) to ignore charts.
| mixed | $pValue |
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.
setPreCalculateFormulas(mixed $pValue) : \PhpOffice\PhpSpreadsheet\Writer\IWriter
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.
| mixed | $pValue | Pre-Calculate Formulas? |
extendRowsForCharts(\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet, int $row) : array
Extend Row if chart is placed after nominal end of row.
This code should be exercised by sample: Chart/32_Chart_read_write_PDF.php. However, that test is suppressed due to out-of-date Jpgraph code issuing warnings. So, don't measure code coverage for this function till that is fixed.
| \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pSheet | \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet |
| int | $row | Row to check for charts |
writeImageInCell(\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet, string $coordinates) : string
Generate image tag in cell.
| \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pSheet | \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet |
| string | $coordinates | Cell coordinates |
writeChartInCell(\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet, string $coordinates) : string
Generate chart tag in cell.
This code should be exercised by sample: Chart/32_Chart_read_write_PDF.php. However, that test is suppressed due to out-of-date Jpgraph code issuing warnings. So, don't measure code coverage for this function till that is fixed.
| \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pSheet | \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet |
| string | $coordinates | Cell coordinates |
getChartCaption(mixed $cap) : string
Extend Row if chart is placed after nominal end of row.
This code should be exercised by sample: Chart/32_Chart_read_write_PDF.php. However, that test is suppressed due to out-of-date Jpgraph code issuing warnings. So, don't measure code coverage for this function till that is fixed. Caption is described in documentation as fixed, but in 32_Chart it is somehow an array of RichText.
| mixed | $cap |
generateTableHeader(\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet, bool $showid = true) : string
Generate table header.
| \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pSheet | The worksheet for the table we are writing |
| bool | $showid | whether or not to add id to table tag |
generateRowStart(\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet, int $sheetIndex, int $pRow) : string
Generate row start.
| \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pSheet | \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet |
| int | $sheetIndex | Sheet index (0-based) |
| int | $pRow | row number |
generateRowWriteCell(mixed $html, mixed $pSheet, mixed $coordinate, mixed $cellType, mixed $cellData, mixed $colSpan, mixed $rowSpan, mixed $cssClass, mixed $colNum, mixed $sheetIndex, mixed $pRow) : void
| mixed | $html | |
| mixed | $pSheet | |
| mixed | $coordinate | |
| mixed | $cellType | |
| mixed | $cellData | |
| mixed | $colSpan | |
| mixed | $rowSpan | |
| mixed | $cssClass | |
| mixed | $colNum | |
| mixed | $sheetIndex | |
| mixed | $pRow |
generateRow(\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet $pSheet, array $pValues, int $pRow, string $cellType) : string
Generate row.
| \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet | $pSheet | \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet |
| array | $pValues | Array containing cells in a row |
| int | $pRow | Row number (0-based) |
| string | $cellType | eg: 'td' |