@@ -140,8 +140,8 @@ |
||
140 | 140 | } |
141 | 141 | |
142 | 142 | $hashTablesArray = ['stylesConditionalHashTable', 'fillHashTable', 'fontHashTable', |
143 | - 'bordersHashTable', 'numFmtHashTable', 'drawingHashTable', |
|
144 | - 'styleHashTable', |
|
143 | + 'bordersHashTable', 'numFmtHashTable', 'drawingHashTable', |
|
144 | + 'styleHashTable', |
|
145 | 145 | ]; |
146 | 146 | |
147 | 147 | // Set HashTable variables |
@@ -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 . |
@@ -62,7 +62,7 @@ |
||
62 | 62 | /* Tell the Reader that we want to use the Read Filter that we've Instantiated **/ |
63 | 63 | /* and that we want to store it in contiguous rows/columns **/ |
64 | 64 | $objReader->setReadFilter($chunkFilter) |
65 | - ->setContiguous(true); |
|
65 | + ->setContiguous(true); |
|
66 | 66 | |
67 | 67 | /* Instantiate a new PHPExcel object manually **/ |
68 | 68 | $objPHPExcel = new PHPExcel(); |
@@ -31,7 +31,7 @@ discard block |
||
31 | 31 | |
32 | 32 | // Add some data |
33 | 33 | $testDates = ['3:15', '13:15', '15:15:15', '3:15 AM', '3:15 PM', '5PM', '9:15AM', '13:15AM', |
34 | - ]; |
|
34 | + ]; |
|
35 | 35 | $testDateCount = count($testDates); |
36 | 36 | |
37 | 37 | for ($row = 1; $row <= $testDateCount; ++$row) { |
@@ -41,8 +41,8 @@ discard block |
||
41 | 41 | } |
42 | 42 | |
43 | 43 | $worksheet->getStyle('C1:C' . $testDateCount) |
44 | - ->getNumberFormat() |
|
45 | - ->setFormatCode('hh:mm:ss'); |
|
44 | + ->getNumberFormat() |
|
45 | + ->setFormatCode('hh:mm:ss'); |
|
46 | 46 | |
47 | 47 | echo '<hr />'; |
48 | 48 |
@@ -35,7 +35,7 @@ discard block |
||
35 | 35 | [2011, 2, 29], [7, 5, 3], [2012, 13, 1], [2012, 11, 45], |
36 | 36 | [2012, 0, 0], [2012, 1, 0], [2012, 0, 1], |
37 | 37 | [2012, -2, 2], [2012, 2, -2], [2012, -2, -2], |
38 | - ]; |
|
38 | + ]; |
|
39 | 39 | $testDateCount = count($testDates); |
40 | 40 | |
41 | 41 | $worksheet->fromArray($testDates, null, 'A1', true); |
@@ -45,8 +45,8 @@ discard block |
||
45 | 45 | $worksheet->setCellValue('E' . $row, '=D' . $row); |
46 | 46 | } |
47 | 47 | $worksheet->getStyle('E1:E' . $testDateCount) |
48 | - ->getNumberFormat() |
|
49 | - ->setFormatCode('yyyy-mmm-dd'); |
|
48 | + ->getNumberFormat() |
|
49 | + ->setFormatCode('yyyy-mmm-dd'); |
|
50 | 50 | |
51 | 51 | echo '<hr />'; |
52 | 52 |
@@ -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'); |