05 Feature demo
Create new Spreadsheet object
Set document properties
Add some data
Add comments
Add rich-text string
Merge cells
Protect cells
Set cell number formats
Set column widths
Set fonts
Set alignments
Set thin black border outline around column
Set thick brown border outline around Total
Set fills
Set style for header row using alternative method
Unprotect a cell
Add a hyperlink to an external website
Add a hyperlink to another cell on a different worksheet within the workbook
Add a drawing to the worksheet
Add a drawing to the worksheet
Add a drawing to the worksheet
Play around with inserting and removing rows and columns
Set header/footer
Set page orientation and size
Rename first worksheet
Create a second Worksheet object
Add some data
Set the worksheet tab color
Set alignments
Set column widths
Set fonts
Add a drawing to the worksheet
Set page orientation and size
Rename second worksheet
Write Xlsx format to
/tmp/phpspreadsheet/05_Feature_demo.xlsx in 0.0183 seconds
Download 05_Feature_demo.xlsxWrite Xls format to
/tmp/phpspreadsheet/05_Feature_demo.xls in 0.0163 seconds
Download 05_Feature_demo.xlsPeak memory usage: 56.00390625MB