@@ -39,19 +39,19 @@ |
||
39 | 39 | |
40 | 40 | // Check prerequisites |
41 | 41 | if (!file_exists("06largescale.xlsx")) { |
42 | - exit("Please run 06largescale.php first.\n"); |
|
42 | + exit("Please run 06largescale.php first.\n"); |
|
43 | 43 | } |
44 | 44 | |
45 | 45 | class MyReadFilter implements \PHPExcel\Reader\IReadFilter |
46 | 46 | { |
47 | - public function readCell($column, $row, $worksheetName = '') { |
|
48 | - // Read title row and rows 20 - 30 |
|
49 | - if ($row == 1 || ($row >= 20 && $row <= 30)) { |
|
50 | - return true; |
|
51 | - } |
|
47 | + public function readCell($column, $row, $worksheetName = '') { |
|
48 | + // Read title row and rows 20 - 30 |
|
49 | + if ($row == 1 || ($row >= 20 && $row <= 30)) { |
|
50 | + return true; |
|
51 | + } |
|
52 | 52 | |
53 | - return false; |
|
54 | - } |
|
53 | + return false; |
|
54 | + } |
|
55 | 55 | } |
56 | 56 | |
57 | 57 |
@@ -43,21 +43,21 @@ discard block |
||
43 | 43 | $objPHPExcel = new \PHPExcel\Spreadsheet(); |
44 | 44 | $objWorksheet = $objPHPExcel->getActiveSheet(); |
45 | 45 | $objWorksheet->fromArray( |
46 | - array( |
|
47 | - array('', 2010, 2011, 2012), |
|
48 | - array('Jan', 47, 45, 71), |
|
49 | - array('Feb', 56, 73, 86), |
|
50 | - array('Mar', 52, 61, 69), |
|
51 | - array('Apr', 40, 52, 60), |
|
52 | - array('May', 42, 55, 71), |
|
53 | - array('Jun', 58, 63, 76), |
|
54 | - array('Jul', 53, 61, 89), |
|
55 | - array('Aug', 46, 69, 85), |
|
56 | - array('Sep', 62, 75, 81), |
|
57 | - array('Oct', 51, 70, 96), |
|
58 | - array('Nov', 55, 66, 89), |
|
59 | - array('Dec', 68, 62, 0), |
|
60 | - ) |
|
46 | + array( |
|
47 | + array('', 2010, 2011, 2012), |
|
48 | + array('Jan', 47, 45, 71), |
|
49 | + array('Feb', 56, 73, 86), |
|
50 | + array('Mar', 52, 61, 69), |
|
51 | + array('Apr', 40, 52, 60), |
|
52 | + array('May', 42, 55, 71), |
|
53 | + array('Jun', 58, 63, 76), |
|
54 | + array('Jul', 53, 61, 89), |
|
55 | + array('Aug', 46, 69, 85), |
|
56 | + array('Sep', 62, 75, 81), |
|
57 | + array('Oct', 51, 70, 96), |
|
58 | + array('Nov', 55, 66, 89), |
|
59 | + array('Dec', 68, 62, 0), |
|
60 | + ) |
|
61 | 61 | ); |
62 | 62 | |
63 | 63 | |
@@ -69,8 +69,8 @@ discard block |
||
69 | 69 | // Data values |
70 | 70 | // Data Marker |
71 | 71 | $dataSeriesLabels = array( |
72 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011 |
|
73 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012 |
|
72 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011 |
|
73 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012 |
|
74 | 74 | ); |
75 | 75 | // Set the X-Axis Labels |
76 | 76 | // Datatype |
@@ -80,8 +80,8 @@ discard block |
||
80 | 80 | // Data values |
81 | 81 | // Data Marker |
82 | 82 | $xAxisTickValues = array( |
83 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12), // Jan to Dec |
|
84 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12), // Jan to Dec |
|
83 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12), // Jan to Dec |
|
84 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$13', NULL, 12), // Jan to Dec |
|
85 | 85 | ); |
86 | 86 | // Set the Data values for each data series we want to plot |
87 | 87 | // Datatype |
@@ -91,20 +91,20 @@ discard block |
||
91 | 91 | // Data values |
92 | 92 | // Data Marker |
93 | 93 | $dataSeriesValues = array( |
94 | - new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$13', NULL, 12), |
|
95 | - new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$13', NULL, 12), |
|
94 | + new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$13', NULL, 12), |
|
95 | + new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$13', NULL, 12), |
|
96 | 96 | ); |
97 | 97 | |
98 | 98 | // Build the dataseries |
99 | 99 | $series = new \PHPExcel\Chart\DataSeries( |
100 | - \PHPExcel\Chart\DataSeries::TYPE_RADARCHART, // plotType |
|
101 | - NULL, // plotGrouping (Radar charts don't have any grouping) |
|
102 | - range(0, count($dataSeriesValues)-1), // plotOrder |
|
103 | - $dataSeriesLabels, // plotLabel |
|
104 | - $xAxisTickValues, // plotCategory |
|
105 | - $dataSeriesValues, // plotValues |
|
106 | - NULL, // smooth line |
|
107 | - \PHPExcel\Chart\DataSeries::STYLE_MARKER // plotStyle |
|
100 | + \PHPExcel\Chart\DataSeries::TYPE_RADARCHART, // plotType |
|
101 | + NULL, // plotGrouping (Radar charts don't have any grouping) |
|
102 | + range(0, count($dataSeriesValues)-1), // plotOrder |
|
103 | + $dataSeriesLabels, // plotLabel |
|
104 | + $xAxisTickValues, // plotCategory |
|
105 | + $dataSeriesValues, // plotValues |
|
106 | + NULL, // smooth line |
|
107 | + \PHPExcel\Chart\DataSeries::STYLE_MARKER // plotStyle |
|
108 | 108 | ); |
109 | 109 | |
110 | 110 | // Set up a layout object for the Pie chart |
@@ -120,14 +120,14 @@ discard block |
||
120 | 120 | |
121 | 121 | // Create the chart |
122 | 122 | $chart = new \PHPExcel\Chart( |
123 | - 'chart1', // name |
|
124 | - $title, // title |
|
125 | - $legend, // legend |
|
126 | - $plotArea, // plotArea |
|
127 | - true, // plotVisibleOnly |
|
128 | - 0, // displayBlanksAs |
|
129 | - NULL, // xAxisLabel |
|
130 | - NULL // yAxisLabel - Radar charts don't have a Y-Axis |
|
123 | + 'chart1', // name |
|
124 | + $title, // title |
|
125 | + $legend, // legend |
|
126 | + $plotArea, // plotArea |
|
127 | + true, // plotVisibleOnly |
|
128 | + 0, // displayBlanksAs |
|
129 | + NULL, // xAxisLabel |
|
130 | + NULL // yAxisLabel - Radar charts don't have a Y-Axis |
|
131 | 131 | ); |
132 | 132 | |
133 | 133 | // Set the position where the chart should appear in the worksheet |
@@ -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' ); |
@@ -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' ); |