Worksheets : 3
WorkSheet 0 heet "Data Sheet #1"WorkSheet 1 heet "Data Sheet #2"WorkSheet 2 heet "Data Sheet #3"
Worksheet Information
- Data Sheet #1
Rows: 8 Columns: 6
Cell Range: A1:F8 - Data Sheet #2
Rows: 1 Columns: 1
Cell Range: A1:A1 - Data Sheet #3
Rows: 23 Columns: 11
Cell Range: A1:K23
array(8) {
[1]=>
array(6) {
["A"]=>
string(15) "Integer Numbers"
["B"]=>
string(3) "123"
["C"]=>
string(3) "234"
["D"]=>
string(4) "-345"
["E"]=>
string(3) "456"
["F"]=>
NULL
}
[2]=>
array(6) {
["A"]=>
string(22) "Floating Point Numbers"
["B"]=>
string(4) "1.23"
["C"]=>
string(5) "23.45"
["D"]=>
string(7) "3.45E-6"
["E"]=>
string(6) "-45.68"
["F"]=>
string(7) "£56.78"
}
[3]=>
array(6) {
["A"]=>
string(7) "Strings"
["B"]=>
string(5) "Hello"
["C"]=>
string(5) "World"
["D"]=>
NULL
["E"]=>
string(8) "PHPExcel"
["F"]=>
NULL
}
[4]=>
array(6) {
["A"]=>
string(8) "Booleans"
["B"]=>
bool(true)
["C"]=>
bool(false)
["D"]=>
NULL
["E"]=>
NULL
["F"]=>
NULL
}
[5]=>
array(6) {
["A"]=>
string(5) "Dates"
["B"]=>
string(16) "19 December 1960"
["C"]=>
string(15) "10 October 2010"
["D"]=>
NULL
["E"]=>
NULL
["F"]=>
NULL
}
[6]=>
array(6) {
["A"]=>
string(5) "Times"
["B"]=>
string(4) "9:30"
["C"]=>
string(5) "23:59"
["D"]=>
NULL
["E"]=>
NULL
["F"]=>
NULL
}
[7]=>
array(6) {
["A"]=>
string(8) "Formulae"
["B"]=>
string(3) "468"
["C"]=>
string(7) "-20.998"
["D"]=>
NULL
["E"]=>
NULL
["F"]=>
NULL
}
[8]=>
array(6) {
["A"]=>
string(6) "Errors"
["B"]=>
string(4) "#N/A"
["C"]=>
string(7) "#DIV/0!"
["D"]=>
NULL
["E"]=>
NULL
["F"]=>
NULL
}
}
| Integer Numbers | 123 | 234 | -345 | 456 | |
| Floating Point Numbers | 1.23 | 23.45 | 3.45E-6 | -45.68 | £56.78 |
| Strings | Hello | World | | PHPExcel | |
| Booleans | 1 | | | | |
| Dates | 19 December 1960 | 10 October 2010 | | | |
| Times | 9:30 | 23:59 | | | |
| Formulae | 468 | -20.998 | | | |
| Errors | #N/A | #DIV/0! | | | |