@@ -1147,14 +1147,14 @@ |
||
1147 | 1147 | |
1148 | 1148 | // Pack the main data stream |
1149 | 1149 | $data = pack('vvvv', $row1, $row2, $col1, $col2) . |
1150 | - $unknown1 . |
|
1151 | - $link_type . |
|
1152 | - $unknown2 . |
|
1153 | - $up_count . |
|
1154 | - $dir_short_len . |
|
1155 | - $dir_short . |
|
1156 | - $unknown3 . |
|
1157 | - $stream_len; /*. |
|
1150 | + $unknown1 . |
|
1151 | + $link_type . |
|
1152 | + $unknown2 . |
|
1153 | + $up_count . |
|
1154 | + $dir_short_len . |
|
1155 | + $dir_short . |
|
1156 | + $unknown3 . |
|
1157 | + $stream_len; /*. |
|
1158 | 1158 | $dir_long_len . |
1159 | 1159 | $unknown4 . |
1160 | 1160 | $dir_long . |
@@ -31,17 +31,17 @@ |
||
31 | 31 | |
32 | 32 | // Add some data |
33 | 33 | $database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'], |
34 | - ['Apple', 18, 20, 14, 105.00], |
|
35 | - ['Pear', 12, 12, 10, 96.00], |
|
36 | - ['Cherry', 13, 14, 9, 105.00], |
|
37 | - ['Apple', 14, 15, 10, 75.00], |
|
38 | - ['Pear', 9, 8, 8, 76.80], |
|
39 | - ['Apple', 8, 9, 6, 45.00], |
|
40 | - ]; |
|
34 | + ['Apple', 18, 20, 14, 105.00], |
|
35 | + ['Pear', 12, 12, 10, 96.00], |
|
36 | + ['Cherry', 13, 14, 9, 105.00], |
|
37 | + ['Apple', 14, 15, 10, 75.00], |
|
38 | + ['Pear', 9, 8, 8, 76.80], |
|
39 | + ['Apple', 8, 9, 6, 45.00], |
|
40 | + ]; |
|
41 | 41 | $criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'], |
42 | - ['="=Apple"', '>10', null, null, null, '<16'], |
|
43 | - ['="=Pear"', null, null, null, null, null], |
|
44 | - ]; |
|
42 | + ['="=Apple"', '>10', null, null, null, '<16'], |
|
43 | + ['="=Pear"', null, null, null, null, null], |
|
44 | + ]; |
|
45 | 45 | |
46 | 46 | $worksheet->fromArray($criteria, null, 'A1'); |
47 | 47 | $worksheet->fromArray($database, null, 'A4'); |
@@ -31,17 +31,17 @@ |
||
31 | 31 | |
32 | 32 | // Add some data |
33 | 33 | $database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'], |
34 | - ['Apple', 18, 20, 14, 105.00], |
|
35 | - ['Pear', 12, 12, 10, 96.00], |
|
36 | - ['Cherry', 13, 14, 9, 105.00], |
|
37 | - ['Apple', 14, 15, 10, 75.00], |
|
38 | - ['Pear', 9, 8, 8, 76.80], |
|
39 | - ['Apple', 8, 9, 6, 45.00], |
|
40 | - ]; |
|
34 | + ['Apple', 18, 20, 14, 105.00], |
|
35 | + ['Pear', 12, 12, 10, 96.00], |
|
36 | + ['Cherry', 13, 14, 9, 105.00], |
|
37 | + ['Apple', 14, 15, 10, 75.00], |
|
38 | + ['Pear', 9, 8, 8, 76.80], |
|
39 | + ['Apple', 8, 9, 6, 45.00], |
|
40 | + ]; |
|
41 | 41 | $criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'], |
42 | - ['="=Apple"', '>10', null, null, null, '<16'], |
|
43 | - ['="=Pear"', null, null, null, null, null], |
|
44 | - ]; |
|
42 | + ['="=Apple"', '>10', null, null, null, '<16'], |
|
43 | + ['="=Pear"', null, null, null, null, null], |
|
44 | + ]; |
|
45 | 45 | |
46 | 46 | $worksheet->fromArray($criteria, null, 'A1'); |
47 | 47 | $worksheet->fromArray($database, null, 'A4'); |
@@ -31,17 +31,17 @@ |
||
31 | 31 | |
32 | 32 | // Add some data |
33 | 33 | $database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'], |
34 | - ['Apple', 18, 20, 14, 105.00], |
|
35 | - ['Pear', 12, 12, 10, 96.00], |
|
36 | - ['Cherry', 13, 14, 9, 105.00], |
|
37 | - ['Apple', 14, 15, 10, 75.00], |
|
38 | - ['Pear', 9, 8, 8, 76.80], |
|
39 | - ['Apple', 8, 9, 6, 45.00], |
|
40 | - ]; |
|
34 | + ['Apple', 18, 20, 14, 105.00], |
|
35 | + ['Pear', 12, 12, 10, 96.00], |
|
36 | + ['Cherry', 13, 14, 9, 105.00], |
|
37 | + ['Apple', 14, 15, 10, 75.00], |
|
38 | + ['Pear', 9, 8, 8, 76.80], |
|
39 | + ['Apple', 8, 9, 6, 45.00], |
|
40 | + ]; |
|
41 | 41 | $criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'], |
42 | - ['="=Apple"', '>10', null, null, null, '<16'], |
|
43 | - ['="=Pear"', null, null, null, null, null], |
|
44 | - ]; |
|
42 | + ['="=Apple"', '>10', null, null, null, '<16'], |
|
43 | + ['="=Pear"', null, null, null, null, null], |
|
44 | + ]; |
|
45 | 45 | |
46 | 46 | $worksheet->fromArray($criteria, null, 'A1'); |
47 | 47 | $worksheet->fromArray($database, null, 'A4'); |
@@ -31,17 +31,17 @@ |
||
31 | 31 | |
32 | 32 | // Add some data |
33 | 33 | $database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'], |
34 | - ['Apple', 18, 20, 14, 105.00], |
|
35 | - ['Pear', 12, 12, 10, 96.00], |
|
36 | - ['Cherry', 13, 14, 9, 105.00], |
|
37 | - ['Apple', 14, 15, 10, 75.00], |
|
38 | - ['Pear', 9, 8, 8, 76.80], |
|
39 | - ['Apple', 8, 9, 6, 45.00], |
|
40 | - ]; |
|
34 | + ['Apple', 18, 20, 14, 105.00], |
|
35 | + ['Pear', 12, 12, 10, 96.00], |
|
36 | + ['Cherry', 13, 14, 9, 105.00], |
|
37 | + ['Apple', 14, 15, 10, 75.00], |
|
38 | + ['Pear', 9, 8, 8, 76.80], |
|
39 | + ['Apple', 8, 9, 6, 45.00], |
|
40 | + ]; |
|
41 | 41 | $criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'], |
42 | - ['="=Apple"', '>10', null, null, null, '<16'], |
|
43 | - ['="=Pear"', null, null, null, null, null], |
|
44 | - ]; |
|
42 | + ['="=Apple"', '>10', null, null, null, '<16'], |
|
43 | + ['="=Pear"', null, null, null, null, null], |
|
44 | + ]; |
|
45 | 45 | |
46 | 46 | $worksheet->fromArray($criteria, null, 'A1'); |
47 | 47 | $worksheet->fromArray($database, null, 'A4'); |
@@ -31,17 +31,17 @@ |
||
31 | 31 | |
32 | 32 | // Add some data |
33 | 33 | $database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'], |
34 | - ['Apple', 18, 20, 14, 105.00], |
|
35 | - ['Pear', 12, 12, 10, 96.00], |
|
36 | - ['Cherry', 13, 14, 9, 105.00], |
|
37 | - ['Apple', 14, 15, 10, 75.00], |
|
38 | - ['Pear', 9, 8, 8, 76.80], |
|
39 | - ['Apple', 8, 9, 6, 45.00], |
|
40 | - ]; |
|
34 | + ['Apple', 18, 20, 14, 105.00], |
|
35 | + ['Pear', 12, 12, 10, 96.00], |
|
36 | + ['Cherry', 13, 14, 9, 105.00], |
|
37 | + ['Apple', 14, 15, 10, 75.00], |
|
38 | + ['Pear', 9, 8, 8, 76.80], |
|
39 | + ['Apple', 8, 9, 6, 45.00], |
|
40 | + ]; |
|
41 | 41 | $criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'], |
42 | - ['="=Apple"', '>10', null, null, null, '<16'], |
|
43 | - ['="=Pear"', null, null, null, null, null], |
|
44 | - ]; |
|
42 | + ['="=Apple"', '>10', null, null, null, '<16'], |
|
43 | + ['="=Pear"', null, null, null, null, null], |
|
44 | + ]; |
|
45 | 45 | |
46 | 46 | $worksheet->fromArray($criteria, null, 'A1'); |
47 | 47 | $worksheet->fromArray($database, null, 'A4'); |
@@ -31,17 +31,17 @@ |
||
31 | 31 | |
32 | 32 | // Add some data |
33 | 33 | $database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'], |
34 | - ['Apple', 18, 20, 14, 105.00], |
|
35 | - ['Pear', 12, 12, 10, 96.00], |
|
36 | - ['Cherry', 13, 14, 9, 105.00], |
|
37 | - ['Apple', 14, 15, 10, 75.00], |
|
38 | - ['Pear', 9, 8, 8, 76.80], |
|
39 | - ['Apple', 8, 9, 6, 45.00], |
|
40 | - ]; |
|
34 | + ['Apple', 18, 20, 14, 105.00], |
|
35 | + ['Pear', 12, 12, 10, 96.00], |
|
36 | + ['Cherry', 13, 14, 9, 105.00], |
|
37 | + ['Apple', 14, 15, 10, 75.00], |
|
38 | + ['Pear', 9, 8, 8, 76.80], |
|
39 | + ['Apple', 8, 9, 6, 45.00], |
|
40 | + ]; |
|
41 | 41 | $criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'], |
42 | - ['="=Apple"', '>10', null, null, null, '<16'], |
|
43 | - ['="=Pear"', null, null, null, null, null], |
|
44 | - ]; |
|
42 | + ['="=Apple"', '>10', null, null, null, '<16'], |
|
43 | + ['="=Pear"', null, null, null, null, null], |
|
44 | + ]; |
|
45 | 45 | |
46 | 46 | $worksheet->fromArray($criteria, null, 'A1'); |
47 | 47 | $worksheet->fromArray($database, null, 'A4'); |
@@ -31,17 +31,17 @@ |
||
31 | 31 | |
32 | 32 | // Add some data |
33 | 33 | $database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'], |
34 | - ['Apple', 18, 20, 14, 105.00], |
|
35 | - ['Pear', 12, 12, 10, 96.00], |
|
36 | - ['Cherry', 13, 14, 9, 105.00], |
|
37 | - ['Apple', 14, 15, 10, 75.00], |
|
38 | - ['Pear', 9, 8, 8, 76.80], |
|
39 | - ['Apple', 8, 9, 6, 45.00], |
|
40 | - ]; |
|
34 | + ['Apple', 18, 20, 14, 105.00], |
|
35 | + ['Pear', 12, 12, 10, 96.00], |
|
36 | + ['Cherry', 13, 14, 9, 105.00], |
|
37 | + ['Apple', 14, 15, 10, 75.00], |
|
38 | + ['Pear', 9, 8, 8, 76.80], |
|
39 | + ['Apple', 8, 9, 6, 45.00], |
|
40 | + ]; |
|
41 | 41 | $criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'], |
42 | - ['="=Apple"', '>10', null, null, null, '<16'], |
|
43 | - ['="=Pear"', null, null, null, null, null], |
|
44 | - ]; |
|
42 | + ['="=Apple"', '>10', null, null, null, '<16'], |
|
43 | + ['="=Pear"', null, null, null, null, null], |
|
44 | + ]; |
|
45 | 45 | |
46 | 46 | $worksheet->fromArray($criteria, null, 'A1'); |
47 | 47 | $worksheet->fromArray($database, null, 'A4'); |
@@ -31,17 +31,17 @@ |
||
31 | 31 | |
32 | 32 | // Add some data |
33 | 33 | $database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'], |
34 | - ['Apple', 18, 20, 14, 105.00], |
|
35 | - ['Pear', 12, 12, 10, 96.00], |
|
36 | - ['Cherry', 13, 14, 9, 105.00], |
|
37 | - ['Apple', 14, 15, 10, 75.00], |
|
38 | - ['Pear', 9, 8, 8, 76.80], |
|
39 | - ['Apple', 8, 9, 6, 45.00], |
|
40 | - ]; |
|
34 | + ['Apple', 18, 20, 14, 105.00], |
|
35 | + ['Pear', 12, 12, 10, 96.00], |
|
36 | + ['Cherry', 13, 14, 9, 105.00], |
|
37 | + ['Apple', 14, 15, 10, 75.00], |
|
38 | + ['Pear', 9, 8, 8, 76.80], |
|
39 | + ['Apple', 8, 9, 6, 45.00], |
|
40 | + ]; |
|
41 | 41 | $criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'], |
42 | - ['="=Apple"', '>10', null, null, null, '<16'], |
|
43 | - ['="=Pear"', null, null, null, null, null], |
|
44 | - ]; |
|
42 | + ['="=Apple"', '>10', null, null, null, '<16'], |
|
43 | + ['="=Pear"', null, null, null, null, null], |
|
44 | + ]; |
|
45 | 45 | |
46 | 46 | $worksheet->fromArray($criteria, null, 'A1'); |
47 | 47 | $worksheet->fromArray($database, null, 'A4'); |