05 Feature demo
01:23:50 Create new Spreadsheet object
01:23:50 Set document properties
01:23:50 Add some data
Warning: Trying to access array offset on value of type float in
/var/www/erp/spreadsheet/src/PhpSpreadsheet/Cell/DefaultValueBinder.php on line
74
01:23:50 Add comments
01:23:50 Add rich-text string
01:23:50 Merge cells
01:23:50 Protect cells
01:23:50 Set cell number formats
01:23:50 Set column widths
01:23:50 Set fonts
01:23:50 Set alignments
01:23:50 Set thin black border outline around column
01:23:50 Set thick brown border outline around Total
01:23:50 Set fills
01:23:50 Set style for header row using alternative method
01:23:50 Unprotect a cell
01:23:50 Add a hyperlink to an external website
01:23:50 Add a hyperlink to another cell on a different worksheet within the workbook
01:23:50 Add a drawing to the worksheet
01:23:50 Add a drawing to the worksheet
01:23:50 Add a drawing to the worksheet
01:23:50 Play around with inserting and removing rows and columns
01:23:50 Set header/footer
01:23:50 Set page orientation and size
01:23:50 Rename first worksheet
01:23:50 Create a second Worksheet object
01:23:50 Add some data
01:23:50 Set the worksheet tab color
01:23:50 Set alignments
01:23:50 Set column widths
01:23:50 Set fonts
01:23:50 Add a drawing to the worksheet
01:23:50 Set page orientation and size
01:23:50 Rename second worksheet
Fatal error: Uncaught Error: Class "ZipArchive" not found in /var/www/erp/spreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php:212
Stack trace:
#0 /var/www/erp/spreadsheet/src/PhpSpreadsheet/Helper/Sample.php(100): PhpOffice\PhpSpreadsheet\Writer\Xlsx->save()
#1 /var/www/erp/spreadsheet/samples/05_Feature_demo.php(7): PhpOffice\PhpSpreadsheet\Helper\Sample->write()
#2 {main}
thrown in
/var/www/erp/spreadsheet/src/PhpSpreadsheet/Writer/Xlsx.php on line
212