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