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