View GitHub Repository PhpSpreadsheet

Schedule Inspection
Subscribe
Completed
Branch — master (962a82)
by Adrien
09:13
created
Category
Toggle Patches
Examples/33chartcreate-scatter.php 1 patch
Spacing   +29 added lines, -29 removed lines patch added patch discarded remove patch 
@@ -6,7 +6,7 @@  discard block
 
 block discarded – undo
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
 
 block discarded – undo
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 
 
@@ -60,13 +60,13 @@  discard block
 
 block discarded – undo
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 
 $xAxisTickValues = array(
69 
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
69 
+	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4), //	Q1 to Q4
70 70 
 );
71 71 
 //	Set the Data values for each data series we want to plot
72 72 
 //		Datatype
 
@@ -83,13 +83,13 @@  discard block
 
 block discarded – undo
83 83
84 84 
 //	Build the dataseries
85 85 
 $series = new \PHPExcel\Chart\DataSeries(
86 
-	\PHPExcel\Chart\DataSeries::TYPE_SCATTERCHART,	// plotType
87 
-	NULL,											// plotGrouping (Scatter charts don't have any grouping)
88 
-	range(0, count($dataSeriesValues)-1),			// plotOrder
89 
-	$dataSeriesLabels,								// plotLabel
90 
-	$xAxisTickValues,								// plotCategory
91 
-	$dataSeriesValues,								// plotValues
92 
-	NULL,											// smooth line
86 
+	\PHPExcel\Chart\DataSeries::TYPE_SCATTERCHART, // plotType
87 
+	NULL, // plotGrouping (Scatter charts don't have any grouping)
88 
+	range(0, count($dataSeriesValues) - 1), // plotOrder
89 
+	$dataSeriesLabels, // plotLabel
90 
+	$xAxisTickValues, // plotCategory
91 
+	$dataSeriesValues, // plotValues
92 
+	NULL, // smooth line
93 93 
 	\PHPExcel\Chart\DataSeries::STYLE_LINEMARKER		// plotStyle
94 94 
 );
95 95 
 
@@ -104,13 +104,13 @@  discard block
 
 block discarded – undo
104 104
105 105 
 //	Create the chart
106 106 
 $chart = new \PHPExcel\Chart(
107 
-	'chart1',		// name
108 
-	$title,			// title
109 
-	$legend,		// legend
110 
-	$plotArea,		// plotArea
111 
-	true,			// plotVisibleOnly
112 
-	0,				// displayBlanksAs
113 
-	NULL,			// xAxisLabel
107 
+	'chart1', // name
108 
+	$title, // title
109 
+	$legend, // legend
110 
+	$plotArea, // plotArea
111 
+	true, // plotVisibleOnly
112 
+	0, // displayBlanksAs
113 
+	NULL, // xAxisLabel
114 114 
 	$yAxisLabel		// yAxisLabel
115 115 
 );
116 116 
 
@@ -123,16 +123,16 @@  discard block
 
 block discarded – undo
123 123
124 124
125 125 
 // Save Excel 2007 file
126 
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
126 
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
127 127 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
128 128 
 $objWriter->setIncludeCharts(TRUE);
129 129 
 $objWriter->save(str_replace('.php', '.xlsx', __FILE__));
130 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
130 
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
131 131
132 132
133 133 
 // Echo memory peak usage
134 
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
134 
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
135 135
136 136 
 // Echo done
137 
-echo date('H:i:s') , " Done writing file" , EOL;
138 
-echo 'File has been created in ' , getcwd() , EOL;
137 
+echo date('H:i:s'), " Done writing file", EOL;
138 
+echo 'File has been created in ', getcwd(), EOL;
Please login to merge, or discard this patch.
Examples/OOCalcReaderPCLZip.php 1 patch
Spacing   +7 added lines, -7 removed lines patch added patch discarded remove patch 
@@ -36,7 +36,7 @@  discard block
 
 block discarded – undo
36 36 
 // Use PCLZip rather than ZipArchive to read the Excel2007 OfficeOpenXML file
37 37 
 PHPExcel\Settings::setZipClass(PHPExcel\Settings::PCLZIP);
38 38
39 
-echo date('H:i:s') , " Load from OOCalc file" , PHP_EOL;
39 
+echo date('H:i:s'), " Load from OOCalc file", PHP_EOL;
40 40 
 $callStartTime = microtime(true);
41 41
42 42 
 $objReader = \PHPExcel\IOFactory::createReader('OOCalc');
 
@@ -45,20 +45,20 @@  discard block
 
 block discarded – undo
45 45
46 46 
 $callEndTime = microtime(true);
47 47 
 $callTime = $callEndTime - $callStartTime;
48 
-echo 'Call time to read Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , PHP_EOL;
48 
+echo 'Call time to read Workbook was ', sprintf('%.4f', $callTime), " seconds", PHP_EOL;
49 49 
 // Echo memory usage
50 
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , PHP_EOL;
50 
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", PHP_EOL;
51 51
52 52
53 
-echo date('H:i:s') , " Write to Excel2007 format" , PHP_EOL;
53 
+echo date('H:i:s'), " Write to Excel2007 format", PHP_EOL;
54 54 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
55 55 
 $objWriter->save(str_replace('.php', '.xlsx', __FILE__));
56 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', __FILE__) , PHP_EOL;
56 
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', __FILE__), PHP_EOL;
57 57
58 58
59 59 
 // Echo memory peak usage
60 
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , PHP_EOL;
60 
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", PHP_EOL;
61 61
62 62 
 // Echo done
63 
-echo date('H:i:s') , " Done writing file" , PHP_EOL;
63 
+echo date('H:i:s'), " Done writing file", PHP_EOL;
64 64
Please login to merge, or discard this patch.
Examples/36chartreadwriteHTML.php 1 patch
Spacing   +23 added lines, -23 removed lines patch added patch discarded remove patch 
@@ -6,7 +6,7 @@  discard block
 
 block discarded – undo
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 
 
@@ -38,63 +38,63 @@  discard block
 
 block discarded – undo
38 38
39 39 
 if ((isset($argc)) && ($argc > 1)) {
40 40 
 	$inputFileNames = array();
41 
-	for($i = 1; $i < $argc; ++$i) {
41 
+	for ($i = 1; $i < $argc; ++$i) {
42 42 
 		$inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i];
43 43 
 	}
44 44 
 } else {
45 45 
 	$inputFileNames = glob($inputFileNames);
46 46 
 }
47 
-foreach($inputFileNames as $inputFileName) {
47 
+foreach ($inputFileNames as $inputFileName) {
48 48 
 	$inputFileNameShort = basename($inputFileName);
49 49
50 50 
 	if (!file_exists($inputFileName)) {
51 
-		echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL;
51 
+		echo date('H:i:s'), " File ", $inputFileNameShort, ' does not exist', EOL;
52 52 
 		continue;
53 53 
 	}
54 54
55 
-	echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL;
55 
+	echo date('H:i:s'), " Load Test from $inputFileType file ", $inputFileNameShort, EOL;
56 56
57 57 
 	$objReader = \PHPExcel\IOFactory::createReader($inputFileType);
58 58 
 	$objReader->setIncludeCharts(TRUE);
59 59 
 	$objPHPExcel = $objReader->load($inputFileName);
60 60
61 61
62 
-	echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL;
62 
+	echo date('H:i:s'), " Iterate worksheets looking at the charts", EOL;
63 63 
 	foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
64 64 
 		$sheetName = $worksheet->getTitle();
65 
-		echo 'Worksheet: ' , $sheetName , EOL;
65 
+		echo 'Worksheet: ', $sheetName, EOL;
66 66
67 67 
 		$chartNames = $worksheet->getChartNames();
68 
-		if(empty($chartNames)) {
69 
-			echo '    There are no charts in this worksheet' , EOL;
68 
+		if (empty($chartNames)) {
69 
+			echo '    There are no charts in this worksheet', EOL;
70 70 
 		} else {
71 71 
 			natsort($chartNames);
72 
-			foreach($chartNames as $i => $chartName) {
72 
+			foreach ($chartNames as $i => $chartName) {
73 73 
 				$chart = $worksheet->getChartByName($chartName);
74 74 
 				if (!is_null($chart->getTitle())) {
75 
-					$caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"';
75 
+					$caption = '"' . implode(' ', $chart->getTitle()->getCaption()) . '"';
76 76 
 				} else {
77 77 
 					$caption = 'Untitled';
78 78 
 				}
79 
-				echo '    ' , $chartName , ' - ' , $caption , EOL;
80 
-				echo str_repeat(' ',strlen($chartName)+3);
79 
+				echo '    ', $chartName, ' - ', $caption, EOL;
80 
+				echo str_repeat(' ', strlen($chartName) + 3);
81 81 
 				$groupCount = $chart->getPlotArea()->getPlotGroupCount();
82 82 
 				if ($groupCount == 1) {
83 83 
 					$chartType = $chart->getPlotArea()->getPlotGroupByIndex(0)->getPlotType();
84 
-					echo '    ' , $chartType , EOL;
84 
+					echo '    ', $chartType, EOL;
85 85 
 				} else {
86 86 
 					$chartTypes = array();
87 
-					for($i = 0; $i < $groupCount; ++$i) {
87 
+					for ($i = 0; $i < $groupCount; ++$i) {
88 88 
 						$chartTypes[] = $chart->getPlotArea()->getPlotGroupByIndex($i)->getPlotType();
89 89 
 					}
90 90 
 					$chartTypes = array_unique($chartTypes);
91 91 
 					if (count($chartTypes) == 1) {
92 92 
 						$chartType = 'Multiple Plot ' . array_pop($chartTypes);
93 
-						echo '    ' , $chartType , EOL;
93 
+						echo '    ', $chartType, EOL;
94 94 
 					} elseif (count($chartTypes) == 0) {
95 
-						echo '    *** Type not yet implemented' , EOL;
95 
+						echo '    *** Type not yet implemented', EOL;
96 96 
 					} else {
97 
-						echo '    Combination Chart' , EOL;
97 
+						echo '    Combination Chart', EOL;
98 98 
 					}
99 99 
 				}
100 100 
 			}
 
@@ -104,19 +104,19 @@  discard block
 
 block discarded – undo
104 104
105 105 
 	$outputFileName = str_replace('.xlsx', '.html', basename($inputFileName));
106 106
107 
-	echo date('H:i:s') , " Write Tests to HTML file " , EOL;
107 
+	echo date('H:i:s'), " Write Tests to HTML file ", EOL;
108 108 
 	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'HTML');
109 109 
 	$objWriter->setIncludeCharts(TRUE);
110 110 
 	$objWriter->save($outputFileName);
111 
-	echo date('H:i:s') , " File written to " , $outputFileName , EOL;
111 
+	echo date('H:i:s'), " File written to ", $outputFileName, EOL;
112 112
113 113 
 	$objPHPExcel->disconnectWorksheets();
114 114 
 	unset($objPHPExcel);
115 115 
 }
116 116
117 117 
 // Echo memory peak usage
118 
-echo date('H:i:s') , ' Peak memory usage: ' , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
118 
+echo date('H:i:s'), ' Peak memory usage: ', (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
119 119
120 120 
 // Echo done
121 
-echo date('H:i:s') , " Done writing files" , EOL;
122 
-echo 'Files have been created in ' , getcwd() , EOL;
121 
+echo date('H:i:s'), " Done writing files", EOL;
122 
+echo 'Files have been created in ', getcwd(), EOL;
Please login to merge, or discard this patch.
Examples/44worksheetInfo.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch 
@@ -29,7 +29,7 @@
 
 block discarded – undo
29 29 
 ini_set('display_errors', TRUE);
30 30 
 ini_set('display_startup_errors', TRUE);
31 31
32 
-define('EOL',(PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
32 
+define('EOL', (PHP_SAPI == 'cli') ? PHP_EOL : '<br />');
33 33
34 34 
 date_default_timezone_set('Europe/London');
35 35
Please login to merge, or discard this patch.
Examples/08conditionalformatting2.php 1 patch
Spacing   +16 added lines, -16 removed lines patch added patch discarded remove patch 
@@ -30,7 +30,7 @@  discard block
 
 block discarded – undo
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
 
 block discarded – undo
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")
 
@@ -54,7 +54,7 @@  discard block
 
 block discarded – undo
54 54
55 55
56 56 
 // Create a first sheet, representing sales data
57 
-echo date('H:i:s') , " Add some data" , EOL;
57 
+echo date('H:i:s'), " Add some data", EOL;
58 58 
 $objPHPExcel->setActiveSheetIndex(0);
59 59 
 $objPHPExcel->getActiveSheet()
60 60 
     ->setCellValue('A1', '-0.5')
 
@@ -75,7 +75,7 @@  discard block
 
 block discarded – undo
75 75
76 76
77 77 
 // Add conditional formatting
78 
-echo date('H:i:s') , " Add conditional formatting" , EOL;
78 
+echo date('H:i:s'), " Add conditional formatting", EOL;
79 79 
 $objConditional1 = new \PHPExcel\Style\Conditional();
80 80 
 $objConditional1->setConditionType(\PHPExcel\Style\Conditional::CONDITION_CELLIS)
81 81 
     ->setOperatorType(\PHPExcel\Style\Conditional::OPERATOR_LESSTHAN)
 
@@ -95,7 +95,7 @@  discard block
 
 block discarded – undo
95 95
96 96
97 97 
 //	duplicate the conditional styles across a range of cells
98 
-echo date('H:i:s') , " Duplicate the conditional formatting across a range of cells" , EOL;
98 
+echo date('H:i:s'), " Duplicate the conditional formatting across a range of cells", EOL;
99 99 
 $objPHPExcel->getActiveSheet()->duplicateConditionalStyle(
100 100 
 				$objPHPExcel->getActiveSheet()->getStyle('A1')->getConditionalStyles(),
101 101 
 				'A2:A8'
 
@@ -103,7 +103,7 @@  discard block
 
 block discarded – undo
103 103
104 104
105 105 
 // Save Excel 2007 file
106 
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
106 
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
107 107 
 $callStartTime = microtime(true);
108 108
109 109 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
 
@@ -111,10 +111,10 @@  discard block
 
 block discarded – undo
111 111 
 $callEndTime = microtime(true);
112 112 
 $callTime = $callEndTime - $callStartTime;
113 113
114 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
115 
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
114 
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
115 
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
116 116 
 // Save Excel5 file
117 
-echo date('H:i:s') , " Write to Excel5 format" , EOL;
117 
+echo date('H:i:s'), " Write to Excel5 format", EOL;
118 118 
 $callStartTime = microtime(true);
119 119
120 120 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
 
@@ -122,15 +122,15 @@  discard block
 
 block discarded – undo
122 122 
 $callEndTime = microtime(true);
123 123 
 $callTime = $callEndTime - $callStartTime;
124 124
125 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
126 
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
125 
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
126 
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
127 127 
 // Echo memory usage
128 
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
128 
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
129 129
130 130
131 131 
 // Echo memory peak usage
132 
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
132 
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
133 133
134 134 
 // Echo done
135 
-echo date('H:i:s') , " Done writing file" , EOL;
136 
-echo 'File has been created in ' , getcwd() , EOL;
135 
+echo date('H:i:s'), " Done writing file", EOL;
136 
+echo 'File has been created in ', getcwd(), EOL;
Please login to merge, or discard this patch.
Examples/04printing.php 1 patch
Spacing   +19 added lines, -19 removed lines patch added patch discarded remove patch 
@@ -30,7 +30,7 @@  discard block
 
 block discarded – undo
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
 
 block discarded – undo
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")
 
@@ -54,19 +54,19 @@  discard block
 
 block discarded – undo
54 54
55 55
56 56 
 // Add some data, we will use printing features
57 
-echo date('H:i:s') , " Add some data" , EOL;
57 
+echo date('H:i:s'), " Add some data", EOL;
58 58 
 for ($i = 1; $i < 200; $i++) {
59 59 
 	$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $i);
60 60 
 	$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, 'Test value');
61 61 
 }
62 62
63 63 
 // Set header and footer. When no different headers for odd/even are used, odd header is assumed.
64 
-echo date('H:i:s') , " Set header/footer" , EOL;
64 
+echo date('H:i:s'), " Set header/footer", EOL;
65 65 
 $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&L&G&C&HPlease treat this document as confidential!');
66 66 
 $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&L&B' . $objPHPExcel->getProperties()->getTitle() . '&RPage &P of &N');
67 67
68 68 
 // Add a drawing to the header
69 
-echo date('H:i:s') , " Add a drawing to the header" , EOL;
69 
+echo date('H:i:s'), " Add a drawing to the header", EOL;
70 70 
 $objDrawing = new \PHPExcel\Worksheet\HeaderFooterDrawing();
71 71 
 $objDrawing->setName('PHPExcel logo');
72 72 
 $objDrawing->setPath('./images/phpexcel_logo.gif');
 
@@ -74,12 +74,12 @@  discard block
 
 block discarded – undo
74 74 
 $objPHPExcel->getActiveSheet()->getHeaderFooter()->addImage($objDrawing, \PHPExcel\Worksheet\HeaderFooter::IMAGE_HEADER_LEFT);
75 75
76 76 
 // Set page orientation and size
77 
-echo date('H:i:s') , " Set page orientation and size" , EOL;
77 
+echo date('H:i:s'), " Set page orientation and size", EOL;
78 78 
 $objPHPExcel->getActiveSheet()->getPageSetup()->setOrientation(\PHPExcel\Worksheet\PageSetup::ORIENTATION_LANDSCAPE);
79 79 
 $objPHPExcel->getActiveSheet()->getPageSetup()->setPaperSize(\PHPExcel\Worksheet\PageSetup::PAPERSIZE_A4);
80 80
81 81 
 // Rename worksheet
82 
-echo date('H:i:s') , " Rename worksheet" , EOL;
82 
+echo date('H:i:s'), " Rename worksheet", EOL;
83 83 
 $objPHPExcel->getActiveSheet()->setTitle('Printing');
84 84
85 85 
 
@@ -88,7 +88,7 @@  discard block
 
 block discarded – undo
88 88
89 89
90 90 
 // Save Excel 2007 file
91 
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
91 
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
92 92 
 $callStartTime = microtime(true);
93 93
94 94 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
 
@@ -96,14 +96,14 @@  discard block
 
 block discarded – undo
96 96 
 $callEndTime = microtime(true);
97 97 
 $callTime = $callEndTime - $callStartTime;
98 98
99 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
100 
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
99 
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
100 
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
101 101 
 // Echo memory usage
102 
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
102 
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
103 103
104 104
105 105 
 // Save Excel 95 file
106 
-echo date('H:i:s') , " Write to Excel5 format" , EOL;
106 
+echo date('H:i:s'), " Write to Excel5 format", EOL;
107 107 
 $callStartTime = microtime(true);
108 108
109 109 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel5');
 
@@ -111,15 +111,15 @@  discard block
 
 block discarded – undo
111 111 
 $callEndTime = microtime(true);
112 112 
 $callTime = $callEndTime - $callStartTime;
113 113
114 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
115 
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
114 
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xls', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
115 
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
116 116 
 // Echo memory usage
117 
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
117 
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
118 118
119 119
120 120 
 // Echo memory peak usage
121 
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
121 
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
122 122
123 123 
 // Echo done
124 
-echo date('H:i:s') , " Done writing files" , EOL;
125 
-echo 'Files have been created in ' , getcwd() , EOL;
124 
+echo date('H:i:s'), " Done writing files", EOL;
125 
+echo 'Files have been created in ', getcwd(), EOL;
Please login to merge, or discard this patch.
Examples/15datavalidation.php 1 patch
Spacing   +20 added lines, -20 removed lines patch added patch discarded remove patch 
@@ -31,7 +31,7 @@  discard block
 
 block discarded – undo
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,12 +40,12 @@  discard block
 
 block discarded – undo
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
47 47 
 // Set document properties
48 
-echo date('H:i:s') , " Set document properties" , EOL;
48 
+echo date('H:i:s'), " Set document properties", EOL;
49 49 
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
50 50 
 							 ->setLastModifiedBy("Maarten Balliauw")
51 51 
 							 ->setTitle("Office 2007 XLSX Test Document")
 
@@ -56,7 +56,7 @@  discard block
 
 block discarded – undo
56 56
57 57
58 58 
 // Create a first sheet
59 
-echo date('H:i:s') , " Add data" , EOL;
59 
+echo date('H:i:s'), " Add data", EOL;
60 60 
 $objPHPExcel->setActiveSheetIndex(0);
61 61 
 $objPHPExcel->getActiveSheet()->setCellValue('A1', "Cell B3 and B5 contain data validation...")
62 62 
                               ->setCellValue('A3', "Number:")
 
@@ -74,10 +74,10 @@  discard block
 
 block discarded – undo
74 74
75 75
76 76 
 // Set data validation
77 
-echo date('H:i:s') , " Set data validation" , EOL;
77 
+echo date('H:i:s'), " Set data validation", EOL;
78 78 
 $objValidation = $objPHPExcel->getActiveSheet()->getCell('B3')->getDataValidation();
79 
-$objValidation->setType( \PHPExcel\Cell\DataValidation::TYPE_WHOLE );
80 
-$objValidation->setErrorStyle( \PHPExcel\Cell\DataValidation::STYLE_STOP );
79 
+$objValidation->setType(\PHPExcel\Cell\DataValidation::TYPE_WHOLE);
80 
+$objValidation->setErrorStyle(\PHPExcel\Cell\DataValidation::STYLE_STOP);
81 81 
 $objValidation->setAllowBlank(true);
82 82 
 $objValidation->setShowInputMessage(true);
83 83 
 $objValidation->setShowErrorMessage(true);
 
@@ -89,8 +89,8 @@  discard block
 
 block discarded – undo
89 89 
 $objValidation->setFormula2(20);
90 90
91 91 
 $objValidation = $objPHPExcel->getActiveSheet()->getCell('B5')->getDataValidation();
92 
-$objValidation->setType( \PHPExcel\Cell\DataValidation::TYPE_LIST );
93 
-$objValidation->setErrorStyle( \PHPExcel\Cell\DataValidation::STYLE_INFORMATION );
92 
+$objValidation->setType(\PHPExcel\Cell\DataValidation::TYPE_LIST);
93 
+$objValidation->setErrorStyle(\PHPExcel\Cell\DataValidation::STYLE_INFORMATION);
94 94 
 $objValidation->setAllowBlank(false);
95 95 
 $objValidation->setShowInputMessage(true);
96 96 
 $objValidation->setShowErrorMessage(true);
 
@@ -99,12 +99,12 @@  discard block
 
 block discarded – undo
99 99 
 $objValidation->setError('Value is not in list.');
100 100 
 $objValidation->setPromptTitle('Pick from list');
101 101 
 $objValidation->setPrompt('Please pick a value from the drop-down list.');
102 
-$objValidation->setFormula1('"Item A,Item B,Item C"');	// Make sure to put the list items between " and " if your list is simply a comma-separated list of values !!!
102 
+$objValidation->setFormula1('"Item A,Item B,Item C"'); // Make sure to put the list items between " and " if your list is simply a comma-separated list of values !!!
103 103
104 104
105 105 
 $objValidation = $objPHPExcel->getActiveSheet()->getCell('B7')->getDataValidation();
106 
-$objValidation->setType( \PHPExcel\Cell\DataValidation::TYPE_LIST );
107 
-$objValidation->setErrorStyle( \PHPExcel\Cell\DataValidation::STYLE_INFORMATION );
106 
+$objValidation->setType(\PHPExcel\Cell\DataValidation::TYPE_LIST);
107 
+$objValidation->setErrorStyle(\PHPExcel\Cell\DataValidation::STYLE_INFORMATION);
108 108 
 $objValidation->setAllowBlank(false);
109 109 
 $objValidation->setShowInputMessage(true);
110 110 
 $objValidation->setShowErrorMessage(true);
 
@@ -113,7 +113,7 @@  discard block
 
 block discarded – undo
113 113 
 $objValidation->setError('Value is not in list.');
114 114 
 $objValidation->setPromptTitle('Pick from list');
115 115 
 $objValidation->setPrompt('Please pick a value from the drop-down list.');
116 
-$objValidation->setFormula1('$D$2:$D$6');	// Make sure NOT to put a range of cells or a formula between " and "  !!!
116 
+$objValidation->setFormula1('$D$2:$D$6'); // Make sure NOT to put a range of cells or a formula between " and "  !!!
117 117
118 118
119 119 
 // Set active sheet index to the first sheet, so Excel opens this as the first sheet
 
@@ -121,7 +121,7 @@  discard block
 
 block discarded – undo
121 121
122 122
123 123 
 // Save Excel 2007 file
124 
-echo date('H:i:s') , " Write to Excel2007 format" , EOL;
124 
+echo date('H:i:s'), " Write to Excel2007 format", EOL;
125 125 
 $callStartTime = microtime(true);
126 126
127 127 
 $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'Excel2007');
 
@@ -129,15 +129,15 @@  discard block
 
 block discarded – undo
129 129 
 $callEndTime = microtime(true);
130 130 
 $callTime = $callEndTime - $callStartTime;
131 131
132 
-echo date('H:i:s') , " File written to " , str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
133 
-echo 'Call time to write Workbook was ' , sprintf('%.4f',$callTime) , " seconds" , EOL;
132 
+echo date('H:i:s'), " File written to ", str_replace('.php', '.xlsx', pathinfo(__FILE__, PATHINFO_BASENAME)), EOL;
133 
+echo 'Call time to write Workbook was ', sprintf('%.4f', $callTime), " seconds", EOL;
134 134 
 // Echo memory usage
135 
-echo date('H:i:s') , ' Current memory usage: ' , (memory_get_usage(true) / 1024 / 1024) , " MB" , EOL;
135 
+echo date('H:i:s'), ' Current memory usage: ', (memory_get_usage(true) / 1024 / 1024), " MB", EOL;
136 136
137 137
138 138 
 // Echo memory peak usage
139 
-echo date('H:i:s') , " Peak memory usage: " , (memory_get_peak_usage(true) / 1024 / 1024) , " MB" , EOL;
139 
+echo date('H:i:s'), " Peak memory usage: ", (memory_get_peak_usage(true) / 1024 / 1024), " MB", EOL;
140 140
141 141 
 // Echo done
142 
-echo date('H:i:s') , " Done writing file" , EOL;
143 
-echo 'File has been created in ' , getcwd() , EOL;
142 
+echo date('H:i:s'), " Done writing file", EOL;
143 
+echo 'File has been created in ', getcwd(), EOL;
Please login to merge, or discard this patch.
Examples/36chartreadwritePDF.php 1 patch
Spacing   +23 added lines, -23 removed lines patch added patch discarded remove patch 
@@ -6,7 +6,7 @@  discard block
 
 block discarded – undo
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
 
 block discarded – undo
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
 
 block discarded – undo
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;
Please login to merge, or discard this patch.
Examples/23sharedstyles.php 1 patch
Spacing   +15 added lines, -15 removed lines patch added patch discarded remove patch 
@@ -31,7 +31,7 @@  discard block
 
 block discarded – undo
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
 
 block discarded – undo
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
 
 block discarded – undo
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
 
 block discarded – undo
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
 
 block discarded – undo
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
 
 block discarded – undo
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;
Please login to merge, or discard this patch.