PHPOffice /
PhpSpreadsheet
@@ -52,142 +52,142 @@ discard block |
||
| 52 | 52 | // Add some data, we will use some formulas here |
| 53 | 53 | echo date('H:i:s') , " Add some data and formulas" , EOL; |
| 54 | 54 | $objPHPExcel->getActiveSheet()->setCellValue('A14', 'Count:') |
| 55 | - ->setCellValue('A15', 'Sum:') |
|
| 56 | - ->setCellValue('A16', 'Max:') |
|
| 57 | - ->setCellValue('A17', 'Min:') |
|
| 58 | - ->setCellValue('A18', 'Average:') |
|
| 59 | - ->setCellValue('A19', 'Median:') |
|
| 60 | - ->setCellValue('A20', 'Mode:'); |
|
| 55 | + ->setCellValue('A15', 'Sum:') |
|
| 56 | + ->setCellValue('A16', 'Max:') |
|
| 57 | + ->setCellValue('A17', 'Min:') |
|
| 58 | + ->setCellValue('A18', 'Average:') |
|
| 59 | + ->setCellValue('A19', 'Median:') |
|
| 60 | + ->setCellValue('A20', 'Mode:'); |
|
| 61 | 61 | |
| 62 | 62 | $objPHPExcel->getActiveSheet()->setCellValue('A22', 'CountA:') |
| 63 | - ->setCellValue('A23', 'MaxA:') |
|
| 64 | - ->setCellValue('A24', 'MinA:'); |
|
| 63 | + ->setCellValue('A23', 'MaxA:') |
|
| 64 | + ->setCellValue('A24', 'MinA:'); |
|
| 65 | 65 | |
| 66 | 66 | $objPHPExcel->getActiveSheet()->setCellValue('A26', 'StDev:') |
| 67 | - ->setCellValue('A27', 'StDevA:') |
|
| 68 | - ->setCellValue('A28', 'StDevP:') |
|
| 69 | - ->setCellValue('A29', 'StDevPA:'); |
|
| 67 | + ->setCellValue('A27', 'StDevA:') |
|
| 68 | + ->setCellValue('A28', 'StDevP:') |
|
| 69 | + ->setCellValue('A29', 'StDevPA:'); |
|
| 70 | 70 | |
| 71 | 71 | $objPHPExcel->getActiveSheet()->setCellValue('A31', 'DevSq:') |
| 72 | - ->setCellValue('A32', 'Var:') |
|
| 73 | - ->setCellValue('A33', 'VarA:') |
|
| 74 | - ->setCellValue('A34', 'VarP:') |
|
| 75 | - ->setCellValue('A35', 'VarPA:'); |
|
| 72 | + ->setCellValue('A32', 'Var:') |
|
| 73 | + ->setCellValue('A33', 'VarA:') |
|
| 74 | + ->setCellValue('A34', 'VarP:') |
|
| 75 | + ->setCellValue('A35', 'VarPA:'); |
|
| 76 | 76 | |
| 77 | 77 | $objPHPExcel->getActiveSheet()->setCellValue('A37', 'Date:'); |
| 78 | 78 | |
| 79 | 79 | |
| 80 | 80 | $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Range 1') |
| 81 | - ->setCellValue('B2', 2) |
|
| 82 | - ->setCellValue('B3', 8) |
|
| 83 | - ->setCellValue('B4', 10) |
|
| 84 | - ->setCellValue('B5', True) |
|
| 85 | - ->setCellValue('B6', False) |
|
| 86 | - ->setCellValue('B7', 'Text String') |
|
| 87 | - ->setCellValue('B9', '22') |
|
| 88 | - ->setCellValue('B10', 4) |
|
| 89 | - ->setCellValue('B11', 6) |
|
| 90 | - ->setCellValue('B12', 12); |
|
| 81 | + ->setCellValue('B2', 2) |
|
| 82 | + ->setCellValue('B3', 8) |
|
| 83 | + ->setCellValue('B4', 10) |
|
| 84 | + ->setCellValue('B5', True) |
|
| 85 | + ->setCellValue('B6', False) |
|
| 86 | + ->setCellValue('B7', 'Text String') |
|
| 87 | + ->setCellValue('B9', '22') |
|
| 88 | + ->setCellValue('B10', 4) |
|
| 89 | + ->setCellValue('B11', 6) |
|
| 90 | + ->setCellValue('B12', 12); |
|
| 91 | 91 | |
| 92 | 92 | $objPHPExcel->getActiveSheet()->setCellValue('B14', '=COUNT(B2:B12)') |
| 93 | - ->setCellValue('B15', '=SUM(B2:B12)') |
|
| 94 | - ->setCellValue('B16', '=MAX(B2:B12)') |
|
| 95 | - ->setCellValue('B17', '=MIN(B2:B12)') |
|
| 96 | - ->setCellValue('B18', '=AVERAGE(B2:B12)') |
|
| 97 | - ->setCellValue('B19', '=MEDIAN(B2:B12)') |
|
| 98 | - ->setCellValue('B20', '=MODE(B2:B12)'); |
|
| 93 | + ->setCellValue('B15', '=SUM(B2:B12)') |
|
| 94 | + ->setCellValue('B16', '=MAX(B2:B12)') |
|
| 95 | + ->setCellValue('B17', '=MIN(B2:B12)') |
|
| 96 | + ->setCellValue('B18', '=AVERAGE(B2:B12)') |
|
| 97 | + ->setCellValue('B19', '=MEDIAN(B2:B12)') |
|
| 98 | + ->setCellValue('B20', '=MODE(B2:B12)'); |
|
| 99 | 99 | |
| 100 | 100 | $objPHPExcel->getActiveSheet()->setCellValue('B22', '=COUNTA(B2:B12)') |
| 101 | - ->setCellValue('B23', '=MAXA(B2:B12)') |
|
| 102 | - ->setCellValue('B24', '=MINA(B2:B12)'); |
|
| 101 | + ->setCellValue('B23', '=MAXA(B2:B12)') |
|
| 102 | + ->setCellValue('B24', '=MINA(B2:B12)'); |
|
| 103 | 103 | |
| 104 | 104 | $objPHPExcel->getActiveSheet()->setCellValue('B26', '=STDEV(B2:B12)') |
| 105 | - ->setCellValue('B27', '=STDEVA(B2:B12)') |
|
| 106 | - ->setCellValue('B28', '=STDEVP(B2:B12)') |
|
| 107 | - ->setCellValue('B29', '=STDEVPA(B2:B12)'); |
|
| 105 | + ->setCellValue('B27', '=STDEVA(B2:B12)') |
|
| 106 | + ->setCellValue('B28', '=STDEVP(B2:B12)') |
|
| 107 | + ->setCellValue('B29', '=STDEVPA(B2:B12)'); |
|
| 108 | 108 | |
| 109 | 109 | $objPHPExcel->getActiveSheet()->setCellValue('B31', '=DEVSQ(B2:B12)') |
| 110 | - ->setCellValue('B32', '=VAR(B2:B12)') |
|
| 111 | - ->setCellValue('B33', '=VARA(B2:B12)') |
|
| 112 | - ->setCellValue('B34', '=VARP(B2:B12)') |
|
| 113 | - ->setCellValue('B35', '=VARPA(B2:B12)'); |
|
| 110 | + ->setCellValue('B32', '=VAR(B2:B12)') |
|
| 111 | + ->setCellValue('B33', '=VARA(B2:B12)') |
|
| 112 | + ->setCellValue('B34', '=VARP(B2:B12)') |
|
| 113 | + ->setCellValue('B35', '=VARPA(B2:B12)'); |
|
| 114 | 114 | |
| 115 | 115 | $objPHPExcel->getActiveSheet()->setCellValue('B37', '=DATE(2007, 12, 21)') |
| 116 | - ->setCellValue('B38', '=DATEDIF( DATE(2007, 12, 21), DATE(2007, 12, 22), "D" )') |
|
| 117 | - ->setCellValue('B39', '=DATEVALUE("01-Feb-2006 10:06 AM")') |
|
| 118 | - ->setCellValue('B40', '=DAY( DATE(2006, 1, 2) )') |
|
| 119 | - ->setCellValue('B41', '=DAYS360( DATE(2002, 2, 3), DATE(2005, 5, 31) )'); |
|
| 116 | + ->setCellValue('B38', '=DATEDIF( DATE(2007, 12, 21), DATE(2007, 12, 22), "D" )') |
|
| 117 | + ->setCellValue('B39', '=DATEVALUE("01-Feb-2006 10:06 AM")') |
|
| 118 | + ->setCellValue('B40', '=DAY( DATE(2006, 1, 2) )') |
|
| 119 | + ->setCellValue('B41', '=DAYS360( DATE(2002, 2, 3), DATE(2005, 5, 31) )'); |
|
| 120 | 120 | |
| 121 | 121 | |
| 122 | 122 | $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Range 2') |
| 123 | - ->setCellValue('C2', 1) |
|
| 124 | - ->setCellValue('C3', 2) |
|
| 125 | - ->setCellValue('C4', 2) |
|
| 126 | - ->setCellValue('C5', 3) |
|
| 127 | - ->setCellValue('C6', 3) |
|
| 128 | - ->setCellValue('C7', 3) |
|
| 129 | - ->setCellValue('C8', '0') |
|
| 130 | - ->setCellValue('C9', 4) |
|
| 131 | - ->setCellValue('C10', 4) |
|
| 132 | - ->setCellValue('C11', 4) |
|
| 133 | - ->setCellValue('C12', 4); |
|
| 123 | + ->setCellValue('C2', 1) |
|
| 124 | + ->setCellValue('C3', 2) |
|
| 125 | + ->setCellValue('C4', 2) |
|
| 126 | + ->setCellValue('C5', 3) |
|
| 127 | + ->setCellValue('C6', 3) |
|
| 128 | + ->setCellValue('C7', 3) |
|
| 129 | + ->setCellValue('C8', '0') |
|
| 130 | + ->setCellValue('C9', 4) |
|
| 131 | + ->setCellValue('C10', 4) |
|
| 132 | + ->setCellValue('C11', 4) |
|
| 133 | + ->setCellValue('C12', 4); |
|
| 134 | 134 | |
| 135 | 135 | $objPHPExcel->getActiveSheet()->setCellValue('C14', '=COUNT(C2:C12)') |
| 136 | - ->setCellValue('C15', '=SUM(C2:C12)') |
|
| 137 | - ->setCellValue('C16', '=MAX(C2:C12)') |
|
| 138 | - ->setCellValue('C17', '=MIN(C2:C12)') |
|
| 139 | - ->setCellValue('C18', '=AVERAGE(C2:C12)') |
|
| 140 | - ->setCellValue('C19', '=MEDIAN(C2:C12)') |
|
| 141 | - ->setCellValue('C20', '=MODE(C2:C12)'); |
|
| 136 | + ->setCellValue('C15', '=SUM(C2:C12)') |
|
| 137 | + ->setCellValue('C16', '=MAX(C2:C12)') |
|
| 138 | + ->setCellValue('C17', '=MIN(C2:C12)') |
|
| 139 | + ->setCellValue('C18', '=AVERAGE(C2:C12)') |
|
| 140 | + ->setCellValue('C19', '=MEDIAN(C2:C12)') |
|
| 141 | + ->setCellValue('C20', '=MODE(C2:C12)'); |
|
| 142 | 142 | |
| 143 | 143 | $objPHPExcel->getActiveSheet()->setCellValue('C22', '=COUNTA(C2:C12)') |
| 144 | - ->setCellValue('C23', '=MAXA(C2:C12)') |
|
| 145 | - ->setCellValue('C24', '=MINA(C2:C12)'); |
|
| 144 | + ->setCellValue('C23', '=MAXA(C2:C12)') |
|
| 145 | + ->setCellValue('C24', '=MINA(C2:C12)'); |
|
| 146 | 146 | |
| 147 | 147 | $objPHPExcel->getActiveSheet()->setCellValue('C26', '=STDEV(C2:C12)') |
| 148 | - ->setCellValue('C27', '=STDEVA(C2:C12)') |
|
| 149 | - ->setCellValue('C28', '=STDEVP(C2:C12)') |
|
| 150 | - ->setCellValue('C29', '=STDEVPA(C2:C12)'); |
|
| 148 | + ->setCellValue('C27', '=STDEVA(C2:C12)') |
|
| 149 | + ->setCellValue('C28', '=STDEVP(C2:C12)') |
|
| 150 | + ->setCellValue('C29', '=STDEVPA(C2:C12)'); |
|
| 151 | 151 | |
| 152 | 152 | $objPHPExcel->getActiveSheet()->setCellValue('C31', '=DEVSQ(C2:C12)') |
| 153 | - ->setCellValue('C32', '=VAR(C2:C12)') |
|
| 154 | - ->setCellValue('C33', '=VARA(C2:C12)') |
|
| 155 | - ->setCellValue('C34', '=VARP(C2:C12)') |
|
| 156 | - ->setCellValue('C35', '=VARPA(C2:C12)'); |
|
| 153 | + ->setCellValue('C32', '=VAR(C2:C12)') |
|
| 154 | + ->setCellValue('C33', '=VARA(C2:C12)') |
|
| 155 | + ->setCellValue('C34', '=VARP(C2:C12)') |
|
| 156 | + ->setCellValue('C35', '=VARPA(C2:C12)'); |
|
| 157 | 157 | |
| 158 | 158 | |
| 159 | 159 | $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Range 3') |
| 160 | - ->setCellValue('D2', 2) |
|
| 161 | - ->setCellValue('D3', 3) |
|
| 162 | - ->setCellValue('D4', 4); |
|
| 160 | + ->setCellValue('D2', 2) |
|
| 161 | + ->setCellValue('D3', 3) |
|
| 162 | + ->setCellValue('D4', 4); |
|
| 163 | 163 | |
| 164 | 164 | $objPHPExcel->getActiveSheet()->setCellValue('D14', '=((D2 * D3) + D4) & " should be 10"'); |
| 165 | 165 | |
| 166 | 166 | $objPHPExcel->getActiveSheet()->setCellValue('E12', 'Other functions') |
| 167 | - ->setCellValue('E14', '=PI()') |
|
| 168 | - ->setCellValue('E15', '=RAND()') |
|
| 169 | - ->setCellValue('E16', '=RANDBETWEEN(5, 10)'); |
|
| 167 | + ->setCellValue('E14', '=PI()') |
|
| 168 | + ->setCellValue('E15', '=RAND()') |
|
| 169 | + ->setCellValue('E16', '=RANDBETWEEN(5, 10)'); |
|
| 170 | 170 | |
| 171 | 171 | $objPHPExcel->getActiveSheet()->setCellValue('E17', 'Count of both ranges:') |
| 172 | - ->setCellValue('F17', '=COUNT(B2:C12)'); |
|
| 172 | + ->setCellValue('F17', '=COUNT(B2:C12)'); |
|
| 173 | 173 | |
| 174 | 174 | $objPHPExcel->getActiveSheet()->setCellValue('E18', 'Total of both ranges:') |
| 175 | - ->setCellValue('F18', '=SUM(B2:C12)'); |
|
| 175 | + ->setCellValue('F18', '=SUM(B2:C12)'); |
|
| 176 | 176 | |
| 177 | 177 | $objPHPExcel->getActiveSheet()->setCellValue('E19', 'Maximum of both ranges:') |
| 178 | - ->setCellValue('F19', '=MAX(B2:C12)'); |
|
| 178 | + ->setCellValue('F19', '=MAX(B2:C12)'); |
|
| 179 | 179 | |
| 180 | 180 | $objPHPExcel->getActiveSheet()->setCellValue('E20', 'Minimum of both ranges:') |
| 181 | - ->setCellValue('F20', '=MIN(B2:C12)'); |
|
| 181 | + ->setCellValue('F20', '=MIN(B2:C12)'); |
|
| 182 | 182 | |
| 183 | 183 | $objPHPExcel->getActiveSheet()->setCellValue('E21', 'Average of both ranges:') |
| 184 | - ->setCellValue('F21', '=AVERAGE(B2:C12)'); |
|
| 184 | + ->setCellValue('F21', '=AVERAGE(B2:C12)'); |
|
| 185 | 185 | |
| 186 | 186 | $objPHPExcel->getActiveSheet()->setCellValue('E22', 'Median of both ranges:') |
| 187 | - ->setCellValue('F22', '=MEDIAN(B2:C12)'); |
|
| 187 | + ->setCellValue('F22', '=MEDIAN(B2:C12)'); |
|
| 188 | 188 | |
| 189 | 189 | $objPHPExcel->getActiveSheet()->setCellValue('E23', 'Mode of both ranges:') |
| 190 | - ->setCellValue('F23', '=MODE(B2:C12)'); |
|
| 190 | + ->setCellValue('F23', '=MODE(B2:C12)'); |
|
| 191 | 191 | |
| 192 | 192 | |
| 193 | 193 | // Calculated data |
@@ -195,9 +195,9 @@ discard block |
||
| 195 | 195 | for ($col = 'B'; $col != 'G'; ++$col) { |
| 196 | 196 | for($row = 14; $row <= 41; ++$row) { |
| 197 | 197 | if ((!is_null($formula = $objPHPExcel->getActiveSheet()->getCell($col.$row)->getValue())) && |
| 198 | - ($formula[0] == '=')) { |
|
| 198 | + ($formula[0] == '=')) { |
|
| 199 | 199 | echo 'Value of ' , $col , $row , ' [' , $formula , ']: ' , |
| 200 | - $objPHPExcel->getActiveSheet()->getCell($col.$row)->getCalculatedValue() . EOL; |
|
| 200 | + $objPHPExcel->getActiveSheet()->getCell($col.$row)->getCalculatedValue() . EOL; |
|
| 201 | 201 | } |
| 202 | 202 | } |
| 203 | 203 | } |
@@ -32,7 +32,7 @@ discard block |
||
| 32 | 32 | date_default_timezone_set('Europe/London'); |
| 33 | 33 | |
| 34 | 34 | if (PHP_SAPI == 'cli') |
| 35 | - die('This example should only be run from a Web Browser'); |
|
| 35 | + die('This example should only be run from a Web Browser'); |
|
| 36 | 36 | |
| 37 | 37 | /** Include PHPExcel */ |
| 38 | 38 | require_once dirname(__FILE__) . '/../src/Bootstrap.php'; |
@@ -43,12 +43,12 @@ discard block |
||
| 43 | 43 | |
| 44 | 44 | // Set document properties |
| 45 | 45 | $objPHPExcel->getProperties()->setCreator("Maarten Balliauw") |
| 46 | - ->setLastModifiedBy("Maarten Balliauw") |
|
| 47 | - ->setTitle("Office 2007 XLSX Test Document") |
|
| 48 | - ->setSubject("Office 2007 XLSX Test Document") |
|
| 49 | - ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") |
|
| 50 | - ->setKeywords("office 2007 openxml php") |
|
| 51 | - ->setCategory("Test result file"); |
|
| 46 | + ->setLastModifiedBy("Maarten Balliauw") |
|
| 47 | + ->setTitle("Office 2007 XLSX Test Document") |
|
| 48 | + ->setSubject("Office 2007 XLSX Test Document") |
|
| 49 | + ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") |
|
| 50 | + ->setKeywords("office 2007 openxml php") |
|
| 51 | + ->setCategory("Test result file"); |
|
| 52 | 52 | |
| 53 | 53 | |
| 54 | 54 | // Add some data |
@@ -39,7 +39,7 @@ discard block |
||
| 39 | 39 | |
| 40 | 40 | $cacheMethod = \PHPExcel\CachedObjectStorageFactory::CACHE_IN_MEMORY_GZIP; |
| 41 | 41 | if (!\PHPExcel\Settings::setCacheStorageMethod($cacheMethod)) { |
| 42 | - die($cacheMethod . " caching method is not available" . EOL); |
|
| 42 | + die($cacheMethod . " caching method is not available" . EOL); |
|
| 43 | 43 | } |
| 44 | 44 | echo date('H:i:s') , " Enable Cell Caching using " , $cacheMethod , " method" , EOL; |
| 45 | 45 | |
@@ -51,12 +51,12 @@ discard block |
||
| 51 | 51 | // Set document properties |
| 52 | 52 | echo date('H:i:s') , " Set properties" , EOL; |
| 53 | 53 | $objPHPExcel->getProperties()->setCreator("Maarten Balliauw") |
| 54 | - ->setLastModifiedBy("Maarten Balliauw") |
|
| 55 | - ->setTitle("Office 2007 XLSX Test Document") |
|
| 56 | - ->setSubject("Office 2007 XLSX Test Document") |
|
| 57 | - ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") |
|
| 58 | - ->setKeywords("office 2007 openxml php") |
|
| 59 | - ->setCategory("Test result file"); |
|
| 54 | + ->setLastModifiedBy("Maarten Balliauw") |
|
| 55 | + ->setTitle("Office 2007 XLSX Test Document") |
|
| 56 | + ->setSubject("Office 2007 XLSX Test Document") |
|
| 57 | + ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") |
|
| 58 | + ->setKeywords("office 2007 openxml php") |
|
| 59 | + ->setCategory("Test result file"); |
|
| 60 | 60 | |
| 61 | 61 | |
| 62 | 62 | // Create a first sheet |
@@ -78,8 +78,8 @@ discard block |
||
| 78 | 78 | // Set outline levels |
| 79 | 79 | echo date('H:i:s') , " Set outline levels" , EOL; |
| 80 | 80 | $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1) |
| 81 | - ->setVisible(false) |
|
| 82 | - ->setCollapsed(true); |
|
| 81 | + ->setVisible(false) |
|
| 82 | + ->setCollapsed(true); |
|
| 83 | 83 | |
| 84 | 84 | // Freeze panes |
| 85 | 85 | echo date('H:i:s') , " Freeze panes" , EOL; |
@@ -93,11 +93,11 @@ discard block |
||
| 93 | 93 | |
| 94 | 94 | // Add data |
| 95 | 95 | for ($i = 2; $i <= 5000; $i++) { |
| 96 | - $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i") |
|
| 97 | - ->setCellValue('B' . $i, "LName $i") |
|
| 98 | - ->setCellValue('C' . $i, "PhoneNo $i") |
|
| 99 | - ->setCellValue('D' . $i, "FaxNo $i") |
|
| 100 | - ->setCellValue('E' . $i, true); |
|
| 96 | + $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i") |
|
| 97 | + ->setCellValue('B' . $i, "LName $i") |
|
| 98 | + ->setCellValue('C' . $i, "PhoneNo $i") |
|
| 99 | + ->setCellValue('D' . $i, "FaxNo $i") |
|
| 100 | + ->setCellValue('E' . $i, true); |
|
| 101 | 101 | } |
| 102 | 102 | |
| 103 | 103 | |
@@ -43,13 +43,13 @@ 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('Q1', 12, 15, 21), |
|
| 49 | - array('Q2', 56, 73, 86), |
|
| 50 | - array('Q3', 52, 61, 69), |
|
| 51 | - array('Q4', 30, 32, 0), |
|
| 52 | - ) |
|
| 46 | + array( |
|
| 47 | + array('', 2010, 2011, 2012), |
|
| 48 | + array('Q1', 12, 15, 21), |
|
| 49 | + array('Q2', 56, 73, 86), |
|
| 50 | + array('Q3', 52, 61, 69), |
|
| 51 | + array('Q4', 30, 32, 0), |
|
| 52 | + ) |
|
| 53 | 53 | ); |
| 54 | 54 | |
| 55 | 55 | // Set the Labels for each data series we want to plot |
@@ -60,9 +60,9 @@ discard block |
||
| 60 | 60 | // Data values |
| 61 | 61 | // Data Marker |
| 62 | 62 | $dataSeriesLabels = array( |
| 63 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), // 2010 |
|
| 64 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011 |
|
| 65 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012 |
|
| 63 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), // 2010 |
|
| 64 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011 |
|
| 65 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012 |
|
| 66 | 66 | ); |
| 67 | 67 | // Set the X-Axis Labels |
| 68 | 68 | // Datatype |
@@ -72,7 +72,7 @@ discard block |
||
| 72 | 72 | // Data values |
| 73 | 73 | // Data Marker |
| 74 | 74 | $xAxisTickValues = array( |
| 75 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4 |
|
| 75 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4 |
|
| 76 | 76 | ); |
| 77 | 77 | // Set the Data values for each data series we want to plot |
| 78 | 78 | // Datatype |
@@ -82,19 +82,19 @@ discard block |
||
| 82 | 82 | // Data values |
| 83 | 83 | // Data Marker |
| 84 | 84 | $dataSeriesValues = array( |
| 85 | - new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4), |
|
| 86 | - new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4), |
|
| 87 | - new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4), |
|
| 85 | + new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4), |
|
| 86 | + new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4), |
|
| 87 | + new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4), |
|
| 88 | 88 | ); |
| 89 | 89 | |
| 90 | 90 | // Build the dataseries |
| 91 | 91 | $series = new \PHPExcel\Chart\DataSeries( |
| 92 | - \PHPExcel\Chart\DataSeries::TYPE_AREACHART, // plotType |
|
| 93 | - \PHPExcel\Chart\DataSeries::GROUPING_PERCENT_STACKED, // plotGrouping |
|
| 94 | - range(0, count($dataSeriesValues)-1), // plotOrder |
|
| 95 | - $dataSeriesLabels, // plotLabel |
|
| 96 | - $xAxisTickValues, // plotCategory |
|
| 97 | - $dataSeriesValues // plotValues |
|
| 92 | + \PHPExcel\Chart\DataSeries::TYPE_AREACHART, // plotType |
|
| 93 | + \PHPExcel\Chart\DataSeries::GROUPING_PERCENT_STACKED, // plotGrouping |
|
| 94 | + range(0, count($dataSeriesValues)-1), // plotOrder |
|
| 95 | + $dataSeriesLabels, // plotLabel |
|
| 96 | + $xAxisTickValues, // plotCategory |
|
| 97 | + $dataSeriesValues // plotValues |
|
| 98 | 98 | ); |
| 99 | 99 | |
| 100 | 100 | // Set the series in the plot area |
@@ -108,14 +108,14 @@ discard block |
||
| 108 | 108 | |
| 109 | 109 | // Create the chart |
| 110 | 110 | $chart = new \PHPExcel\Chart( |
| 111 | - 'chart1', // name |
|
| 112 | - $title, // title |
|
| 113 | - $legend, // legend |
|
| 114 | - $plotArea, // plotArea |
|
| 115 | - true, // plotVisibleOnly |
|
| 116 | - 0, // displayBlanksAs |
|
| 117 | - NULL, // xAxisLabel |
|
| 118 | - $yAxisLabel // yAxisLabel |
|
| 111 | + 'chart1', // name |
|
| 112 | + $title, // title |
|
| 113 | + $legend, // legend |
|
| 114 | + $plotArea, // plotArea |
|
| 115 | + true, // plotVisibleOnly |
|
| 116 | + 0, // displayBlanksAs |
|
| 117 | + NULL, // xAxisLabel |
|
| 118 | + $yAxisLabel // yAxisLabel |
|
| 119 | 119 | ); |
| 120 | 120 | |
| 121 | 121 | // Set the position where the chart should appear in the worksheet |
@@ -77,23 +77,23 @@ |
||
| 77 | 77 | // Export to PDF (.pdf) |
| 78 | 78 | echo date('H:i:s') , " Write to PDF format" , EOL; |
| 79 | 79 | try { |
| 80 | - if (!\PHPExcel\Settings::setPdfRenderer( |
|
| 81 | - $rendererName, |
|
| 82 | - $rendererLibraryPath |
|
| 83 | - )) { |
|
| 84 | - echo ( |
|
| 85 | - 'NOTICE: Please set the $rendererName and $rendererLibraryPath values' . |
|
| 86 | - EOL . |
|
| 87 | - 'at the top of this script as appropriate for your directory structure' . |
|
| 88 | - EOL |
|
| 89 | - ); |
|
| 90 | - } else { |
|
| 91 | - $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF'); |
|
| 92 | - $objWriter->save(str_replace('.php', '.pdf', __FILE__)); |
|
| 93 | - echo date('H:i:s') , " File written to " , str_replace('.php', '.pdf', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL; |
|
| 94 | - } |
|
| 80 | + if (!\PHPExcel\Settings::setPdfRenderer( |
|
| 81 | + $rendererName, |
|
| 82 | + $rendererLibraryPath |
|
| 83 | + )) { |
|
| 84 | + echo ( |
|
| 85 | + 'NOTICE: Please set the $rendererName and $rendererLibraryPath values' . |
|
| 86 | + EOL . |
|
| 87 | + 'at the top of this script as appropriate for your directory structure' . |
|
| 88 | + EOL |
|
| 89 | + ); |
|
| 90 | + } else { |
|
| 91 | + $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF'); |
|
| 92 | + $objWriter->save(str_replace('.php', '.pdf', __FILE__)); |
|
| 93 | + echo date('H:i:s') , " File written to " , str_replace('.php', '.pdf', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL; |
|
| 94 | + } |
|
| 95 | 95 | } catch (Exception $e) { |
| 96 | - echo date('H:i:s') , ' EXCEPTION: ', $e->getMessage() , EOL; |
|
| 96 | + echo date('H:i:s') , ' EXCEPTION: ', $e->getMessage() , EOL; |
|
| 97 | 97 | } |
| 98 | 98 | |
| 99 | 99 | // Remove first two rows with field headers before exporting to CSV |
@@ -38,7 +38,7 @@ |
||
| 38 | 38 | |
| 39 | 39 | |
| 40 | 40 | if (!file_exists("05featuredemo.xlsx")) { |
| 41 | - exit("Please run 05featuredemo.php first." . EOL); |
|
| 41 | + exit("Please run 05featuredemo.php first." . EOL); |
|
| 42 | 42 | } |
| 43 | 43 | |
| 44 | 44 | // Use PCLZip rather than ZipArchive to read the Excel2007 OfficeOpenXML file |
@@ -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 | |
@@ -43,13 +43,13 @@ 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('Q1', 12, 15, 21), |
|
| 49 | - array('Q2', 56, 73, 86), |
|
| 50 | - array('Q3', 52, 61, 69), |
|
| 51 | - array('Q4', 30, 32, 0), |
|
| 52 | - ) |
|
| 46 | + array( |
|
| 47 | + array('', 2010, 2011, 2012), |
|
| 48 | + array('Q1', 12, 15, 21), |
|
| 49 | + array('Q2', 56, 73, 86), |
|
| 50 | + array('Q3', 52, 61, 69), |
|
| 51 | + array('Q4', 30, 32, 0), |
|
| 52 | + ) |
|
| 53 | 53 | ); |
| 54 | 54 | |
| 55 | 55 | // Set the Labels for each data series we want to plot |
@@ -60,9 +60,9 @@ discard block |
||
| 60 | 60 | // Data values |
| 61 | 61 | // Data Marker |
| 62 | 62 | $dataSeriesLabels = array( |
| 63 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), // 2010 |
|
| 64 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011 |
|
| 65 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012 |
|
| 63 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), // 2010 |
|
| 64 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011 |
|
| 65 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012 |
|
| 66 | 66 | ); |
| 67 | 67 | // Set the X-Axis Labels |
| 68 | 68 | // Datatype |
@@ -72,7 +72,7 @@ discard block |
||
| 72 | 72 | // Data values |
| 73 | 73 | // Data Marker |
| 74 | 74 | $xAxisTickValues = array( |
| 75 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4 |
|
| 75 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4 |
|
| 76 | 76 | ); |
| 77 | 77 | // Set the Data values for each data series we want to plot |
| 78 | 78 | // Datatype |
@@ -82,19 +82,19 @@ discard block |
||
| 82 | 82 | // Data values |
| 83 | 83 | // Data Marker |
| 84 | 84 | $dataSeriesValues = array( |
| 85 | - new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4), |
|
| 86 | - new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4), |
|
| 87 | - new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4), |
|
| 85 | + new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4), |
|
| 86 | + new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4), |
|
| 87 | + new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4), |
|
| 88 | 88 | ); |
| 89 | 89 | |
| 90 | 90 | // Build the dataseries |
| 91 | 91 | $series = new \PHPExcel\Chart\DataSeries( |
| 92 | - \PHPExcel\Chart\DataSeries::TYPE_BARCHART, // plotType |
|
| 93 | - \PHPExcel\Chart\DataSeries::GROUPING_CLUSTERED, // plotGrouping |
|
| 94 | - range(0, count($dataSeriesValues)-1), // plotOrder |
|
| 95 | - $dataSeriesLabels, // plotLabel |
|
| 96 | - $xAxisTickValues, // plotCategory |
|
| 97 | - $dataSeriesValues // plotValues |
|
| 92 | + \PHPExcel\Chart\DataSeries::TYPE_BARCHART, // plotType |
|
| 93 | + \PHPExcel\Chart\DataSeries::GROUPING_CLUSTERED, // plotGrouping |
|
| 94 | + range(0, count($dataSeriesValues)-1), // plotOrder |
|
| 95 | + $dataSeriesLabels, // plotLabel |
|
| 96 | + $xAxisTickValues, // plotCategory |
|
| 97 | + $dataSeriesValues // plotValues |
|
| 98 | 98 | ); |
| 99 | 99 | // Set additional dataseries parameters |
| 100 | 100 | // Make it a horizontal bar rather than a vertical column graph |
@@ -111,14 +111,14 @@ discard block |
||
| 111 | 111 | |
| 112 | 112 | // Create the chart |
| 113 | 113 | $chart = new \PHPExcel\Chart( |
| 114 | - 'chart1', // name |
|
| 115 | - $title, // title |
|
| 116 | - $legend, // legend |
|
| 117 | - $plotArea, // plotArea |
|
| 118 | - true, // plotVisibleOnly |
|
| 119 | - 0, // displayBlanksAs |
|
| 120 | - NULL, // xAxisLabel |
|
| 121 | - $yAxisLabel // yAxisLabel |
|
| 114 | + 'chart1', // name |
|
| 115 | + $title, // title |
|
| 116 | + $legend, // legend |
|
| 117 | + $plotArea, // plotArea |
|
| 118 | + true, // plotVisibleOnly |
|
| 119 | + 0, // displayBlanksAs |
|
| 120 | + NULL, // xAxisLabel |
|
| 121 | + $yAxisLabel // yAxisLabel |
|
| 122 | 122 | ); |
| 123 | 123 | |
| 124 | 124 | // Set the position where the chart should appear in the worksheet |
@@ -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("PHPOffice") |
| 47 | - ->setLastModifiedBy("PHPOffice") |
|
| 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("PHPOffice") |
|
| 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 |
