PHPOffice /
PhpSpreadsheet
@@ -26,14 +26,14 @@ discard block |
||
| 26 | 26 | |
| 27 | 27 | |
| 28 | 28 | if (!PHPExcel\Settings::setPdfRenderer( |
| 29 | - $rendererName, |
|
| 30 | - $rendererLibraryPath |
|
| 31 | - )) { |
|
| 32 | - die( |
|
| 33 | - 'NOTICE: Please set the $rendererName and $rendererLibraryPath values' . |
|
| 34 | - EOL . |
|
| 35 | - 'at the top of this script as appropriate for your directory structure' |
|
| 36 | - ); |
|
| 29 | + $rendererName, |
|
| 30 | + $rendererLibraryPath |
|
| 31 | + )) { |
|
| 32 | + die( |
|
| 33 | + 'NOTICE: Please set the $rendererName and $rendererLibraryPath values' . |
|
| 34 | + EOL . |
|
| 35 | + 'at the top of this script as appropriate for your directory structure' |
|
| 36 | + ); |
|
| 37 | 37 | } |
| 38 | 38 | |
| 39 | 39 | |
@@ -45,14 +45,14 @@ discard block |
||
| 45 | 45 | |
| 46 | 46 | |
| 47 | 47 | if (!PHPExcel\Settings::setChartRenderer( |
| 48 | - $rendererName, |
|
| 49 | - $rendererLibraryPath |
|
| 50 | - )) { |
|
| 51 | - die( |
|
| 52 | - 'NOTICE: Please set the $rendererName and $rendererLibraryPath values' . |
|
| 53 | - EOL . |
|
| 54 | - 'at the top of this script as appropriate for your directory structure' |
|
| 55 | - ); |
|
| 48 | + $rendererName, |
|
| 49 | + $rendererLibraryPath |
|
| 50 | + )) { |
|
| 51 | + die( |
|
| 52 | + 'NOTICE: Please set the $rendererName and $rendererLibraryPath values' . |
|
| 53 | + EOL . |
|
| 54 | + 'at the top of this script as appropriate for your directory structure' |
|
| 55 | + ); |
|
| 56 | 56 | } |
| 57 | 57 | |
| 58 | 58 | |
@@ -60,81 +60,81 @@ discard block |
||
| 60 | 60 | $inputFileNames = 'templates/36write*.xlsx'; |
| 61 | 61 | |
| 62 | 62 | if ((isset($argc)) && ($argc > 1)) { |
| 63 | - $inputFileNames = array(); |
|
| 64 | - for($i = 1; $i < $argc; ++$i) { |
|
| 65 | - $inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i]; |
|
| 66 | - } |
|
| 63 | + $inputFileNames = array(); |
|
| 64 | + for($i = 1; $i < $argc; ++$i) { |
|
| 65 | + $inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i]; |
|
| 66 | + } |
|
| 67 | 67 | } else { |
| 68 | - $inputFileNames = glob($inputFileNames); |
|
| 68 | + $inputFileNames = glob($inputFileNames); |
|
| 69 | 69 | } |
| 70 | 70 | foreach($inputFileNames as $inputFileName) { |
| 71 | - $inputFileNameShort = basename($inputFileName); |
|
| 72 | - |
|
| 73 | - if (!file_exists($inputFileName)) { |
|
| 74 | - echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL; |
|
| 75 | - continue; |
|
| 76 | - } |
|
| 77 | - |
|
| 78 | - echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL; |
|
| 79 | - |
|
| 80 | - $objReader = \PHPExcel\IOFactory::createReader($inputFileType); |
|
| 81 | - $objReader->setIncludeCharts(TRUE); |
|
| 82 | - $objPHPExcel = $objReader->load($inputFileName); |
|
| 83 | - |
|
| 84 | - |
|
| 85 | - echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL; |
|
| 86 | - foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) { |
|
| 87 | - $sheetName = $worksheet->getTitle(); |
|
| 88 | - echo 'Worksheet: ' , $sheetName , EOL; |
|
| 89 | - |
|
| 90 | - $chartNames = $worksheet->getChartNames(); |
|
| 91 | - if(empty($chartNames)) { |
|
| 92 | - echo ' There are no charts in this worksheet' , EOL; |
|
| 93 | - } else { |
|
| 94 | - natsort($chartNames); |
|
| 95 | - foreach($chartNames as $i => $chartName) { |
|
| 96 | - $chart = $worksheet->getChartByName($chartName); |
|
| 97 | - if (!is_null($chart->getTitle())) { |
|
| 98 | - $caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"'; |
|
| 99 | - } else { |
|
| 100 | - $caption = 'Untitled'; |
|
| 101 | - } |
|
| 102 | - echo ' ' , $chartName , ' - ' , $caption , EOL; |
|
| 103 | - echo str_repeat(' ',strlen($chartName)+3); |
|
| 104 | - $groupCount = $chart->getPlotArea()->getPlotGroupCount(); |
|
| 105 | - if ($groupCount == 1) { |
|
| 106 | - $chartType = $chart->getPlotArea()->getPlotGroupByIndex(0)->getPlotType(); |
|
| 107 | - echo ' ' , $chartType , EOL; |
|
| 108 | - } else { |
|
| 109 | - $chartTypes = array(); |
|
| 110 | - for($i = 0; $i < $groupCount; ++$i) { |
|
| 111 | - $chartTypes[] = $chart->getPlotArea()->getPlotGroupByIndex($i)->getPlotType(); |
|
| 112 | - } |
|
| 113 | - $chartTypes = array_unique($chartTypes); |
|
| 114 | - if (count($chartTypes) == 1) { |
|
| 115 | - $chartType = 'Multiple Plot ' . array_pop($chartTypes); |
|
| 116 | - echo ' ' , $chartType , EOL; |
|
| 117 | - } elseif (count($chartTypes) == 0) { |
|
| 118 | - echo ' *** Type not yet implemented' , EOL; |
|
| 119 | - } else { |
|
| 120 | - echo ' Combination Chart' , EOL; |
|
| 121 | - } |
|
| 122 | - } |
|
| 123 | - } |
|
| 124 | - } |
|
| 125 | - } |
|
| 126 | - |
|
| 127 | - |
|
| 128 | - $outputFileName = str_replace('.xlsx', '.pdf', basename($inputFileName)); |
|
| 129 | - |
|
| 130 | - echo date('H:i:s') , " Write Tests to HTML file " , EOL; |
|
| 131 | - $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF'); |
|
| 132 | - $objWriter->setIncludeCharts(TRUE); |
|
| 133 | - $objWriter->save($outputFileName); |
|
| 134 | - echo date('H:i:s') , " File written to " , $outputFileName , EOL; |
|
| 135 | - |
|
| 136 | - $objPHPExcel->disconnectWorksheets(); |
|
| 137 | - unset($objPHPExcel); |
|
| 71 | + $inputFileNameShort = basename($inputFileName); |
|
| 72 | + |
|
| 73 | + if (!file_exists($inputFileName)) { |
|
| 74 | + echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL; |
|
| 75 | + continue; |
|
| 76 | + } |
|
| 77 | + |
|
| 78 | + echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL; |
|
| 79 | + |
|
| 80 | + $objReader = \PHPExcel\IOFactory::createReader($inputFileType); |
|
| 81 | + $objReader->setIncludeCharts(TRUE); |
|
| 82 | + $objPHPExcel = $objReader->load($inputFileName); |
|
| 83 | + |
|
| 84 | + |
|
| 85 | + echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL; |
|
| 86 | + foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) { |
|
| 87 | + $sheetName = $worksheet->getTitle(); |
|
| 88 | + echo 'Worksheet: ' , $sheetName , EOL; |
|
| 89 | + |
|
| 90 | + $chartNames = $worksheet->getChartNames(); |
|
| 91 | + if(empty($chartNames)) { |
|
| 92 | + echo ' There are no charts in this worksheet' , EOL; |
|
| 93 | + } else { |
|
| 94 | + natsort($chartNames); |
|
| 95 | + foreach($chartNames as $i => $chartName) { |
|
| 96 | + $chart = $worksheet->getChartByName($chartName); |
|
| 97 | + if (!is_null($chart->getTitle())) { |
|
| 98 | + $caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"'; |
|
| 99 | + } else { |
|
| 100 | + $caption = 'Untitled'; |
|
| 101 | + } |
|
| 102 | + echo ' ' , $chartName , ' - ' , $caption , EOL; |
|
| 103 | + echo str_repeat(' ',strlen($chartName)+3); |
|
| 104 | + $groupCount = $chart->getPlotArea()->getPlotGroupCount(); |
|
| 105 | + if ($groupCount == 1) { |
|
| 106 | + $chartType = $chart->getPlotArea()->getPlotGroupByIndex(0)->getPlotType(); |
|
| 107 | + echo ' ' , $chartType , EOL; |
|
| 108 | + } else { |
|
| 109 | + $chartTypes = array(); |
|
| 110 | + for($i = 0; $i < $groupCount; ++$i) { |
|
| 111 | + $chartTypes[] = $chart->getPlotArea()->getPlotGroupByIndex($i)->getPlotType(); |
|
| 112 | + } |
|
| 113 | + $chartTypes = array_unique($chartTypes); |
|
| 114 | + if (count($chartTypes) == 1) { |
|
| 115 | + $chartType = 'Multiple Plot ' . array_pop($chartTypes); |
|
| 116 | + echo ' ' , $chartType , EOL; |
|
| 117 | + } elseif (count($chartTypes) == 0) { |
|
| 118 | + echo ' *** Type not yet implemented' , EOL; |
|
| 119 | + } else { |
|
| 120 | + echo ' Combination Chart' , EOL; |
|
| 121 | + } |
|
| 122 | + } |
|
| 123 | + } |
|
| 124 | + } |
|
| 125 | + } |
|
| 126 | + |
|
| 127 | + |
|
| 128 | + $outputFileName = str_replace('.xlsx', '.pdf', basename($inputFileName)); |
|
| 129 | + |
|
| 130 | + echo date('H:i:s') , " Write Tests to HTML file " , EOL; |
|
| 131 | + $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF'); |
|
| 132 | + $objWriter->setIncludeCharts(TRUE); |
|
| 133 | + $objWriter->save($outputFileName); |
|
| 134 | + echo date('H:i:s') , " File written to " , $outputFileName , EOL; |
|
| 135 | + |
|
| 136 | + $objPHPExcel->disconnectWorksheets(); |
|
| 137 | + unset($objPHPExcel); |
|
| 138 | 138 | } |
| 139 | 139 | |
| 140 | 140 | // Echo memory peak usage |
@@ -6,7 +6,7 @@ discard block |
||
| 6 | 6 | ini_set('display_startup_errors', TRUE); |
| 7 | 7 | date_default_timezone_set('Europe/London'); |
| 8 | 8 | |
| 9 | -define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); |
|
| 9 | +define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); |
|
| 10 | 10 | |
| 11 | 11 | date_default_timezone_set('Europe/London'); |
| 12 | 12 | |
@@ -61,63 +61,63 @@ discard block |
||
| 61 | 61 | |
| 62 | 62 | if ((isset($argc)) && ($argc > 1)) { |
| 63 | 63 | $inputFileNames = array(); |
| 64 | - for($i = 1; $i < $argc; ++$i) { |
|
| 64 | + for ($i = 1; $i < $argc; ++$i) { |
|
| 65 | 65 | $inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i]; |
| 66 | 66 | } |
| 67 | 67 | } else { |
| 68 | 68 | $inputFileNames = glob($inputFileNames); |
| 69 | 69 | } |
| 70 | -foreach($inputFileNames as $inputFileName) { |
|
| 70 | +foreach ($inputFileNames as $inputFileName) { |
|
| 71 | 71 | $inputFileNameShort = basename($inputFileName); |
| 72 | 72 | |
| 73 | 73 | if (!file_exists($inputFileName)) { |
| 74 | - echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL; |
|
| 74 | + echo date('H:i:s'), " File ", $inputFileNameShort, ' does not exist', EOL; |
|
| 75 | 75 | continue; |
| 76 | 76 | } |
| 77 | 77 | |
| 78 | - echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL; |
|
| 78 | + echo date('H:i:s'), " Load Test from $inputFileType file ", $inputFileNameShort, EOL; |
|
| 79 | 79 | |
| 80 | 80 | $objReader = \PHPExcel\IOFactory::createReader($inputFileType); |
| 81 | 81 | $objReader->setIncludeCharts(TRUE); |
| 82 | 82 | $objPHPExcel = $objReader->load($inputFileName); |
| 83 | 83 | |
| 84 | 84 | |
| 85 | - echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL; |
|
| 85 | + echo date('H:i:s'), " Iterate worksheets looking at the charts", EOL; |
|
| 86 | 86 | foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) { |
| 87 | 87 | $sheetName = $worksheet->getTitle(); |
| 88 | - echo 'Worksheet: ' , $sheetName , EOL; |
|
| 88 | + echo 'Worksheet: ', $sheetName, EOL; |
|
| 89 | 89 | |
| 90 | 90 | $chartNames = $worksheet->getChartNames(); |
| 91 | - if(empty($chartNames)) { |
|
| 92 | - echo ' There are no charts in this worksheet' , EOL; |
|
| 91 | + if (empty($chartNames)) { |
|
| 92 | + echo ' There are no charts in this worksheet', EOL; |
|
| 93 | 93 | } else { |
| 94 | 94 | natsort($chartNames); |
| 95 | - foreach($chartNames as $i => $chartName) { |
|
| 95 | + foreach ($chartNames as $i => $chartName) { |
|
| 96 | 96 | $chart = $worksheet->getChartByName($chartName); |
| 97 | 97 | if (!is_null($chart->getTitle())) { |
| 98 | - $caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"'; |
|
| 98 | + $caption = '"' . implode(' ', $chart->getTitle()->getCaption()) . '"'; |
|
| 99 | 99 | } else { |
| 100 | 100 | $caption = 'Untitled'; |
| 101 | 101 | } |
| 102 | - echo ' ' , $chartName , ' - ' , $caption , EOL; |
|
| 103 | - echo str_repeat(' ',strlen($chartName)+3); |
|
| 102 | + echo ' ', $chartName, ' - ', $caption, EOL; |
|
| 103 | + echo str_repeat(' ', strlen($chartName) + 3); |
|
| 104 | 104 | $groupCount = $chart->getPlotArea()->getPlotGroupCount(); |
| 105 | 105 | if ($groupCount == 1) { |
| 106 | 106 | $chartType = $chart->getPlotArea()->getPlotGroupByIndex(0)->getPlotType(); |
| 107 | - echo ' ' , $chartType , EOL; |
|
| 107 | + echo ' ', $chartType, EOL; |
|
| 108 | 108 | } else { |
| 109 | 109 | $chartTypes = array(); |
| 110 | - for($i = 0; $i < $groupCount; ++$i) { |
|
| 110 | + for ($i = 0; $i < $groupCount; ++$i) { |
|
| 111 | 111 | $chartTypes[] = $chart->getPlotArea()->getPlotGroupByIndex($i)->getPlotType(); |
| 112 | 112 | } |
| 113 | 113 | $chartTypes = array_unique($chartTypes); |
| 114 | 114 | if (count($chartTypes) == 1) { |
| 115 | 115 | $chartType = 'Multiple Plot ' . array_pop($chartTypes); |
| 116 | - echo ' ' , $chartType , EOL; |
|
| 116 | + echo ' ', $chartType, EOL; |
|
| 117 | 117 | } elseif (count($chartTypes) == 0) { |
| 118 | - echo ' *** Type not yet implemented' , EOL; |
|
| 118 | + echo ' *** Type not yet implemented', EOL; |
|
| 119 | 119 | } else { |
| 120 | - echo ' Combination Chart' , EOL; |
|
| 120 | + echo ' Combination Chart', EOL; |
|
| 121 | 121 | } |
| 122 | 122 | } |
| 123 | 123 | } |
@@ -127,19 +127,19 @@ discard block |
||
| 127 | 127 | |
| 128 | 128 | $outputFileName = str_replace('.xlsx', '.pdf', basename($inputFileName)); |
| 129 | 129 | |
| 130 | - echo date('H:i:s') , " Write Tests to HTML file " , EOL; |
|
| 130 | + echo date('H:i:s'), " Write Tests to HTML file ", EOL; |
|
| 131 | 131 | $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF'); |
| 132 | 132 | $objWriter->setIncludeCharts(TRUE); |
| 133 | 133 | $objWriter->save($outputFileName); |
| 134 | - echo date('H:i:s') , " File written to " , $outputFileName , EOL; |
|
| 134 | + echo date('H:i:s'), " File written to ", $outputFileName, EOL; |
|
| 135 | 135 | |
| 136 | 136 | $objPHPExcel->disconnectWorksheets(); |
| 137 | 137 | unset($objPHPExcel); |
| 138 | 138 | } |
| 139 | 139 | |
| 140 | 140 | // Echo memory peak usage |
| 141 | -echo date('H:i:s') , ' Peak memory usage: ' , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL; |
|
| 141 | +echo date('H:i:s'), ' Peak memory usage: ', (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL; |
|
| 142 | 142 | |
| 143 | 143 | // Echo done |
| 144 | -echo date('H:i:s') , " Done writing files" , EOL; |
|
| 145 | -echo 'Files have been created in ' , getcwd() , EOL; |
|
| 144 | +echo date('H:i:s'), " Done writing files", EOL; |
|
| 145 | +echo 'Files have been created in ', getcwd(), EOL; |
|
@@ -46,12 +46,12 @@ discard block |
||
| 46 | 46 | // Set document properties |
| 47 | 47 | echo date('H:i:s') , " Set document properties" , EOL; |
| 48 | 48 | $objPHPExcel->getProperties()->setCreator("Maarten Balliauw") |
| 49 | - ->setLastModifiedBy("Maarten Balliauw") |
|
| 50 | - ->setTitle("Office 2007 XLSX Test Document") |
|
| 51 | - ->setSubject("Office 2007 XLSX Test Document") |
|
| 52 | - ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") |
|
| 53 | - ->setKeywords("office 2007 openxml php") |
|
| 54 | - ->setCategory("Test result file"); |
|
| 49 | + ->setLastModifiedBy("Maarten Balliauw") |
|
| 50 | + ->setTitle("Office 2007 XLSX Test Document") |
|
| 51 | + ->setSubject("Office 2007 XLSX Test Document") |
|
| 52 | + ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") |
|
| 53 | + ->setKeywords("office 2007 openxml php") |
|
| 54 | + ->setCategory("Test result file"); |
|
| 55 | 55 | |
| 56 | 56 | |
| 57 | 57 | // Add some data |
@@ -62,26 +62,26 @@ discard block |
||
| 62 | 62 | $sharedStyle2 = new \PHPExcel\Style(); |
| 63 | 63 | |
| 64 | 64 | $sharedStyle1->applyFromArray( |
| 65 | - array('fill' => array( |
|
| 66 | - 'type' => \PHPExcel\Style\Fill::FILL_SOLID, |
|
| 67 | - 'color' => array('argb' => 'FFCCFFCC') |
|
| 68 | - ), |
|
| 69 | - 'borders' => array( |
|
| 70 | - 'bottom' => array('style' => \PHPExcel\Style\Border::BORDER_THIN), |
|
| 71 | - 'right' => array('style' => \PHPExcel\Style\Border::BORDER_MEDIUM) |
|
| 72 | - ) |
|
| 73 | - )); |
|
| 65 | + array('fill' => array( |
|
| 66 | + 'type' => \PHPExcel\Style\Fill::FILL_SOLID, |
|
| 67 | + 'color' => array('argb' => 'FFCCFFCC') |
|
| 68 | + ), |
|
| 69 | + 'borders' => array( |
|
| 70 | + 'bottom' => array('style' => \PHPExcel\Style\Border::BORDER_THIN), |
|
| 71 | + 'right' => array('style' => \PHPExcel\Style\Border::BORDER_MEDIUM) |
|
| 72 | + ) |
|
| 73 | + )); |
|
| 74 | 74 | |
| 75 | 75 | $sharedStyle2->applyFromArray( |
| 76 | - array('fill' => array( |
|
| 77 | - 'type' => \PHPExcel\Style\Fill::FILL_SOLID, |
|
| 78 | - 'color' => array('argb' => 'FFFFFF00') |
|
| 79 | - ), |
|
| 80 | - 'borders' => array( |
|
| 81 | - 'bottom' => array('style' => \PHPExcel\Style\Border::BORDER_THIN), |
|
| 82 | - 'right' => array('style' => \PHPExcel\Style\Border::BORDER_MEDIUM) |
|
| 83 | - ) |
|
| 84 | - )); |
|
| 76 | + array('fill' => array( |
|
| 77 | + 'type' => \PHPExcel\Style\Fill::FILL_SOLID, |
|
| 78 | + 'color' => array('argb' => 'FFFFFF00') |
|
| 79 | + ), |
|
| 80 | + 'borders' => array( |
|
| 81 | + 'bottom' => array('style' => \PHPExcel\Style\Border::BORDER_THIN), |
|
| 82 | + 'right' => array('style' => \PHPExcel\Style\Border::BORDER_MEDIUM) |
|
| 83 | + ) |
|
| 84 | + )); |
|
| 85 | 85 | |
| 86 | 86 | $objPHPExcel->getActiveSheet()->duplicateStyle($sharedStyle1, "A1:T100"); |
| 87 | 87 | $objPHPExcel->getActiveSheet()->duplicateStyle($sharedStyle2, "C5:R95"); |
@@ -31,7 +31,7 @@ discard block |
||
| 31 | 31 | ini_set('display_startup_errors', TRUE); |
| 32 | 32 | date_default_timezone_set('Europe/London'); |
| 33 | 33 | |
| 34 | -define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); |
|
| 34 | +define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); |
|
| 35 | 35 | |
| 36 | 36 | date_default_timezone_set('Europe/London'); |
| 37 | 37 | |
@@ -40,11 +40,11 @@ discard block |
||
| 40 | 40 | |
| 41 | 41 | |
| 42 | 42 | // Create new PHPExcel object |
| 43 | -echo date('H:i:s') , " Create new PHPExcel object" , EOL; |
|
| 43 | +echo date('H:i:s'), " Create new PHPExcel object", EOL; |
|
| 44 | 44 | $objPHPExcel = new \PHPExcel\Spreadsheet(); |
| 45 | 45 | |
| 46 | 46 | // Set document properties |
| 47 | -echo date('H:i:s') , " Set document properties" , EOL; |
|
| 47 | +echo date('H:i:s'), " Set document properties", EOL; |
|
| 48 | 48 | $objPHPExcel->getProperties()->setCreator("Maarten Balliauw") |
| 49 | 49 | ->setLastModifiedBy("Maarten Balliauw") |
| 50 | 50 | ->setTitle("Office 2007 XLSX Test Document") |
@@ -55,7 +55,7 @@ discard block |
||
| 55 | 55 | |
| 56 | 56 | |
| 57 | 57 | // Add some data |
| 58 | -echo date('H:i:s') , " Add some data" , EOL; |
|
| 58 | +echo date('H:i:s'), " Add some data", EOL; |
|
| 59 | 59 | $objPHPExcel->setActiveSheetIndex(0); |
| 60 | 60 | |
| 61 | 61 | $sharedStyle1 = new \PHPExcel\Style(); |
@@ -87,7 +87,7 @@ discard block |
||
| 87 | 87 | $objPHPExcel->getActiveSheet()->duplicateStyle($sharedStyle2, "C5:R95"); |
| 88 | 88 | |
| 89 | 89 | // Save Excel 2007 file |
| 90 | -echo date('H:i:s') , " Write to Excel2007 format" , EOL; |
|
| 90 | +echo date('H:i:s'), " Write to Excel2007 format", EOL; |
|
| 91 | 91 | $callStartTime = microtime(true); |
| 92 | 92 | |
| 93 | 93 | $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007'); |
@@ -95,14 +95,14 @@ discard block |
||
| 95 | 95 | $callEndTime = microtime(true); |
| 96 | 96 | $callTime = $callEndTime - $callStartTime; |
| 97 | 97 | |
| 98 | -echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL; |
|
| 99 | -echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL; |
|
| 98 | +echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL; |
|
| 99 | +echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL; |
|
| 100 | 100 | // Echo memory usage |
| 101 | -echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL; |
|
| 101 | +echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL; |
|
| 102 | 102 | |
| 103 | 103 | |
| 104 | 104 | // Save Excel 95 file |
| 105 | -echo date('H:i:s') , " Write to Excel5 format" , EOL; |
|
| 105 | +echo date('H:i:s'), " Write to Excel5 format", EOL; |
|
| 106 | 106 | $callStartTime = microtime(true); |
| 107 | 107 | |
| 108 | 108 | $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5'); |
@@ -110,15 +110,15 @@ discard block |
||
| 110 | 110 | $callEndTime = microtime(true); |
| 111 | 111 | $callTime = $callEndTime - $callStartTime; |
| 112 | 112 | |
| 113 | -echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL; |
|
| 114 | -echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL; |
|
| 113 | +echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL; |
|
| 114 | +echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL; |
|
| 115 | 115 | // Echo memory usage |
| 116 | -echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL; |
|
| 116 | +echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL; |
|
| 117 | 117 | |
| 118 | 118 | |
| 119 | 119 | // Echo memory peak usage |
| 120 | -echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL; |
|
| 120 | +echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL; |
|
| 121 | 121 | |
| 122 | 122 | // Echo done |
| 123 | -echo date('H:i:s') , " Done writing file" , EOL; |
|
| 124 | -echo 'File has been created in ' , getcwd() , EOL; |
|
| 123 | +echo date('H:i:s'), " Done writing file", EOL; |
|
| 124 | +echo 'File has been created in ', getcwd(), EOL; |
|
@@ -30,14 +30,14 @@ discard block |
||
| 30 | 30 | ini_set('display_errors', TRUE); |
| 31 | 31 | ini_set('display_startup_errors', TRUE); |
| 32 | 32 | |
| 33 | -define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); |
|
| 33 | +define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); |
|
| 34 | 34 | |
| 35 | 35 | date_default_timezone_set('Europe/London'); |
| 36 | 36 | |
| 37 | 37 | include "05featuredemo.inc.php"; |
| 38 | 38 | |
| 39 | 39 | // Save Excel 2007 file |
| 40 | -echo date('H:i:s') , " Write to Excel2007 format" , EOL; |
|
| 40 | +echo date('H:i:s'), " Write to Excel2007 format", EOL; |
|
| 41 | 41 | $callStartTime = microtime(true); |
| 42 | 42 | |
| 43 | 43 | $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007'); |
@@ -45,14 +45,14 @@ discard block |
||
| 45 | 45 | $callEndTime = microtime(true); |
| 46 | 46 | $callTime = $callEndTime - $callStartTime; |
| 47 | 47 | |
| 48 | -echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL; |
|
| 49 | -echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL; |
|
| 48 | +echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL; |
|
| 49 | +echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL; |
|
| 50 | 50 | // Echo memory usage |
| 51 | -echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL; |
|
| 51 | +echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL; |
|
| 52 | 52 | |
| 53 | 53 | |
| 54 | 54 | // Save Excel 95 file |
| 55 | -echo date('H:i:s') , " Write to Excel5 format" , EOL; |
|
| 55 | +echo date('H:i:s'), " Write to Excel5 format", EOL; |
|
| 56 | 56 | $callStartTime = microtime(true); |
| 57 | 57 | |
| 58 | 58 | $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5'); |
@@ -60,15 +60,15 @@ discard block |
||
| 60 | 60 | $callEndTime = microtime(true); |
| 61 | 61 | $callTime = $callEndTime - $callStartTime; |
| 62 | 62 | |
| 63 | -echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL; |
|
| 64 | -echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL; |
|
| 63 | +echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL; |
|
| 64 | +echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL; |
|
| 65 | 65 | // Echo memory usage |
| 66 | -echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL; |
|
| 66 | +echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL; |
|
| 67 | 67 | |
| 68 | 68 | |
| 69 | 69 | // Echo memory peak usage |
| 70 | -echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL; |
|
| 70 | +echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL; |
|
| 71 | 71 | |
| 72 | 72 | // Echo done |
| 73 | -echo date('H:i:s') , " Done writing files" , EOL; |
|
| 74 | -echo 'Files have been created in ' , getcwd() , EOL; |
|
| 73 | +echo date('H:i:s'), " Done writing files", EOL; |
|
| 74 | +echo 'Files have been created in ', getcwd(), EOL; |
|
@@ -34,17 +34,17 @@ |
||
| 34 | 34 | require_once dirname(__FILE__) . '/../Classes/PHPExcel/IOFactory.php'; |
| 35 | 35 | |
| 36 | 36 | |
| 37 | -echo date('H:i:s') , " Load from SYLK file" , PHP_EOL;
|
|
| 37 | +echo date('H:i:s'), " Load from SYLK file", PHP_EOL;
|
|
| 38 | 38 | $objPHPExcel = \PHPExcel\IOFactory::load("SylkTest.slk");
|
| 39 | 39 | |
| 40 | -echo date('H:i:s') , " Write to Excel2007 format" , PHP_EOL;
|
|
| 40 | +echo date('H:i:s'), " Write to Excel2007 format", PHP_EOL;
|
|
| 41 | 41 | $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007'); |
| 42 | 42 | $objWriter->save(str_replace('.php', '.xlsx', __FILE__));
|
| 43 | -echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', __FILE__) , PHP_EOL;
|
|
| 43 | +echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', __FILE__), PHP_EOL;
|
|
| 44 | 44 | |
| 45 | 45 | |
| 46 | 46 | // Echo memory peak usage |
| 47 | -echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , PHP_EOL;
|
|
| 47 | +echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", PHP_EOL;
|
|
| 48 | 48 | |
| 49 | 49 | // Echo done |
| 50 | -echo date('H:i:s') , " Done writing file" , PHP_EOL;
|
|
| 50 | +echo date('H:i:s'), " Done writing file", PHP_EOL;
|
|
@@ -31,7 +31,7 @@ discard block |
||
| 31 | 31 | ini_set('display_startup_errors', TRUE); |
| 32 | 32 | date_default_timezone_set('Europe/London'); |
| 33 | 33 | |
| 34 | -define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); |
|
| 34 | +define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); |
|
| 35 | 35 | |
| 36 | 36 | date_default_timezone_set('Europe/London'); |
| 37 | 37 | |
@@ -105,4 +105,4 @@ discard block |
||
| 105 | 105 | echo date('H:i:s') . " Peak memory usage: " . (memory_get_peak_usage(true) / 1024 / 1024) . " MB\r\n"; |
| 106 | 106 | |
| 107 | 107 | // Echo done |
| 108 | -echo date('H:i:s') . " Done" , EOL; |
|
| 108 | +echo date('H:i:s') . " Done", EOL; |
|
@@ -30,7 +30,7 @@ discard block |
||
| 30 | 30 | ini_set('display_errors', TRUE); |
| 31 | 31 | ini_set('display_startup_errors', TRUE); |
| 32 | 32 | |
| 33 | -define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); |
|
| 33 | +define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); |
|
| 34 | 34 | |
| 35 | 35 | date_default_timezone_set('Europe/London'); |
| 36 | 36 | |
@@ -39,11 +39,11 @@ discard block |
||
| 39 | 39 | |
| 40 | 40 | |
| 41 | 41 | // Create new PHPExcel object |
| 42 | -echo date('H:i:s') , " Create new PHPExcel object" , EOL; |
|
| 42 | +echo date('H:i:s'), " Create new PHPExcel object", EOL; |
|
| 43 | 43 | $objPHPExcel = new \PHPExcel\Spreadsheet(); |
| 44 | 44 | |
| 45 | 45 | // Set document properties |
| 46 | -echo date('H:i:s') , " Set document properties" , EOL; |
|
| 46 | +echo date('H:i:s'), " Set document properties", EOL; |
|
| 47 | 47 | $objPHPExcel->getProperties()->setCreator("Maarten Balliauw") |
| 48 | 48 | ->setLastModifiedBy("Maarten Balliauw") |
| 49 | 49 | ->setTitle("Office 2007 XLSX Test Document") |
@@ -53,13 +53,13 @@ discard block |
||
| 53 | 53 | ->setCategory("Test result file"); |
| 54 | 54 | |
| 55 | 55 | // Generate an image |
| 56 | -echo date('H:i:s') , " Generate an image" , EOL; |
|
| 56 | +echo date('H:i:s'), " Generate an image", EOL; |
|
| 57 | 57 | $gdImage = @imagecreatetruecolor(120, 20) or die('Cannot Initialize new GD image stream'); |
| 58 | 58 | $textColor = imagecolorallocate($gdImage, 255, 255, 255); |
| 59 | -imagestring($gdImage, 1, 5, 5, 'Created with PHPExcel', $textColor); |
|
| 59 | +imagestring($gdImage, 1, 5, 5, 'Created with PHPExcel', $textColor); |
|
| 60 | 60 | |
| 61 | 61 | // Add a drawing to the worksheet |
| 62 | -echo date('H:i:s') , " Add a drawing to the worksheet" , EOL; |
|
| 62 | +echo date('H:i:s'), " Add a drawing to the worksheet", EOL; |
|
| 63 | 63 | $objDrawing = new \PHPExcel\Worksheet\MemoryDrawing(); |
| 64 | 64 | $objDrawing->setName('Sample image'); |
| 65 | 65 | $objDrawing->setDescription('Sample image'); |
@@ -69,21 +69,21 @@ discard block |
||
| 69 | 69 | $objDrawing->setHeight(36); |
| 70 | 70 | $objDrawing->setWorksheet($objPHPExcel->getActiveSheet()); |
| 71 | 71 | |
| 72 | -echo date('H:i:s') , " Write to Excel2007 format" , EOL; |
|
| 72 | +echo date('H:i:s'), " Write to Excel2007 format", EOL; |
|
| 73 | 73 | $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007'); |
| 74 | 74 | $objWriter->save(str_replace('.php', '.xlsx', __FILE__)); |
| 75 | -echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL; |
|
| 75 | +echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL; |
|
| 76 | 76 | |
| 77 | 77 | |
| 78 | -echo date('H:i:s') , " Write to HTML format" , EOL; |
|
| 78 | +echo date('H:i:s'), " Write to HTML format", EOL; |
|
| 79 | 79 | $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'HTML'); |
| 80 | 80 | $objWriter->save(str_replace('.php', '.html', __FILE__)); |
| 81 | -echo date('H:i:s') , " File written to " , str_replace('.php', '.html', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL; |
|
| 81 | +echo date('H:i:s'), " File written to ", str_replace('.php', '.html', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL; |
|
| 82 | 82 | |
| 83 | 83 | |
| 84 | 84 | // Echo memory peak usage |
| 85 | -echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL; |
|
| 85 | +echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL; |
|
| 86 | 86 | |
| 87 | 87 | // Echo done |
| 88 | -echo date('H:i:s') , " Done writing file" , EOL; |
|
| 89 | -echo 'Files have been created in ' , getcwd() , EOL; |
|
| 88 | +echo date('H:i:s'), " Done writing file", EOL; |
|
| 89 | +echo 'Files have been created in ', getcwd(), EOL; |
|
@@ -45,12 +45,12 @@ |
||
| 45 | 45 | // Set document properties |
| 46 | 46 | echo date('H:i:s') , " Set document properties" , EOL; |
| 47 | 47 | $objPHPExcel->getProperties()->setCreator("Maarten Balliauw") |
| 48 | - ->setLastModifiedBy("Maarten Balliauw") |
|
| 49 | - ->setTitle("Office 2007 XLSX Test Document") |
|
| 50 | - ->setSubject("Office 2007 XLSX Test Document") |
|
| 51 | - ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") |
|
| 52 | - ->setKeywords("office 2007 openxml php") |
|
| 53 | - ->setCategory("Test result file"); |
|
| 48 | + ->setLastModifiedBy("Maarten Balliauw") |
|
| 49 | + ->setTitle("Office 2007 XLSX Test Document") |
|
| 50 | + ->setSubject("Office 2007 XLSX Test Document") |
|
| 51 | + ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") |
|
| 52 | + ->setKeywords("office 2007 openxml php") |
|
| 53 | + ->setCategory("Test result file"); |
|
| 54 | 54 | |
| 55 | 55 | |
| 56 | 56 | // Add some data |
@@ -31,18 +31,18 @@ discard block |
||
| 31 | 31 | ini_set('display_startup_errors', TRUE); |
| 32 | 32 | date_default_timezone_set('Europe/London'); |
| 33 | 33 | |
| 34 | -define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); |
|
| 34 | +define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); |
|
| 35 | 35 | |
| 36 | 36 | /** Include PHPExcel */ |
| 37 | 37 | require_once dirname(__FILE__) . '/../src/Bootstrap.php'; |
| 38 | 38 | |
| 39 | 39 | |
| 40 | 40 | // Create new PHPExcel object |
| 41 | -echo date('H:i:s') , " Create new PHPExcel object" , EOL; |
|
| 41 | +echo date('H:i:s'), " Create new PHPExcel object", EOL; |
|
| 42 | 42 | $objPHPExcel = new \PHPExcel\Spreadsheet(); |
| 43 | 43 | |
| 44 | 44 | // Set document properties |
| 45 | -echo date('H:i:s') , " Set document properties" , EOL; |
|
| 45 | +echo date('H:i:s'), " Set document properties", EOL; |
|
| 46 | 46 | $objPHPExcel->getProperties()->setCreator("Maarten Balliauw") |
| 47 | 47 | ->setLastModifiedBy("Maarten Balliauw") |
| 48 | 48 | ->setTitle("PHPExcel Test Document") |
@@ -53,7 +53,7 @@ discard block |
||
| 53 | 53 | |
| 54 | 54 | |
| 55 | 55 | // Add some data |
| 56 | -echo date('H:i:s') , " Add some data" , EOL; |
|
| 56 | +echo date('H:i:s'), " Add some data", EOL; |
|
| 57 | 57 | $objPHPExcel->setActiveSheetIndex(0) |
| 58 | 58 | ->setCellValue('A1', 'Hello') |
| 59 | 59 | ->setCellValue('B2', 'world!') |
@@ -66,18 +66,18 @@ discard block |
||
| 66 | 66 | ->setCellValue('A5', 'éàèùâêîôûëïüÿäöüç'); |
| 67 | 67 | |
| 68 | 68 | |
| 69 | -$objPHPExcel->getActiveSheet()->setCellValue('A8',"Hello\nWorld"); |
|
| 69 | +$objPHPExcel->getActiveSheet()->setCellValue('A8', "Hello\nWorld"); |
|
| 70 | 70 | $objPHPExcel->getActiveSheet()->getRowDimension(8)->setRowHeight(-1); |
| 71 | 71 | $objPHPExcel->getActiveSheet()->getStyle('A8')->getAlignment()->setWrapText(true); |
| 72 | 72 | |
| 73 | 73 | |
| 74 | 74 | // Rename worksheet |
| 75 | -echo date('H:i:s') , " Rename worksheet" , EOL; |
|
| 75 | +echo date('H:i:s'), " Rename worksheet", EOL; |
|
| 76 | 76 | $objPHPExcel->getActiveSheet()->setTitle('Simple'); |
| 77 | 77 | |
| 78 | 78 | |
| 79 | 79 | // Clone worksheet |
| 80 | -echo date('H:i:s') , " Clone worksheet" , EOL; |
|
| 80 | +echo date('H:i:s'), " Clone worksheet", EOL; |
|
| 81 | 81 | $clonedSheet = clone $objPHPExcel->getActiveSheet(); |
| 82 | 82 | $clonedSheet |
| 83 | 83 | ->setCellValue('A1', 'Goodbye') |
@@ -86,7 +86,7 @@ discard block |
||
| 86 | 86 | ->setCellValue('C2', 'cruel'); |
| 87 | 87 | |
| 88 | 88 | // Rename cloned worksheet |
| 89 | -echo date('H:i:s') , " Rename cloned worksheet" , EOL; |
|
| 89 | +echo date('H:i:s'), " Rename cloned worksheet", EOL; |
|
| 90 | 90 | $clonedSheet->setTitle('Simple Clone'); |
| 91 | 91 | $objPHPExcel->addSheet($clonedSheet); |
| 92 | 92 | |
@@ -96,7 +96,7 @@ discard block |
||
| 96 | 96 | |
| 97 | 97 | |
| 98 | 98 | // Save Excel 2007 file |
| 99 | -echo date('H:i:s') , " Write to Excel2007 format" , EOL; |
|
| 99 | +echo date('H:i:s'), " Write to Excel2007 format", EOL; |
|
| 100 | 100 | $callStartTime = microtime(true); |
| 101 | 101 | |
| 102 | 102 | $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007'); |
@@ -104,15 +104,15 @@ discard block |
||
| 104 | 104 | $callEndTime = microtime(true); |
| 105 | 105 | $callTime = $callEndTime - $callStartTime; |
| 106 | 106 | |
| 107 | -echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL; |
|
| 108 | -echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL; |
|
| 107 | +echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL; |
|
| 108 | +echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL; |
|
| 109 | 109 | // Echo memory usage |
| 110 | -echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL; |
|
| 110 | +echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL; |
|
| 111 | 111 | |
| 112 | 112 | |
| 113 | 113 | // Echo memory peak usage |
| 114 | -echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL; |
|
| 114 | +echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL; |
|
| 115 | 115 | |
| 116 | 116 | // Echo done |
| 117 | -echo date('H:i:s') , " Done writing files" , EOL; |
|
| 118 | -echo 'File has been created in ' , getcwd() , EOL; |
|
| 117 | +echo date('H:i:s'), " Done writing files", EOL; |
|
| 118 | +echo 'File has been created in ', getcwd(), EOL; |
|
@@ -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 |
@@ -45,12 +45,12 @@ |
||
| 45 | 45 | echo date('H:i:s') , " Set document properties" , EOL; |
| 46 | 46 | $objPHPExcel->getProperties() |
| 47 | 47 | ->setCreator("Maarten Balliauw") |
| 48 | - ->setLastModifiedBy("Maarten Balliauw") |
|
| 49 | - ->setTitle("Office 2007 XLSX Test Document") |
|
| 50 | - ->setSubject("Office 2007 XLSX Test Document") |
|
| 51 | - ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") |
|
| 52 | - ->setKeywords("office 2007 openxml php") |
|
| 53 | - ->setCategory("Test result file"); |
|
| 48 | + ->setLastModifiedBy("Maarten Balliauw") |
|
| 49 | + ->setTitle("Office 2007 XLSX Test Document") |
|
| 50 | + ->setSubject("Office 2007 XLSX Test Document") |
|
| 51 | + ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") |
|
| 52 | + ->setKeywords("office 2007 openxml php") |
|
| 53 | + ->setCategory("Test result file"); |
|
| 54 | 54 | |
| 55 | 55 | // Set default font |
| 56 | 56 | echo date('H:i:s') , " Set default font" , EOL; |
@@ -31,18 +31,18 @@ discard block |
||
| 31 | 31 | ini_set('display_startup_errors', TRUE); |
| 32 | 32 | date_default_timezone_set('Europe/London'); |
| 33 | 33 | |
| 34 | -define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); |
|
| 34 | +define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); |
|
| 35 | 35 | |
| 36 | 36 | /** Include PHPExcel */ |
| 37 | 37 | require_once dirname(__FILE__) . '/../src/Bootstrap.php'; |
| 38 | 38 | |
| 39 | 39 | |
| 40 | 40 | // Create new PHPExcel object |
| 41 | -echo date('H:i:s') , " Create new PHPExcel object" , EOL; |
|
| 41 | +echo date('H:i:s'), " Create new PHPExcel object", EOL; |
|
| 42 | 42 | $objPHPExcel = new \PHPExcel\Spreadsheet(); |
| 43 | 43 | |
| 44 | 44 | // Set document properties |
| 45 | -echo date('H:i:s') , " Set document properties" , EOL; |
|
| 45 | +echo date('H:i:s'), " Set document properties", EOL; |
|
| 46 | 46 | $objPHPExcel->getProperties() |
| 47 | 47 | ->setCreator("Maarten Balliauw") |
| 48 | 48 | ->setLastModifiedBy("Maarten Balliauw") |
@@ -53,14 +53,14 @@ discard block |
||
| 53 | 53 | ->setCategory("Test result file"); |
| 54 | 54 | |
| 55 | 55 | // Set default font |
| 56 | -echo date('H:i:s') , " Set default font" , EOL; |
|
| 56 | +echo date('H:i:s'), " Set default font", EOL; |
|
| 57 | 57 | $objPHPExcel->getDefaultStyle() |
| 58 | 58 | ->getFont() |
| 59 | 59 | ->setName('Arial') |
| 60 | 60 | ->setSize(10); |
| 61 | 61 | |
| 62 | 62 | // Add some data, resembling some different data types |
| 63 | -echo date('H:i:s') , " Add some data" , EOL; |
|
| 63 | +echo date('H:i:s'), " Add some data", EOL; |
|
| 64 | 64 | $objPHPExcel->getActiveSheet() |
| 65 | 65 | ->setCellValue('A1', 'String') |
| 66 | 66 | ->setCellValue('B1', 'Simple') |
@@ -105,7 +105,7 @@ discard block |
||
| 105 | 105 | $objPHPExcel->getActiveSheet() |
| 106 | 106 | ->setCellValue('A9', 'Date/Time') |
| 107 | 107 | ->setCellValue('B9', 'Date') |
| 108 | - ->setCellValue('C9', \PHPExcel\Shared\Date::PHPToExcel( $dateTimeNow )); |
|
| 108 | + ->setCellValue('C9', \PHPExcel\Shared\Date::PHPToExcel($dateTimeNow)); |
|
| 109 | 109 | $objPHPExcel->getActiveSheet() |
| 110 | 110 | ->getStyle('C9') |
| 111 | 111 | ->getNumberFormat() |
@@ -114,7 +114,7 @@ discard block |
||
| 114 | 114 | $objPHPExcel->getActiveSheet() |
| 115 | 115 | ->setCellValue('A10', 'Date/Time') |
| 116 | 116 | ->setCellValue('B10', 'Time') |
| 117 | - ->setCellValue('C10', \PHPExcel\Shared\Date::PHPToExcel( $dateTimeNow )); |
|
| 117 | + ->setCellValue('C10', \PHPExcel\Shared\Date::PHPToExcel($dateTimeNow)); |
|
| 118 | 118 | $objPHPExcel->getActiveSheet() |
| 119 | 119 | ->getStyle('C10') |
| 120 | 120 | ->getNumberFormat() |
@@ -123,7 +123,7 @@ discard block |
||
| 123 | 123 | $objPHPExcel->getActiveSheet() |
| 124 | 124 | ->setCellValue('A11', 'Date/Time') |
| 125 | 125 | ->setCellValue('B11', 'Date and Time') |
| 126 | - ->setCellValue('C11', \PHPExcel\Shared\Date::PHPToExcel( $dateTimeNow )); |
|
| 126 | + ->setCellValue('C11', \PHPExcel\Shared\Date::PHPToExcel($dateTimeNow)); |
|
| 127 | 127 | $objPHPExcel->getActiveSheet() |
| 128 | 128 | ->getStyle('C11') |
| 129 | 129 | ->getNumberFormat() |
@@ -139,7 +139,7 @@ discard block |
||
| 139 | 139 | $objPayable = $objRichText->createTextRun('你 好 吗？'); |
| 140 | 140 | $objPayable->getFont()->setBold(true); |
| 141 | 141 | $objPayable->getFont()->setItalic(true); |
| 142 | -$objPayable->getFont()->setColor( new \PHPExcel\Style\Color( \PHPExcel\Style\Color::COLOR_DARKGREEN ) ); |
|
| 142 | +$objPayable->getFont()->setColor(new \PHPExcel\Style\Color(\PHPExcel\Style\Color::COLOR_DARKGREEN)); |
|
| 143 | 143 | |
| 144 | 144 | $objRichText->createText(', unless specified otherwise on the invoice.'); |
| 145 | 145 | |
@@ -152,7 +152,7 @@ discard block |
||
| 152 | 152 | $objRichText2->createText("black text\n"); |
| 153 | 153 | |
| 154 | 154 | $objRed = $objRichText2->createTextRun("red text"); |
| 155 | -$objRed->getFont()->setColor( new \PHPExcel\Style\Color(\PHPExcel\Style\Color::COLOR_RED ) ); |
|
| 155 | +$objRed->getFont()->setColor(new \PHPExcel\Style\Color(\PHPExcel\Style\Color::COLOR_RED)); |
|
| 156 | 156 | |
| 157 | 157 | $objPHPExcel->getActiveSheet() |
| 158 | 158 | ->getCell("C14") |
@@ -179,7 +179,7 @@ discard block |
||
| 179 | 179 | ->setAutoSize(true); |
| 180 | 180 | |
| 181 | 181 | // Rename worksheet |
| 182 | -echo date('H:i:s') , " Rename worksheet" , EOL; |
|
| 182 | +echo date('H:i:s'), " Rename worksheet", EOL; |
|
| 183 | 183 | $objPHPExcel->getActiveSheet()->setTitle('Datatypes'); |
| 184 | 184 | |
| 185 | 185 | |
@@ -188,7 +188,7 @@ discard block |
||
| 188 | 188 | |
| 189 | 189 | |
| 190 | 190 | // Save Excel 2007 file |
| 191 | -echo date('H:i:s') , " Write to Excel2007 format" , EOL; |
|
| 191 | +echo date('H:i:s'), " Write to Excel2007 format", EOL; |
|
| 192 | 192 | $callStartTime = microtime(true); |
| 193 | 193 | |
| 194 | 194 | $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007'); |
@@ -196,30 +196,30 @@ discard block |
||
| 196 | 196 | $callEndTime = microtime(true); |
| 197 | 197 | $callTime = $callEndTime - $callStartTime; |
| 198 | 198 | |
| 199 | -echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL; |
|
| 200 | -echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL; |
|
| 199 | +echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL; |
|
| 200 | +echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL; |
|
| 201 | 201 | // Echo memory usage |
| 202 | -echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL; |
|
| 202 | +echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL; |
|
| 203 | 203 | |
| 204 | 204 | |
| 205 | -echo date('H:i:s') , " Reload workbook from saved file" , EOL; |
|
| 205 | +echo date('H:i:s'), " Reload workbook from saved file", EOL; |
|
| 206 | 206 | $callStartTime = microtime(true); |
| 207 | 207 | |
| 208 | 208 | $objPHPExcel = \PHPExcel\IOFactory::load(str_replace('.php', '.xlsx', __FILE__)); |
| 209 | 209 | |
| 210 | 210 | $callEndTime = microtime(true); |
| 211 | 211 | $callTime = $callEndTime - $callStartTime; |
| 212 | -echo 'Call time to reload Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL; |
|
| 212 | +echo 'Call time to reload Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL; |
|
| 213 | 213 | // Echo memory usage |
| 214 | -echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL; |
|
| 214 | +echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL; |
|
| 215 | 215 | |
| 216 | 216 | |
| 217 | 217 | var_dump($objPHPExcel->getActiveSheet()->toArray()); |
| 218 | 218 | |
| 219 | 219 | |
| 220 | 220 | // Echo memory peak usage |
| 221 | -echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL; |
|
| 221 | +echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL; |
|
| 222 | 222 | |
| 223 | 223 | // Echo done |
| 224 | -echo date('H:i:s') , " Done testing file" , EOL; |
|
| 225 | -echo 'File has been created in ' , getcwd() , EOL; |
|
| 224 | +echo date('H:i:s'), " Done testing file", EOL; |
|
| 225 | +echo 'File has been created in ', getcwd(), EOL; |
|
@@ -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 | |
@@ -61,9 +61,9 @@ discard block |
||
| 61 | 61 | // Data values |
| 62 | 62 | // Data Marker |
| 63 | 63 | $dataSeriesLabels1 = array( |
| 64 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), // 2010 |
|
| 65 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011 |
|
| 66 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012 |
|
| 64 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), // 2010 |
|
| 65 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011 |
|
| 66 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012 |
|
| 67 | 67 | ); |
| 68 | 68 | // Set the X-Axis Labels |
| 69 | 69 | // Datatype |
@@ -73,7 +73,7 @@ discard block |
||
| 73 | 73 | // Data values |
| 74 | 74 | // Data Marker |
| 75 | 75 | $xAxisTickValues1 = array( |
| 76 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4 |
|
| 76 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4 |
|
| 77 | 77 | ); |
| 78 | 78 | // Set the Data values for each data series we want to plot |
| 79 | 79 | // Datatype |
@@ -83,19 +83,19 @@ discard block |
||
| 83 | 83 | // Data values |
| 84 | 84 | // Data Marker |
| 85 | 85 | $dataSeriesValues1 = array( |
| 86 | - new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4), |
|
| 87 | - new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4), |
|
| 88 | - new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4), |
|
| 86 | + new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4), |
|
| 87 | + new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4), |
|
| 88 | + new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4), |
|
| 89 | 89 | ); |
| 90 | 90 | |
| 91 | 91 | // Build the dataseries |
| 92 | 92 | $series1 = new \PHPExcel\Chart\DataSeries( |
| 93 | - \PHPExcel\Chart\DataSeries::TYPE_AREACHART, // plotType |
|
| 94 | - \PHPExcel\Chart\DataSeries::GROUPING_PERCENT_STACKED, // plotGrouping |
|
| 95 | - range(0, count($dataSeriesValues1)-1), // plotOrder |
|
| 96 | - $dataSeriesLabels1, // plotLabel |
|
| 97 | - $xAxisTickValues1, // plotCategory |
|
| 98 | - $dataSeriesValues1 // plotValues |
|
| 93 | + \PHPExcel\Chart\DataSeries::TYPE_AREACHART, // plotType |
|
| 94 | + \PHPExcel\Chart\DataSeries::GROUPING_PERCENT_STACKED, // plotGrouping |
|
| 95 | + range(0, count($dataSeriesValues1)-1), // plotOrder |
|
| 96 | + $dataSeriesLabels1, // plotLabel |
|
| 97 | + $xAxisTickValues1, // plotCategory |
|
| 98 | + $dataSeriesValues1 // plotValues |
|
| 99 | 99 | ); |
| 100 | 100 | |
| 101 | 101 | // Set the series in the plot area |
@@ -109,14 +109,14 @@ discard block |
||
| 109 | 109 | |
| 110 | 110 | // Create the chart |
| 111 | 111 | $chart1 = new \PHPExcel\Chart( |
| 112 | - 'chart1', // name |
|
| 113 | - $title1, // title |
|
| 114 | - $legend1, // legend |
|
| 115 | - $plotArea1, // plotArea |
|
| 116 | - true, // plotVisibleOnly |
|
| 117 | - 0, // displayBlanksAs |
|
| 118 | - NULL, // xAxisLabel |
|
| 119 | - $yAxisLabel1 // yAxisLabel |
|
| 112 | + 'chart1', // name |
|
| 113 | + $title1, // title |
|
| 114 | + $legend1, // legend |
|
| 115 | + $plotArea1, // plotArea |
|
| 116 | + true, // plotVisibleOnly |
|
| 117 | + 0, // displayBlanksAs |
|
| 118 | + NULL, // xAxisLabel |
|
| 119 | + $yAxisLabel1 // yAxisLabel |
|
| 120 | 120 | ); |
| 121 | 121 | |
| 122 | 122 | // Set the position where the chart should appear in the worksheet |
@@ -135,9 +135,9 @@ discard block |
||
| 135 | 135 | // Data values |
| 136 | 136 | // Data Marker |
| 137 | 137 | $dataSeriesLabels2 = array( |
| 138 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), // 2010 |
|
| 139 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011 |
|
| 140 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012 |
|
| 138 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), // 2010 |
|
| 139 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011 |
|
| 140 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012 |
|
| 141 | 141 | ); |
| 142 | 142 | // Set the X-Axis Labels |
| 143 | 143 | // Datatype |
@@ -147,7 +147,7 @@ discard block |
||
| 147 | 147 | // Data values |
| 148 | 148 | // Data Marker |
| 149 | 149 | $xAxisTickValues2 = array( |
| 150 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4 |
|
| 150 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4 |
|
| 151 | 151 | ); |
| 152 | 152 | // Set the Data values for each data series we want to plot |
| 153 | 153 | // Datatype |
@@ -157,19 +157,19 @@ discard block |
||
| 157 | 157 | // Data values |
| 158 | 158 | // Data Marker |
| 159 | 159 | $dataSeriesValues2 = array( |
| 160 | - new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4), |
|
| 161 | - new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4), |
|
| 162 | - new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4), |
|
| 160 | + new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4), |
|
| 161 | + new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4), |
|
| 162 | + new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4), |
|
| 163 | 163 | ); |
| 164 | 164 | |
| 165 | 165 | // Build the dataseries |
| 166 | 166 | $series2 = new \PHPExcel\Chart\DataSeries( |
| 167 | - \PHPExcel\Chart\DataSeries::TYPE_BARCHART, // plotType |
|
| 168 | - \PHPExcel\Chart\DataSeries::GROUPING_STANDARD, // plotGrouping |
|
| 169 | - range(0, count($dataSeriesValues2)-1), // plotOrder |
|
| 170 | - $dataSeriesLabels2, // plotLabel |
|
| 171 | - $xAxisTickValues2, // plotCategory |
|
| 172 | - $dataSeriesValues2 // plotValues |
|
| 167 | + \PHPExcel\Chart\DataSeries::TYPE_BARCHART, // plotType |
|
| 168 | + \PHPExcel\Chart\DataSeries::GROUPING_STANDARD, // plotGrouping |
|
| 169 | + range(0, count($dataSeriesValues2)-1), // plotOrder |
|
| 170 | + $dataSeriesLabels2, // plotLabel |
|
| 171 | + $xAxisTickValues2, // plotCategory |
|
| 172 | + $dataSeriesValues2 // plotValues |
|
| 173 | 173 | ); |
| 174 | 174 | // Set additional dataseries parameters |
| 175 | 175 | // Make it a vertical column rather than a horizontal bar graph |
@@ -186,14 +186,14 @@ discard block |
||
| 186 | 186 | |
| 187 | 187 | // Create the chart |
| 188 | 188 | $chart2 = new \PHPExcel\Chart( |
| 189 | - 'chart2', // name |
|
| 190 | - $title2, // title |
|
| 191 | - $legend2, // legend |
|
| 192 | - $plotArea2, // plotArea |
|
| 193 | - true, // plotVisibleOnly |
|
| 194 | - 0, // displayBlanksAs |
|
| 195 | - NULL, // xAxisLabel |
|
| 196 | - $yAxisLabel2 // yAxisLabel |
|
| 189 | + 'chart2', // name |
|
| 190 | + $title2, // title |
|
| 191 | + $legend2, // legend |
|
| 192 | + $plotArea2, // plotArea |
|
| 193 | + true, // plotVisibleOnly |
|
| 194 | + 0, // displayBlanksAs |
|
| 195 | + NULL, // xAxisLabel |
|
| 196 | + $yAxisLabel2 // yAxisLabel |
|
| 197 | 197 | ); |
| 198 | 198 | |
| 199 | 199 | // Set the position where the chart should appear in the worksheet |
@@ -6,7 +6,7 @@ discard block |
||
| 6 | 6 | ini_set('display_startup_errors', TRUE); |
| 7 | 7 | date_default_timezone_set('Europe/London'); |
| 8 | 8 | |
| 9 | -define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); |
|
| 9 | +define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />'); |
|
| 10 | 10 | |
| 11 | 11 | date_default_timezone_set('Europe/London'); |
| 12 | 12 | |
@@ -44,11 +44,11 @@ discard block |
||
| 44 | 44 | $objWorksheet = $objPHPExcel->getActiveSheet(); |
| 45 | 45 | $objWorksheet->fromArray( |
| 46 | 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), |
|
| 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 | 52 | ) |
| 53 | 53 | ); |
| 54 | 54 | |
@@ -61,9 +61,9 @@ discard block |
||
| 61 | 61 | // Data values |
| 62 | 62 | // Data Marker |
| 63 | 63 | $dataSeriesLabels1 = array( |
| 64 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), // 2010 |
|
| 65 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011 |
|
| 66 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012 |
|
| 64 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), // 2010 |
|
| 65 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011 |
|
| 66 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012 |
|
| 67 | 67 | ); |
| 68 | 68 | // Set the X-Axis Labels |
| 69 | 69 | // Datatype |
@@ -73,7 +73,7 @@ discard block |
||
| 73 | 73 | // Data values |
| 74 | 74 | // Data Marker |
| 75 | 75 | $xAxisTickValues1 = array( |
| 76 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4 |
|
| 76 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4 |
|
| 77 | 77 | ); |
| 78 | 78 | // Set the Data values for each data series we want to plot |
| 79 | 79 | // Datatype |
@@ -90,11 +90,11 @@ discard block |
||
| 90 | 90 | |
| 91 | 91 | // Build the dataseries |
| 92 | 92 | $series1 = new \PHPExcel\Chart\DataSeries( |
| 93 | - \PHPExcel\Chart\DataSeries::TYPE_AREACHART, // plotType |
|
| 94 | - \PHPExcel\Chart\DataSeries::GROUPING_PERCENT_STACKED, // plotGrouping |
|
| 95 | - range(0, count($dataSeriesValues1)-1), // plotOrder |
|
| 96 | - $dataSeriesLabels1, // plotLabel |
|
| 97 | - $xAxisTickValues1, // plotCategory |
|
| 93 | + \PHPExcel\Chart\DataSeries::TYPE_AREACHART, // plotType |
|
| 94 | + \PHPExcel\Chart\DataSeries::GROUPING_PERCENT_STACKED, // plotGrouping |
|
| 95 | + range(0, count($dataSeriesValues1) - 1), // plotOrder |
|
| 96 | + $dataSeriesLabels1, // plotLabel |
|
| 97 | + $xAxisTickValues1, // plotCategory |
|
| 98 | 98 | $dataSeriesValues1 // plotValues |
| 99 | 99 | ); |
| 100 | 100 | |
@@ -109,13 +109,13 @@ discard block |
||
| 109 | 109 | |
| 110 | 110 | // Create the chart |
| 111 | 111 | $chart1 = new \PHPExcel\Chart( |
| 112 | - 'chart1', // name |
|
| 113 | - $title1, // title |
|
| 114 | - $legend1, // legend |
|
| 115 | - $plotArea1, // plotArea |
|
| 116 | - true, // plotVisibleOnly |
|
| 117 | - 0, // displayBlanksAs |
|
| 118 | - NULL, // xAxisLabel |
|
| 112 | + 'chart1', // name |
|
| 113 | + $title1, // title |
|
| 114 | + $legend1, // legend |
|
| 115 | + $plotArea1, // plotArea |
|
| 116 | + true, // plotVisibleOnly |
|
| 117 | + 0, // displayBlanksAs |
|
| 118 | + NULL, // xAxisLabel |
|
| 119 | 119 | $yAxisLabel1 // yAxisLabel |
| 120 | 120 | ); |
| 121 | 121 | |
@@ -135,9 +135,9 @@ discard block |
||
| 135 | 135 | // Data values |
| 136 | 136 | // Data Marker |
| 137 | 137 | $dataSeriesLabels2 = array( |
| 138 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), // 2010 |
|
| 139 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011 |
|
| 140 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012 |
|
| 138 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1), // 2010 |
|
| 139 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1), // 2011 |
|
| 140 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1), // 2012 |
|
| 141 | 141 | ); |
| 142 | 142 | // Set the X-Axis Labels |
| 143 | 143 | // Datatype |
@@ -147,7 +147,7 @@ discard block |
||
| 147 | 147 | // Data values |
| 148 | 148 | // Data Marker |
| 149 | 149 | $xAxisTickValues2 = array( |
| 150 | - new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4 |
|
| 150 | + new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), // Q1 to Q4 |
|
| 151 | 151 | ); |
| 152 | 152 | // Set the Data values for each data series we want to plot |
| 153 | 153 | // Datatype |
@@ -164,11 +164,11 @@ discard block |
||
| 164 | 164 | |
| 165 | 165 | // Build the dataseries |
| 166 | 166 | $series2 = new \PHPExcel\Chart\DataSeries( |
| 167 | - \PHPExcel\Chart\DataSeries::TYPE_BARCHART, // plotType |
|
| 168 | - \PHPExcel\Chart\DataSeries::GROUPING_STANDARD, // plotGrouping |
|
| 169 | - range(0, count($dataSeriesValues2)-1), // plotOrder |
|
| 170 | - $dataSeriesLabels2, // plotLabel |
|
| 171 | - $xAxisTickValues2, // plotCategory |
|
| 167 | + \PHPExcel\Chart\DataSeries::TYPE_BARCHART, // plotType |
|
| 168 | + \PHPExcel\Chart\DataSeries::GROUPING_STANDARD, // plotGrouping |
|
| 169 | + range(0, count($dataSeriesValues2) - 1), // plotOrder |
|
| 170 | + $dataSeriesLabels2, // plotLabel |
|
| 171 | + $xAxisTickValues2, // plotCategory |
|
| 172 | 172 | $dataSeriesValues2 // plotValues |
| 173 | 173 | ); |
| 174 | 174 | // Set additional dataseries parameters |
@@ -186,13 +186,13 @@ discard block |
||
| 186 | 186 | |
| 187 | 187 | // Create the chart |
| 188 | 188 | $chart2 = new \PHPExcel\Chart( |
| 189 | - 'chart2', // name |
|
| 190 | - $title2, // title |
|
| 191 | - $legend2, // legend |
|
| 192 | - $plotArea2, // plotArea |
|
| 193 | - true, // plotVisibleOnly |
|
| 194 | - 0, // displayBlanksAs |
|
| 195 | - NULL, // xAxisLabel |
|
| 189 | + 'chart2', // name |
|
| 190 | + $title2, // title |
|
| 191 | + $legend2, // legend |
|
| 192 | + $plotArea2, // plotArea |
|
| 193 | + true, // plotVisibleOnly |
|
| 194 | + 0, // displayBlanksAs |
|
| 195 | + NULL, // xAxisLabel |
|
| 196 | 196 | $yAxisLabel2 // yAxisLabel |
| 197 | 197 | ); |
| 198 | 198 | |
@@ -205,16 +205,16 @@ discard block |
||
| 205 | 205 | |
| 206 | 206 | |
| 207 | 207 | // Save Excel 2007 file |
| 208 | -echo date('H:i:s') , " Write to Excel2007 format" , EOL; |
|
| 208 | +echo date('H:i:s'), " Write to Excel2007 format", EOL; |
|
| 209 | 209 | $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007'); |
| 210 | 210 | $objWriter->setIncludeCharts(TRUE); |
| 211 | 211 | $objWriter->save(str_replace('.php', '.xlsx', __FILE__)); |
| 212 | -echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL; |
|
| 212 | +echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL; |
|
| 213 | 213 | |
| 214 | 214 | |
| 215 | 215 | // Echo memory peak usage |
| 216 | -echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL; |
|
| 216 | +echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL; |
|
| 217 | 217 | |
| 218 | 218 | // Echo done |
| 219 | -echo date('H:i:s') , " Done writing file" , EOL; |
|
| 220 | -echo 'File has been created in ' , getcwd() , EOL; |
|
| 219 | +echo date('H:i:s'), " Done writing file", EOL; |
|
| 220 | +echo 'File has been created in ', getcwd(), EOL; |
|
