@@ -47,30 +47,30 @@ |
||
47 | 47 | // Set document properties |
48 | 48 | echo date('H:i:s') , " Set document properties" , EOL; |
49 | 49 | $objPHPExcel->getProperties()->setCreator("Maarten Balliauw") |
50 | - ->setLastModifiedBy("Maarten Balliauw") |
|
51 | - ->setTitle("Office 2007 XLSX Test Document") |
|
52 | - ->setSubject("Office 2007 XLSX Test Document") |
|
53 | - ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") |
|
54 | - ->setKeywords("office 2007 openxml php") |
|
55 | - ->setCategory("Test result file"); |
|
50 | + ->setLastModifiedBy("Maarten Balliauw") |
|
51 | + ->setTitle("Office 2007 XLSX Test Document") |
|
52 | + ->setSubject("Office 2007 XLSX Test Document") |
|
53 | + ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") |
|
54 | + ->setKeywords("office 2007 openxml php") |
|
55 | + ->setCategory("Test result file"); |
|
56 | 56 | |
57 | 57 | |
58 | 58 | // Create a first sheet |
59 | 59 | echo date('H:i:s') , " Add data" , EOL; |
60 | 60 | $objPHPExcel->setActiveSheetIndex(0); |
61 | 61 | $objPHPExcel->getActiveSheet()->setCellValue('A1', "Cell B3 and B5 contain data validation...") |
62 | - ->setCellValue('A3', "Number:") |
|
63 | - ->setCellValue('B3', "10") |
|
64 | - ->setCellValue('A5', "List:") |
|
65 | - ->setCellValue('B5', "Item A") |
|
66 | - ->setCellValue('A7', "List #2:") |
|
67 | - ->setCellValue('B7', "Item #2") |
|
68 | - ->setCellValue('D2', "Item #1") |
|
69 | - ->setCellValue('D3', "Item #2") |
|
70 | - ->setCellValue('D4', "Item #3") |
|
71 | - ->setCellValue('D5', "Item #4") |
|
72 | - ->setCellValue('D6', "Item #5") |
|
73 | - ; |
|
62 | + ->setCellValue('A3', "Number:") |
|
63 | + ->setCellValue('B3', "10") |
|
64 | + ->setCellValue('A5', "List:") |
|
65 | + ->setCellValue('B5', "Item A") |
|
66 | + ->setCellValue('A7', "List #2:") |
|
67 | + ->setCellValue('B7', "Item #2") |
|
68 | + ->setCellValue('D2', "Item #1") |
|
69 | + ->setCellValue('D3', "Item #2") |
|
70 | + ->setCellValue('D4', "Item #3") |
|
71 | + ->setCellValue('D5', "Item #4") |
|
72 | + ->setCellValue('D6', "Item #5") |
|
73 | + ; |
|
74 | 74 | |
75 | 75 | |
76 | 76 | // Set data validation |
@@ -52,12 +52,12 @@ discard block |
||
52 | 52 | // Set document properties |
53 | 53 | echo date('H:i:s') , " Set properties" , EOL; |
54 | 54 | $objPHPExcel->getProperties()->setCreator("Maarten Balliauw") |
55 | - ->setLastModifiedBy("Maarten Balliauw") |
|
56 | - ->setTitle("Office 2007 XLSX Test Document") |
|
57 | - ->setSubject("Office 2007 XLSX Test Document") |
|
58 | - ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") |
|
59 | - ->setKeywords("office 2007 openxml php") |
|
60 | - ->setCategory("Test result file"); |
|
55 | + ->setLastModifiedBy("Maarten Balliauw") |
|
56 | + ->setTitle("Office 2007 XLSX Test Document") |
|
57 | + ->setSubject("Office 2007 XLSX Test Document") |
|
58 | + ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") |
|
59 | + ->setKeywords("office 2007 openxml php") |
|
60 | + ->setCategory("Test result file"); |
|
61 | 61 | |
62 | 62 | |
63 | 63 | // Create a first sheet |
@@ -79,8 +79,8 @@ discard block |
||
79 | 79 | // Set outline levels |
80 | 80 | echo date('H:i:s') , " Set outline levels" , EOL; |
81 | 81 | $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1) |
82 | - ->setVisible(false) |
|
83 | - ->setCollapsed(true); |
|
82 | + ->setVisible(false) |
|
83 | + ->setCollapsed(true); |
|
84 | 84 | |
85 | 85 | // Freeze panes |
86 | 86 | echo date('H:i:s') , " Freeze panes" , EOL; |
@@ -94,11 +94,11 @@ discard block |
||
94 | 94 | |
95 | 95 | // Add data |
96 | 96 | for ($i = 2; $i <= 5000; $i++) { |
97 | - $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i") |
|
98 | - ->setCellValue('B' . $i, "LName $i") |
|
99 | - ->setCellValue('C' . $i, "PhoneNo $i") |
|
100 | - ->setCellValue('D' . $i, "FaxNo $i") |
|
101 | - ->setCellValue('E' . $i, true); |
|
97 | + $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i") |
|
98 | + ->setCellValue('B' . $i, "LName $i") |
|
99 | + ->setCellValue('C' . $i, "PhoneNo $i") |
|
100 | + ->setCellValue('D' . $i, "FaxNo $i") |
|
101 | + ->setCellValue('E' . $i, true); |
|
102 | 102 | } |
103 | 103 | |
104 | 104 |
@@ -44,12 +44,12 @@ |
||
44 | 44 | // Set document properties |
45 | 45 | echo date('H:i:s') , " Set document properties" , EOL; |
46 | 46 | $objPHPExcel->getProperties()->setCreator("Maarten Balliauw") |
47 | - ->setLastModifiedBy("Maarten Balliauw") |
|
48 | - ->setTitle("PHPExcel Test Document") |
|
49 | - ->setSubject("PHPExcel Test Document") |
|
50 | - ->setDescription("Test document for PHPExcel, generated using PHP classes.") |
|
51 | - ->setKeywords("office PHPExcel php") |
|
52 | - ->setCategory("Test result file"); |
|
47 | + ->setLastModifiedBy("Maarten Balliauw") |
|
48 | + ->setTitle("PHPExcel Test Document") |
|
49 | + ->setSubject("PHPExcel Test Document") |
|
50 | + ->setDescription("Test document for PHPExcel, generated using PHP classes.") |
|
51 | + ->setKeywords("office PHPExcel php") |
|
52 | + ->setCategory("Test result file"); |
|
53 | 53 | |
54 | 54 | |
55 | 55 | // Add some data |
@@ -52,12 +52,12 @@ discard block |
||
52 | 52 | // Set document properties |
53 | 53 | echo date('H:i:s') , " Set properties" , EOL; |
54 | 54 | $objPHPExcel->getProperties()->setCreator("Maarten Balliauw") |
55 | - ->setLastModifiedBy("Maarten Balliauw") |
|
56 | - ->setTitle("Office 2007 XLSX Test Document") |
|
57 | - ->setSubject("Office 2007 XLSX Test Document") |
|
58 | - ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") |
|
59 | - ->setKeywords("office 2007 openxml php") |
|
60 | - ->setCategory("Test result file"); |
|
55 | + ->setLastModifiedBy("Maarten Balliauw") |
|
56 | + ->setTitle("Office 2007 XLSX Test Document") |
|
57 | + ->setSubject("Office 2007 XLSX Test Document") |
|
58 | + ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") |
|
59 | + ->setKeywords("office 2007 openxml php") |
|
60 | + ->setCategory("Test result file"); |
|
61 | 61 | |
62 | 62 | |
63 | 63 | // Create a first sheet |
@@ -79,8 +79,8 @@ discard block |
||
79 | 79 | // Set outline levels |
80 | 80 | echo date('H:i:s') , " Set outline levels" , EOL; |
81 | 81 | $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1) |
82 | - ->setVisible(false) |
|
83 | - ->setCollapsed(true); |
|
82 | + ->setVisible(false) |
|
83 | + ->setCollapsed(true); |
|
84 | 84 | |
85 | 85 | // Freeze panes |
86 | 86 | echo date('H:i:s') , " Freeze panes" , EOL; |
@@ -94,11 +94,11 @@ discard block |
||
94 | 94 | |
95 | 95 | // Add data |
96 | 96 | for ($i = 2; $i <= 5000; $i++) { |
97 | - $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i") |
|
98 | - ->setCellValue('B' . $i, "LName $i") |
|
99 | - ->setCellValue('C' . $i, "PhoneNo $i") |
|
100 | - ->setCellValue('D' . $i, "FaxNo $i") |
|
101 | - ->setCellValue('E' . $i, true); |
|
97 | + $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i") |
|
98 | + ->setCellValue('B' . $i, "LName $i") |
|
99 | + ->setCellValue('C' . $i, "PhoneNo $i") |
|
100 | + ->setCellValue('D' . $i, "FaxNo $i") |
|
101 | + ->setCellValue('E' . $i, true); |
|
102 | 102 | } |
103 | 103 | |
104 | 104 |
@@ -44,12 +44,12 @@ |
||
44 | 44 | // Set document properties |
45 | 45 | echo date('H:i:s') , " Set document properties" , EOL; |
46 | 46 | $objPHPExcel->getProperties()->setCreator("Maarten Balliauw") |
47 | - ->setLastModifiedBy("Maarten Balliauw") |
|
48 | - ->setTitle("PHPExcel Test Document") |
|
49 | - ->setSubject("PHPExcel Test Document") |
|
50 | - ->setDescription("Test document for PHPExcel, generated using PHP classes.") |
|
51 | - ->setKeywords("office PHPExcel php") |
|
52 | - ->setCategory("Test result file"); |
|
47 | + ->setLastModifiedBy("Maarten Balliauw") |
|
48 | + ->setTitle("PHPExcel Test Document") |
|
49 | + ->setSubject("PHPExcel Test Document") |
|
50 | + ->setDescription("Test document for PHPExcel, generated using PHP classes.") |
|
51 | + ->setKeywords("office PHPExcel php") |
|
52 | + ->setCategory("Test result file"); |
|
53 | 53 | |
54 | 54 | |
55 | 55 | // Add some data |
@@ -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,21 +91,21 @@ 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 |
|
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 | 106 | NULL, // plotDirection |
107 | - NULL, // smooth line |
|
108 | - \PHPExcel\Chart\DataSeries::STYLE_MARKER // plotStyle |
|
107 | + NULL, // smooth line |
|
108 | + \PHPExcel\Chart\DataSeries::STYLE_MARKER // plotStyle |
|
109 | 109 | ); |
110 | 110 | |
111 | 111 | // Set up a layout object for the Pie chart |
@@ -121,14 +121,14 @@ discard block |
||
121 | 121 | |
122 | 122 | // Create the chart |
123 | 123 | $chart = new \PHPExcel\Chart( |
124 | - 'chart1', // name |
|
125 | - $title, // title |
|
126 | - $legend, // legend |
|
127 | - $plotArea, // plotArea |
|
128 | - true, // plotVisibleOnly |
|
129 | - 0, // displayBlanksAs |
|
130 | - NULL, // xAxisLabel |
|
131 | - NULL // yAxisLabel - Radar charts don't have a Y-Axis |
|
124 | + 'chart1', // name |
|
125 | + $title, // title |
|
126 | + $legend, // legend |
|
127 | + $plotArea, // plotArea |
|
128 | + true, // plotVisibleOnly |
|
129 | + 0, // displayBlanksAs |
|
130 | + NULL, // xAxisLabel |
|
131 | + NULL // yAxisLabel - Radar charts don't have a Y-Axis |
|
132 | 132 | ); |
133 | 133 | |
134 | 134 | // Set the position where the chart should appear in the worksheet |
@@ -13,8 +13,8 @@ |
||
13 | 13 | ->disableOriginalConstructor() |
14 | 14 | ->getMock(); |
15 | 15 | $this->mockWorksheet->expects($this->any()) |
16 | - ->method('getHighestRow') |
|
17 | - ->will($this->returnValue(5)); |
|
16 | + ->method('getHighestRow') |
|
17 | + ->will($this->returnValue(5)); |
|
18 | 18 | } |
19 | 19 | |
20 | 20 |
@@ -18,11 +18,11 @@ |
||
18 | 18 | ->getMock(); |
19 | 19 | |
20 | 20 | $this->mockWorksheet->expects($this->any()) |
21 | - ->method('getHighestColumn') |
|
22 | - ->will($this->returnValue('E')); |
|
21 | + ->method('getHighestColumn') |
|
22 | + ->will($this->returnValue('E')); |
|
23 | 23 | $this->mockWorksheet->expects($this->any()) |
24 | - ->method('current') |
|
25 | - ->will($this->returnValue($this->mockColumn)); |
|
24 | + ->method('current') |
|
25 | + ->will($this->returnValue($this->mockColumn)); |
|
26 | 26 | } |
27 | 27 | |
28 | 28 |
@@ -18,11 +18,11 @@ |
||
18 | 18 | ->getMock(); |
19 | 19 | |
20 | 20 | $this->mockWorksheet->expects($this->any()) |
21 | - ->method('getHighestRow') |
|
22 | - ->will($this->returnValue(5)); |
|
21 | + ->method('getHighestRow') |
|
22 | + ->will($this->returnValue(5)); |
|
23 | 23 | $this->mockWorksheet->expects($this->any()) |
24 | - ->method('getCellByColumnAndRow') |
|
25 | - ->will($this->returnValue($this->mockCell)); |
|
24 | + ->method('getCellByColumnAndRow') |
|
25 | + ->will($this->returnValue($this->mockCell)); |
|
26 | 26 | } |
27 | 27 | |
28 | 28 |