@@ -41,10 +41,10 @@ |
||
41 | 41 | echo '<h3>Worksheet Information</h3>'; |
42 | 42 | echo '<ol>'; |
43 | 43 | foreach ($worksheetData as $worksheet) { |
44 | - echo '<li>', $worksheet['worksheetName'], '<br />'; |
|
45 | - echo 'Rows: ', $worksheet['totalRows'], ' Columns: ', $worksheet['totalColumns'], '<br />'; |
|
46 | - echo 'Cell Range: A1:', $worksheet['lastColumnLetter'], $worksheet['totalRows']; |
|
47 | - echo '</li>'; |
|
44 | + echo '<li>', $worksheet['worksheetName'], '<br />'; |
|
45 | + echo 'Rows: ', $worksheet['totalRows'], ' Columns: ', $worksheet['totalColumns'], '<br />'; |
|
46 | + echo 'Cell Range: A1:', $worksheet['lastColumnLetter'], $worksheet['totalRows']; |
|
47 | + echo '</li>'; |
|
48 | 48 | } |
49 | 49 | echo '</ol>'; |
50 | 50 |
@@ -21,28 +21,28 @@ |
||
21 | 21 | |
22 | 22 | foreach($exampleTypeList as $exampleType) { |
23 | 23 | |
24 | - echo '<h1>PHPExcel ' . pathinfo($exampleType,PATHINFO_BASENAME) . ' Examples</h1>'; |
|
24 | + echo '<h1>PHPExcel ' . pathinfo($exampleType,PATHINFO_BASENAME) . ' Examples</h1>'; |
|
25 | 25 | |
26 | - $exampleList = glob('./'.$exampleType.'/*.php'); |
|
26 | + $exampleList = glob('./'.$exampleType.'/*.php'); |
|
27 | 27 | |
28 | - foreach($exampleList as $exampleFile) { |
|
29 | - $fileData = file_get_contents($exampleFile); |
|
28 | + foreach($exampleList as $exampleFile) { |
|
29 | + $fileData = file_get_contents($exampleFile); |
|
30 | 30 | |
31 | - $h1Pattern = '#<h1>(.*?)</h1>#'; |
|
32 | - $h2Pattern = '#<h2>(.*?)</h2>#'; |
|
31 | + $h1Pattern = '#<h1>(.*?)</h1>#'; |
|
32 | + $h2Pattern = '#<h2>(.*?)</h2>#'; |
|
33 | 33 | |
34 | - if (preg_match($h1Pattern, $fileData, $out)) { |
|
35 | - $h1Text = $out[1]; |
|
36 | - $h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : ''; |
|
34 | + if (preg_match($h1Pattern, $fileData, $out)) { |
|
35 | + $h1Text = $out[1]; |
|
36 | + $h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : ''; |
|
37 | 37 | |
38 | - echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />'; |
|
39 | - if (($h2Text > '') && |
|
40 | - (pathinfo($exampleType,PATHINFO_BASENAME) != 'Calculations')) { |
|
41 | - echo $h2Text,'<br />'; |
|
42 | - } |
|
43 | - } |
|
38 | + echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />'; |
|
39 | + if (($h2Text > '') && |
|
40 | + (pathinfo($exampleType,PATHINFO_BASENAME) != 'Calculations')) { |
|
41 | + echo $h2Text,'<br />'; |
|
42 | + } |
|
43 | + } |
|
44 | 44 | |
45 | - } |
|
45 | + } |
|
46 | 46 | } |
47 | 47 | |
48 | 48 | ?> |
@@ -46,7 +46,7 @@ |
||
46 | 46 | echo $objPHPExcel->getSheetCount(),' worksheet',(($objPHPExcel->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />'; |
47 | 47 | $loadedSheetNames = $objPHPExcel->getSheetNames(); |
48 | 48 | foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) { |
49 | - echo $sheetIndex,' -> ',$loadedSheetName,'<br />'; |
|
49 | + echo $sheetIndex,' -> ',$loadedSheetName,'<br />'; |
|
50 | 50 | } |
51 | 51 | |
52 | 52 |
@@ -46,7 +46,7 @@ |
||
46 | 46 | echo $objPHPExcel->getSheetCount(),' worksheet',(($objPHPExcel->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />'; |
47 | 47 | $loadedSheetNames = $objPHPExcel->getSheetNames(); |
48 | 48 | foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) { |
49 | - echo $sheetIndex,' -> ',$loadedSheetName,'<br />'; |
|
49 | + echo $sheetIndex,' -> ',$loadedSheetName,'<br />'; |
|
50 | 50 | } |
51 | 51 | |
52 | 52 |
@@ -33,17 +33,17 @@ |
||
33 | 33 | |
34 | 34 | // Add some data |
35 | 35 | $database = array( array( 'Tree', 'Height', 'Age', 'Yield', 'Profit' ), |
36 | - array( 'Apple', 18, 20, 14, 105.00 ), |
|
37 | - array( 'Pear', 12, 12, 10, 96.00 ), |
|
38 | - array( 'Cherry', 13, 14, 9, 105.00 ), |
|
39 | - array( 'Apple', 14, 15, 10, 75.00 ), |
|
40 | - array( 'Pear', 9, 8, 8, 76.80 ), |
|
41 | - array( 'Apple', 8, 9, 6, 45.00 ), |
|
42 | - ); |
|
36 | + array( 'Apple', 18, 20, 14, 105.00 ), |
|
37 | + array( 'Pear', 12, 12, 10, 96.00 ), |
|
38 | + array( 'Cherry', 13, 14, 9, 105.00 ), |
|
39 | + array( 'Apple', 14, 15, 10, 75.00 ), |
|
40 | + array( 'Pear', 9, 8, 8, 76.80 ), |
|
41 | + array( 'Apple', 8, 9, 6, 45.00 ), |
|
42 | + ); |
|
43 | 43 | $criteria = array( array( 'Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height' ), |
44 | - array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ), |
|
45 | - array( '="=Pear"', NULL, NULL, NULL, NULL, NULL ) |
|
46 | - ); |
|
44 | + array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ), |
|
45 | + array( '="=Pear"', NULL, NULL, NULL, NULL, NULL ) |
|
46 | + ); |
|
47 | 47 | |
48 | 48 | $worksheet->fromArray( $criteria, NULL, 'A1' ); |
49 | 49 | $worksheet->fromArray( $database, NULL, 'A4' ); |
@@ -33,17 +33,17 @@ |
||
33 | 33 | |
34 | 34 | // Add some data |
35 | 35 | $database = array( array( 'Tree', 'Height', 'Age', 'Yield', 'Profit' ), |
36 | - array( 'Apple', 18, 20, 14, 105.00 ), |
|
37 | - array( 'Pear', 12, 12, 10, 96.00 ), |
|
38 | - array( 'Cherry', 13, 14, 9, 105.00 ), |
|
39 | - array( 'Apple', 14, 15, 10, 75.00 ), |
|
40 | - array( 'Pear', 9, 8, 8, 76.80 ), |
|
41 | - array( 'Apple', 8, 9, 6, 45.00 ), |
|
42 | - ); |
|
36 | + array( 'Apple', 18, 20, 14, 105.00 ), |
|
37 | + array( 'Pear', 12, 12, 10, 96.00 ), |
|
38 | + array( 'Cherry', 13, 14, 9, 105.00 ), |
|
39 | + array( 'Apple', 14, 15, 10, 75.00 ), |
|
40 | + array( 'Pear', 9, 8, 8, 76.80 ), |
|
41 | + array( 'Apple', 8, 9, 6, 45.00 ), |
|
42 | + ); |
|
43 | 43 | $criteria = array( array( 'Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height' ), |
44 | - array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ), |
|
45 | - array( '="=Pear"', NULL, NULL, NULL, NULL, NULL ) |
|
46 | - ); |
|
44 | + array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ), |
|
45 | + array( '="=Pear"', NULL, NULL, NULL, NULL, NULL ) |
|
46 | + ); |
|
47 | 47 | |
48 | 48 | $worksheet->fromArray( $criteria, NULL, 'A1' ); |
49 | 49 | $worksheet->fromArray( $database, NULL, 'A4' ); |
@@ -33,17 +33,17 @@ |
||
33 | 33 | |
34 | 34 | // Add some data |
35 | 35 | $database = array( array( 'Tree', 'Height', 'Age', 'Yield', 'Profit' ), |
36 | - array( 'Apple', 18, 20, 14, 105.00 ), |
|
37 | - array( 'Pear', 12, 12, 10, 96.00 ), |
|
38 | - array( 'Cherry', 13, 14, 9, 105.00 ), |
|
39 | - array( 'Apple', 14, 15, 10, 75.00 ), |
|
40 | - array( 'Pear', 9, 8, 8, 76.80 ), |
|
41 | - array( 'Apple', 8, 9, 6, 45.00 ), |
|
42 | - ); |
|
36 | + array( 'Apple', 18, 20, 14, 105.00 ), |
|
37 | + array( 'Pear', 12, 12, 10, 96.00 ), |
|
38 | + array( 'Cherry', 13, 14, 9, 105.00 ), |
|
39 | + array( 'Apple', 14, 15, 10, 75.00 ), |
|
40 | + array( 'Pear', 9, 8, 8, 76.80 ), |
|
41 | + array( 'Apple', 8, 9, 6, 45.00 ), |
|
42 | + ); |
|
43 | 43 | $criteria = array( array( 'Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height' ), |
44 | - array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ), |
|
45 | - array( '="=Pear"', NULL, NULL, NULL, NULL, NULL ) |
|
46 | - ); |
|
44 | + array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ), |
|
45 | + array( '="=Pear"', NULL, NULL, NULL, NULL, NULL ) |
|
46 | + ); |
|
47 | 47 | |
48 | 48 | $worksheet->fromArray( $criteria, NULL, 'A1' ); |
49 | 49 | $worksheet->fromArray( $database, NULL, 'A4' ); |
@@ -33,17 +33,17 @@ |
||
33 | 33 | |
34 | 34 | // Add some data |
35 | 35 | $database = array( array( 'Tree', 'Height', 'Age', 'Yield', 'Profit' ), |
36 | - array( 'Apple', 18, 20, 14, 105.00 ), |
|
37 | - array( 'Pear', 12, 12, 10, 96.00 ), |
|
38 | - array( 'Cherry', 13, 14, 9, 105.00 ), |
|
39 | - array( 'Apple', 14, 15, 10, 75.00 ), |
|
40 | - array( 'Pear', 9, 8, 8, 76.80 ), |
|
41 | - array( 'Apple', 8, 9, 6, 45.00 ), |
|
42 | - ); |
|
36 | + array( 'Apple', 18, 20, 14, 105.00 ), |
|
37 | + array( 'Pear', 12, 12, 10, 96.00 ), |
|
38 | + array( 'Cherry', 13, 14, 9, 105.00 ), |
|
39 | + array( 'Apple', 14, 15, 10, 75.00 ), |
|
40 | + array( 'Pear', 9, 8, 8, 76.80 ), |
|
41 | + array( 'Apple', 8, 9, 6, 45.00 ), |
|
42 | + ); |
|
43 | 43 | $criteria = array( array( 'Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height' ), |
44 | - array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ), |
|
45 | - array( '="=Pear"', NULL, NULL, NULL, NULL, NULL ) |
|
46 | - ); |
|
44 | + array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ), |
|
45 | + array( '="=Pear"', NULL, NULL, NULL, NULL, NULL ) |
|
46 | + ); |
|
47 | 47 | |
48 | 48 | $worksheet->fromArray( $criteria, NULL, 'A1' ); |
49 | 49 | $worksheet->fromArray( $database, NULL, 'A4' ); |
@@ -33,17 +33,17 @@ |
||
33 | 33 | |
34 | 34 | // Add some data |
35 | 35 | $database = array( array( 'Tree', 'Height', 'Age', 'Yield', 'Profit' ), |
36 | - array( 'Apple', 18, 20, 14, 105.00 ), |
|
37 | - array( 'Pear', 12, 12, 10, 96.00 ), |
|
38 | - array( 'Cherry', 13, 14, 9, 105.00 ), |
|
39 | - array( 'Apple', 14, 15, 10, 75.00 ), |
|
40 | - array( 'Pear', 9, 8, 8, 76.80 ), |
|
41 | - array( 'Apple', 8, 9, 6, 45.00 ), |
|
42 | - ); |
|
36 | + array( 'Apple', 18, 20, 14, 105.00 ), |
|
37 | + array( 'Pear', 12, 12, 10, 96.00 ), |
|
38 | + array( 'Cherry', 13, 14, 9, 105.00 ), |
|
39 | + array( 'Apple', 14, 15, 10, 75.00 ), |
|
40 | + array( 'Pear', 9, 8, 8, 76.80 ), |
|
41 | + array( 'Apple', 8, 9, 6, 45.00 ), |
|
42 | + ); |
|
43 | 43 | $criteria = array( array( 'Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height' ), |
44 | - array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ), |
|
45 | - array( '="=Pear"', NULL, NULL, NULL, NULL, NULL ) |
|
46 | - ); |
|
44 | + array( '="=Apple"', '>10', NULL, NULL, NULL, '<16' ), |
|
45 | + array( '="=Pear"', NULL, NULL, NULL, NULL, NULL ) |
|
46 | + ); |
|
47 | 47 | |
48 | 48 | $worksheet->fromArray( $criteria, NULL, 'A1' ); |
49 | 49 | $worksheet->fromArray( $database, NULL, 'A4' ); |