44 Worksheet info
01:08:43 Create new Spreadsheet object
01:08:43 Set document properties
01:08:43 Add some data
01:08:43 Add comments
01:08:43 Add rich-text string
01:08:43 Merge cells
01:08:43 Protect cells
01:08:43 Set cell number formats
01:08:43 Set column widths
01:08:43 Set fonts
01:08:43 Set alignments
01:08:43 Set thin black border outline around column
01:08:43 Set thick brown border outline around Total
01:08:43 Set fills
01:08:43 Set style for header row using alternative method
01:08:43 Unprotect a cell
01:08:43 Add a hyperlink to an external website
01:08:43 Add a hyperlink to another cell on a different worksheet within the workbook
01:08:43 Add a drawing to the worksheet
01:08:43 Add a drawing to the worksheet
01:08:43 Add a drawing to the worksheet
01:08:43 Play around with inserting and removing rows and columns
01:08:43 Set header/footer
01:08:43 Set page orientation and size
01:08:43 Rename first worksheet
01:08:43 Create a second Worksheet object
01:08:43 Add some data
01:08:43 Set the worksheet tab color
01:08:43 Set alignments
01:08:43 Set column widths
01:08:43 Set fonts
01:08:43 Add a drawing to the worksheet
01:08:43 Set page orientation and size
01:08:43 Rename second worksheet
01:08:43 File Type:
string(4) "Xlsx"
01:08:43 Worksheet Names:
array(2) {
[0]=>
string(7) "Invoice"
[1]=>
string(20) "Terms and conditions"
}
01:08:43 Worksheet Names:
array(2) {
[0]=>
array(5) {
["worksheetName"]=>
string(7) "Invoice"
["lastColumnLetter"]=>
string(1) "E"
["lastColumnIndex"]=>
int(4)
["totalRows"]=>
string(2) "28"
["totalColumns"]=>
int(5)
}
[1]=>
array(5) {
["worksheetName"]=>
string(20) "Terms and conditions"
["lastColumnLetter"]=>
string(1) "A"
["lastColumnIndex"]=>
int(0)
["totalRows"]=>
string(2) "14"
["totalColumns"]=>
int(1)
}
}