Documentation

Comments extends WriterPart
in package

Table of Contents

Constants

VALID_HORIZONTAL_ALIGNMENT  = [\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER, \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_DISTRIBUTED, \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_JUSTIFY, \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT, \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_RIGHT]

Properties

$parentWriter  : Xlsx
Parent Xlsx object.

Methods

__construct()  : mixed
Set parent Xlsx object.
getParentWriter()  : Xlsx
Get parent Xlsx object.
writeComments()  : string
Write comments to XML format.
writeVMLComments()  : string
Write VML comments to XML format.
writeComment()  : void
Write comment to XML format.
writeVMLComment()  : void
Write VML comment to XML format.

Constants

VALID_HORIZONTAL_ALIGNMENT

private mixed VALID_HORIZONTAL_ALIGNMENT = [\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER, \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_DISTRIBUTED, \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_JUSTIFY, \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT, \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_RIGHT]

Properties

Methods

__construct()

Set parent Xlsx object.

public __construct(Xlsx $writer) : mixed
Parameters
$writer : Xlsx

getParentWriter()

Get parent Xlsx object.

public getParentWriter() : Xlsx
Return values
Xlsx

writeComments()

Write comments to XML format.

public writeComments(Worksheet $worksheet) : string
Parameters
$worksheet : Worksheet
Return values
string

XML Output

writeVMLComments()

Write VML comments to XML format.

public writeVMLComments(Worksheet $worksheet) : string
Parameters
$worksheet : Worksheet
Return values
string

XML Output

writeComment()

Write comment to XML format.

private writeComment(XMLWriter $objWriter, string $cellReference, Comment $comment, array<string|int, mixed> $authors) : void
Parameters
$objWriter : XMLWriter
$cellReference : string

Cell reference

$comment : Comment

Comment

$authors : array<string|int, mixed>

Array of authors

writeVMLComment()

Write VML comment to XML format.

private writeVMLComment(XMLWriter $objWriter, string $cellReference, Comment $comment) : void
Parameters
$objWriter : XMLWriter
$cellReference : string

Cell reference, eg: 'A1'

$comment : Comment

Comment


        
On this page

Search results