PHPOffice / PhpSpreadsheet

Examples/36chartreadwriteHTML.php

Indentation +80 added lines, -80 removed lines

@@ -22,14 +22,14 @@ 
 
 
 if (!PHPExcel\Settings::setChartRenderer(
-		$rendererName,
-		$rendererLibraryPath
-	)) {
-	die(
-		'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
-		EOL .
-		'at the top of this script as appropriate for your directory structure'
-	);
+        $rendererName,
+        $rendererLibraryPath
+    )) {
+    die(
+        'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
+        EOL .
+        'at the top of this script as appropriate for your directory structure'
+    );
 }
 
 
@@ -37,81 +37,81 @@ 
 $inputFileNames = 'templates/36write*.xlsx';
 
 if ((isset($argc)) && ($argc > 1)) {
-	$inputFileNames = array();
-	for($i = 1; $i < $argc; ++$i) {
-		$inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i];
-	}
+    $inputFileNames = array();
+    for($i = 1; $i < $argc; ++$i) {
+        $inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i];
+    }
 } else {
-	$inputFileNames = glob($inputFileNames);
+    $inputFileNames = glob($inputFileNames);
 }
 foreach($inputFileNames as $inputFileName) {
-	$inputFileNameShort = basename($inputFileName);
-
-	if (!file_exists($inputFileName)) {
-		echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL;
-		continue;
-	}
-
-	echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL;
-
-	$objReader = \PHPExcel\IOFactory::createReader($inputFileType);
-	$objReader->setIncludeCharts(TRUE);
-	$objPHPExcel = $objReader->load($inputFileName);
-
-
-	echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL;
-	foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
-		$sheetName = $worksheet->getTitle();
-		echo 'Worksheet: ' , $sheetName , EOL;
-
-		$chartNames = $worksheet->getChartNames();
-		if(empty($chartNames)) {
-			echo '    There are no charts in this worksheet' , EOL;
-		} else {
-			natsort($chartNames);
-			foreach($chartNames as $i => $chartName) {
-				$chart = $worksheet->getChartByName($chartName);
-				if (!is_null($chart->getTitle())) {
-					$caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"';
-				} else {
-					$caption = 'Untitled';
-				}
-				echo '    ' , $chartName , ' - ' , $caption , EOL;
-				echo str_repeat(' ',strlen($chartName)+3);
-				$groupCount = $chart->getPlotArea()->getPlotGroupCount();
-				if ($groupCount == 1) {
-					$chartType = $chart->getPlotArea()->getPlotGroupByIndex(0)->getPlotType();
-					echo '    ' , $chartType , EOL;
-				} else {
-					$chartTypes = array();
-					for($i = 0; $i < $groupCount; ++$i) {
-						$chartTypes[] = $chart->getPlotArea()->getPlotGroupByIndex($i)->getPlotType();
-					}
-					$chartTypes = array_unique($chartTypes);
-					if (count($chartTypes) == 1) {
-						$chartType = 'Multiple Plot ' . array_pop($chartTypes);
-						echo '    ' , $chartType , EOL;
-					} elseif (count($chartTypes) == 0) {
-						echo '    *** Type not yet implemented' , EOL;
-					} else {
-						echo '    Combination Chart' , EOL;
-					}
-				}
-			}
-		}
-	}
-
-
-	$outputFileName = str_replace('.xlsx', '.html', basename($inputFileName));
-
-	echo date('H:i:s') , " Write Tests to HTML file " , EOL;
-	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'HTML');
-	$objWriter->setIncludeCharts(TRUE);
-	$objWriter->save($outputFileName);
-	echo date('H:i:s') , " File written to " , $outputFileName , EOL;
-
-	$objPHPExcel->disconnectWorksheets();
-	unset($objPHPExcel);
+    $inputFileNameShort = basename($inputFileName);
+
+    if (!file_exists($inputFileName)) {
+        echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL;
+        continue;
+    }
+
+    echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL;
+
+    $objReader = \PHPExcel\IOFactory::createReader($inputFileType);
+    $objReader->setIncludeCharts(TRUE);
+    $objPHPExcel = $objReader->load($inputFileName);
+
+
+    echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL;
+    foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
+        $sheetName = $worksheet->getTitle();
+        echo 'Worksheet: ' , $sheetName , EOL;
+
+        $chartNames = $worksheet->getChartNames();
+        if(empty($chartNames)) {
+            echo '    There are no charts in this worksheet' , EOL;
+        } else {
+            natsort($chartNames);
+            foreach($chartNames as $i => $chartName) {
+                $chart = $worksheet->getChartByName($chartName);
+                if (!is_null($chart->getTitle())) {
+                    $caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"';
+                } else {
+                    $caption = 'Untitled';
+                }
+                echo '    ' , $chartName , ' - ' , $caption , EOL;
+                echo str_repeat(' ',strlen($chartName)+3);
+                $groupCount = $chart->getPlotArea()->getPlotGroupCount();
+                if ($groupCount == 1) {
+                    $chartType = $chart->getPlotArea()->getPlotGroupByIndex(0)->getPlotType();
+                    echo '    ' , $chartType , EOL;
+                } else {
+                    $chartTypes = array();
+                    for($i = 0; $i < $groupCount; ++$i) {
+                        $chartTypes[] = $chart->getPlotArea()->getPlotGroupByIndex($i)->getPlotType();
+                    }
+                    $chartTypes = array_unique($chartTypes);
+                    if (count($chartTypes) == 1) {
+                        $chartType = 'Multiple Plot ' . array_pop($chartTypes);
+                        echo '    ' , $chartType , EOL;
+                    } elseif (count($chartTypes) == 0) {
+                        echo '    *** Type not yet implemented' , EOL;
+                    } else {
+                        echo '    Combination Chart' , EOL;
+                    }
+                }
+            }
+        }
+    }
+
+
+    $outputFileName = str_replace('.xlsx', '.html', basename($inputFileName));
+
+    echo date('H:i:s') , " Write Tests to HTML file " , EOL;
+    $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'HTML');
+    $objWriter->setIncludeCharts(TRUE);
+    $objWriter->save($outputFileName);
+    echo date('H:i:s') , " File written to " , $outputFileName , EOL;
+
+    $objPHPExcel->disconnectWorksheets();
+    unset($objPHPExcel);
 }
 
 // Echo memory peak usage

Examples/08conditionalformatting2.php

Indentation +9 added lines, -9 removed lines

@@ -45,12 +45,12 @@ 
 // Set document properties
 echo date('H:i:s') , " Set document properties" , EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
-							 ->setLastModifiedBy("Maarten Balliauw")
-							 ->setTitle("Office 2007 XLSX Test Document")
-							 ->setSubject("Office 2007 XLSX Test Document")
-							 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
-							 ->setKeywords("office 2007 openxml php")
-							 ->setCategory("Test result file");
+                                ->setLastModifiedBy("Maarten Balliauw")
+                                ->setTitle("Office 2007 XLSX Test Document")
+                                ->setSubject("Office 2007 XLSX Test Document")
+                                ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
+                                ->setKeywords("office 2007 openxml php")
+                                ->setCategory("Test result file");
 
 
 // Create a first sheet, representing sales data
@@ -97,9 +97,9 @@ 
 //	duplicate the conditional styles across a range of cells
 echo date('H:i:s') , " Duplicate the conditional formatting across a range of cells" , EOL;
 $objPHPExcel->getActiveSheet()->duplicateConditionalStyle(
-				$objPHPExcel->getActiveSheet()->getStyle('A1')->getConditionalStyles(),
-				'A2:A8'
-			  );
+                $objPHPExcel->getActiveSheet()->getStyle('A1')->getConditionalStyles(),
+                'A2:A8'
+                );
 
 
 // Save Excel 2007 file

Examples/15datavalidation.php

Indentation +18 added lines, -18 removed lines

@@ -47,30 +47,30 @@
 // Set document properties
 echo date('H:i:s') , " Set document properties" , EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
-							 ->setLastModifiedBy("Maarten Balliauw")
-							 ->setTitle("Office 2007 XLSX Test Document")
-							 ->setSubject("Office 2007 XLSX Test Document")
-							 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
-							 ->setKeywords("office 2007 openxml php")
-							 ->setCategory("Test result file");
+                                ->setLastModifiedBy("Maarten Balliauw")
+                                ->setTitle("Office 2007 XLSX Test Document")
+                                ->setSubject("Office 2007 XLSX Test Document")
+                                ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
+                                ->setKeywords("office 2007 openxml php")
+                                ->setCategory("Test result file");
 
 
 // Create a first sheet
 echo date('H:i:s') , " Add data" , EOL;
 $objPHPExcel->setActiveSheetIndex(0);
 $objPHPExcel->getActiveSheet()->setCellValue('A1', "Cell B3 and B5 contain data validation...")
-                              ->setCellValue('A3', "Number:")
-                              ->setCellValue('B3', "10")
-                              ->setCellValue('A5', "List:")
-                              ->setCellValue('B5', "Item A")
-                              ->setCellValue('A7', "List #2:")
-                              ->setCellValue('B7', "Item #2")
-                              ->setCellValue('D2', "Item #1")
-                              ->setCellValue('D3', "Item #2")
-                              ->setCellValue('D4', "Item #3")
-                              ->setCellValue('D5', "Item #4")
-                              ->setCellValue('D6', "Item #5")
-                              ;
+                                ->setCellValue('A3', "Number:")
+                                ->setCellValue('B3', "10")
+                                ->setCellValue('A5', "List:")
+                                ->setCellValue('B5', "Item A")
+                                ->setCellValue('A7', "List #2:")
+                                ->setCellValue('B7', "Item #2")
+                                ->setCellValue('D2', "Item #1")
+                                ->setCellValue('D3', "Item #2")
+                                ->setCellValue('D4', "Item #3")
+                                ->setCellValue('D5', "Item #4")
+                                ->setCellValue('D6', "Item #5")
+                                ;
 
 
 // Set data validation

Examples/36chartreadwritePDF.php

Indentation +88 added lines, -88 removed lines

@@ -26,14 +26,14 @@ 
 
 
 if (!PHPExcel\Settings::setPdfRenderer(
-		$rendererName,
-		$rendererLibraryPath
-	)) {
-	die(
-		'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
-		EOL .
-		'at the top of this script as appropriate for your directory structure'
-	);
+        $rendererName,
+        $rendererLibraryPath
+    )) {
+    die(
+        'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
+        EOL .
+        'at the top of this script as appropriate for your directory structure'
+    );
 }
 
 
@@ -45,14 +45,14 @@ 
 
 
 if (!PHPExcel\Settings::setChartRenderer(
-		$rendererName,
-		$rendererLibraryPath
-	)) {
-	die(
-		'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
-		EOL .
-		'at the top of this script as appropriate for your directory structure'
-	);
+        $rendererName,
+        $rendererLibraryPath
+    )) {
+    die(
+        'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
+        EOL .
+        'at the top of this script as appropriate for your directory structure'
+    );
 }
 
 
@@ -60,81 +60,81 @@ 
 $inputFileNames = 'templates/36write*.xlsx';
 
 if ((isset($argc)) && ($argc > 1)) {
-	$inputFileNames = array();
-	for($i = 1; $i < $argc; ++$i) {
-		$inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i];
-	}
+    $inputFileNames = array();
+    for($i = 1; $i < $argc; ++$i) {
+        $inputFileNames[] = dirname(__FILE__) . '/templates/' . $argv[$i];
+    }
 } else {
-	$inputFileNames = glob($inputFileNames);
+    $inputFileNames = glob($inputFileNames);
 }
 foreach($inputFileNames as $inputFileName) {
-	$inputFileNameShort = basename($inputFileName);
-
-	if (!file_exists($inputFileName)) {
-		echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL;
-		continue;
-	}
-
-	echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL;
-
-	$objReader = \PHPExcel\IOFactory::createReader($inputFileType);
-	$objReader->setIncludeCharts(TRUE);
-	$objPHPExcel = $objReader->load($inputFileName);
-
-
-	echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL;
-	foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
-		$sheetName = $worksheet->getTitle();
-		echo 'Worksheet: ' , $sheetName , EOL;
-
-		$chartNames = $worksheet->getChartNames();
-		if(empty($chartNames)) {
-			echo '    There are no charts in this worksheet' , EOL;
-		} else {
-			natsort($chartNames);
-			foreach($chartNames as $i => $chartName) {
-				$chart = $worksheet->getChartByName($chartName);
-				if (!is_null($chart->getTitle())) {
-					$caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"';
-				} else {
-					$caption = 'Untitled';
-				}
-				echo '    ' , $chartName , ' - ' , $caption , EOL;
-				echo str_repeat(' ',strlen($chartName)+3);
-				$groupCount = $chart->getPlotArea()->getPlotGroupCount();
-				if ($groupCount == 1) {
-					$chartType = $chart->getPlotArea()->getPlotGroupByIndex(0)->getPlotType();
-					echo '    ' , $chartType , EOL;
-				} else {
-					$chartTypes = array();
-					for($i = 0; $i < $groupCount; ++$i) {
-						$chartTypes[] = $chart->getPlotArea()->getPlotGroupByIndex($i)->getPlotType();
-					}
-					$chartTypes = array_unique($chartTypes);
-					if (count($chartTypes) == 1) {
-						$chartType = 'Multiple Plot ' . array_pop($chartTypes);
-						echo '    ' , $chartType , EOL;
-					} elseif (count($chartTypes) == 0) {
-						echo '    *** Type not yet implemented' , EOL;
-					} else {
-						echo '    Combination Chart' , EOL;
-					}
-				}
-			}
-		}
-	}
-
-
-	$outputFileName = str_replace('.xlsx', '.pdf', basename($inputFileName));
-
-	echo date('H:i:s') , " Write Tests to HTML file " , EOL;
-	$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF');
-	$objWriter->setIncludeCharts(TRUE);
-	$objWriter->save($outputFileName);
-	echo date('H:i:s') , " File written to " , $outputFileName , EOL;
-
-	$objPHPExcel->disconnectWorksheets();
-	unset($objPHPExcel);
+    $inputFileNameShort = basename($inputFileName);
+
+    if (!file_exists($inputFileName)) {
+        echo date('H:i:s') , " File " , $inputFileNameShort , ' does not exist' , EOL;
+        continue;
+    }
+
+    echo date('H:i:s') , " Load Test from $inputFileType file " , $inputFileNameShort , EOL;
+
+    $objReader = \PHPExcel\IOFactory::createReader($inputFileType);
+    $objReader->setIncludeCharts(TRUE);
+    $objPHPExcel = $objReader->load($inputFileName);
+
+
+    echo date('H:i:s') , " Iterate worksheets looking at the charts" , EOL;
+    foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
+        $sheetName = $worksheet->getTitle();
+        echo 'Worksheet: ' , $sheetName , EOL;
+
+        $chartNames = $worksheet->getChartNames();
+        if(empty($chartNames)) {
+            echo '    There are no charts in this worksheet' , EOL;
+        } else {
+            natsort($chartNames);
+            foreach($chartNames as $i => $chartName) {
+                $chart = $worksheet->getChartByName($chartName);
+                if (!is_null($chart->getTitle())) {
+                    $caption = '"' . implode(' ',$chart->getTitle()->getCaption()) . '"';
+                } else {
+                    $caption = 'Untitled';
+                }
+                echo '    ' , $chartName , ' - ' , $caption , EOL;
+                echo str_repeat(' ',strlen($chartName)+3);
+                $groupCount = $chart->getPlotArea()->getPlotGroupCount();
+                if ($groupCount == 1) {
+                    $chartType = $chart->getPlotArea()->getPlotGroupByIndex(0)->getPlotType();
+                    echo '    ' , $chartType , EOL;
+                } else {
+                    $chartTypes = array();
+                    for($i = 0; $i < $groupCount; ++$i) {
+                        $chartTypes[] = $chart->getPlotArea()->getPlotGroupByIndex($i)->getPlotType();
+                    }
+                    $chartTypes = array_unique($chartTypes);
+                    if (count($chartTypes) == 1) {
+                        $chartType = 'Multiple Plot ' . array_pop($chartTypes);
+                        echo '    ' , $chartType , EOL;
+                    } elseif (count($chartTypes) == 0) {
+                        echo '    *** Type not yet implemented' , EOL;
+                    } else {
+                        echo '    Combination Chart' , EOL;
+                    }
+                }
+            }
+        }
+    }
+
+
+    $outputFileName = str_replace('.xlsx', '.pdf', basename($inputFileName));
+
+    echo date('H:i:s') , " Write Tests to HTML file " , EOL;
+    $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF');
+    $objWriter->setIncludeCharts(TRUE);
+    $objWriter->save($outputFileName);
+    echo date('H:i:s') , " File written to " , $outputFileName , EOL;
+
+    $objPHPExcel->disconnectWorksheets();
+    unset($objPHPExcel);
 }
 
 // Echo memory peak usage

Examples/23sharedstyles.php

Indentation +24 added lines, -24 removed lines

@@ -46,12 +46,12 @@ 
 // Set document properties
 echo date('H:i:s') , " Set document properties" , EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
-							 ->setLastModifiedBy("Maarten Balliauw")
-							 ->setTitle("Office 2007 XLSX Test Document")
-							 ->setSubject("Office 2007 XLSX Test Document")
-							 ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
-							 ->setKeywords("office 2007 openxml php")
-							 ->setCategory("Test result file");
+                                ->setLastModifiedBy("Maarten Balliauw")
+                                ->setTitle("Office 2007 XLSX Test Document")
+                                ->setSubject("Office 2007 XLSX Test Document")
+                                ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
+                                ->setKeywords("office 2007 openxml php")
+                                ->setCategory("Test result file");
 
 
 // Add some data
@@ -62,26 +62,26 @@ 
 $sharedStyle2 = new \PHPExcel\Style();
 
 $sharedStyle1->applyFromArray(
-	array('fill' 	=> array(
-								'type'		=> \PHPExcel\Style\Fill::FILL_SOLID,
-								'color'		=> array('argb' => 'FFCCFFCC')
-							),
-		  'borders' => array(
-								'bottom'	=> array('style' => \PHPExcel\Style\Border::BORDER_THIN),
-								'right'		=> array('style' => \PHPExcel\Style\Border::BORDER_MEDIUM)
-							)
-		 ));
+    array('fill' 	=> array(
+                                'type'		=> \PHPExcel\Style\Fill::FILL_SOLID,
+                                'color'		=> array('argb' => 'FFCCFFCC')
+                            ),
+            'borders' => array(
+                                'bottom'	=> array('style' => \PHPExcel\Style\Border::BORDER_THIN),
+                                'right'		=> array('style' => \PHPExcel\Style\Border::BORDER_MEDIUM)
+                            )
+            ));
 
 $sharedStyle2->applyFromArray(
-	array('fill' 	=> array(
-								'type'		=> \PHPExcel\Style\Fill::FILL_SOLID,
-								'color'		=> array('argb' => 'FFFFFF00')
-							),
-		  'borders' => array(
-								'bottom'	=> array('style' => \PHPExcel\Style\Border::BORDER_THIN),
-								'right'		=> array('style' => \PHPExcel\Style\Border::BORDER_MEDIUM)
-							)
-		 ));
+    array('fill' 	=> array(
+                                'type'		=> \PHPExcel\Style\Fill::FILL_SOLID,
+                                'color'		=> array('argb' => 'FFFFFF00')
+                            ),
+            'borders' => array(
+                                'bottom'	=> array('style' => \PHPExcel\Style\Border::BORDER_THIN),
+                                'right'		=> array('style' => \PHPExcel\Style\Border::BORDER_MEDIUM)
+                            )
+            ));
 
 $objPHPExcel->getActiveSheet()->duplicateStyle($sharedStyle1, "A1:T100");
 $objPHPExcel->getActiveSheet()->duplicateStyle($sharedStyle2, "C5:R95");

Examples/02types.php

Indentation +6 added lines, -6 removed lines

@@ -45,12 +45,12 @@
 echo date('H:i:s') , " Set document properties" , EOL;
 $objPHPExcel->getProperties()
     ->setCreator("Maarten Balliauw")
-	->setLastModifiedBy("Maarten Balliauw")
-	->setTitle("Office 2007 XLSX Test Document")
-	->setSubject("Office 2007 XLSX Test Document")
-	->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
-	->setKeywords("office 2007 openxml php")
-	->setCategory("Test result file");
+    ->setLastModifiedBy("Maarten Balliauw")
+    ->setTitle("Office 2007 XLSX Test Document")
+    ->setSubject("Office 2007 XLSX Test Document")
+    ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
+    ->setKeywords("office 2007 openxml php")
+    ->setCategory("Test result file");
 
 // Set default font
 echo date('H:i:s') , " Set default font" , EOL;

Examples/33chartcreate-multiple-charts.php

Indentation +49 added lines, -49 removed lines

@@ -43,13 +43,13 @@ 
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 $objWorksheet = $objPHPExcel->getActiveSheet();
 $objWorksheet->fromArray(
-	array(
-		array('',	2010,	2011,	2012),
-		array('Q1',   12,   15,		21),
-		array('Q2',   56,   73,		86),
-		array('Q3',   52,   61,		69),
-		array('Q4',   30,   32,		0),
-	)
+    array(
+        array('',	2010,	2011,	2012),
+        array('Q1',   12,   15,		21),
+        array('Q2',   56,   73,		86),
+        array('Q3',   52,   61,		69),
+        array('Q4',   30,   32,		0),
+    )
 );
 
 
@@ -61,9 +61,9 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesLabels1 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1),	//	2010
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	2011
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	2012
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1),	//	2010
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	2011
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	2012
 );
 //	Set the X-Axis Labels
 //		Datatype
@@ -73,7 +73,7 @@ 
 //		Data values
 //		Data Marker
 $xAxisTickValues1 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -83,19 +83,19 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesValues1 = array(
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4),
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4),
 );
 
 //	Build the dataseries
 $series1 = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_AREACHART,				// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_PERCENT_STACKED,	// plotGrouping
-	range(0, count($dataSeriesValues1)-1),					// plotOrder
-	$dataSeriesLabels1,										// plotLabel
-	$xAxisTickValues1,										// plotCategory
-	$dataSeriesValues1										// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_AREACHART,				// plotType
+    \PHPExcel\Chart\DataSeries::GROUPING_PERCENT_STACKED,	// plotGrouping
+    range(0, count($dataSeriesValues1)-1),					// plotOrder
+    $dataSeriesLabels1,										// plotLabel
+    $xAxisTickValues1,										// plotCategory
+    $dataSeriesValues1										// plotValues
 );
 
 //	Set the series in the plot area
@@ -109,14 +109,14 @@ 
 
 //	Create the chart
 $chart1 = new \PHPExcel\Chart(
-	'chart1',		// name
-	$title1,		// title
-	$legend1,		// legend
-	$plotArea1,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	NULL,			// xAxisLabel
-	$yAxisLabel1	// yAxisLabel
+    'chart1',		// name
+    $title1,		// title
+    $legend1,		// legend
+    $plotArea1,		// plotArea
+    true,			// plotVisibleOnly
+    0,				// displayBlanksAs
+    NULL,			// xAxisLabel
+    $yAxisLabel1	// yAxisLabel
 );
 
 //	Set the position where the chart should appear in the worksheet
@@ -135,9 +135,9 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesLabels2 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1),	//	2010
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	2011
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	2012
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$B$1', NULL, 1),	//	2010
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	2011
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	2012
 );
 //	Set the X-Axis Labels
 //		Datatype
@@ -147,7 +147,7 @@ 
 //		Data values
 //		Data Marker
 $xAxisTickValues2 = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$A$5', NULL, 4),	//	Q1 to Q4
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -157,19 +157,19 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesValues2 = array(
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4),
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$B$2:$B$5', NULL, 4),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$5', NULL, 4),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$5', NULL, 4),
 );
 
 //	Build the dataseries
 $series2 = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_STANDARD,	// plotGrouping
-	range(0, count($dataSeriesValues2)-1),			// plotOrder
-	$dataSeriesLabels2,								// plotLabel
-	$xAxisTickValues2,								// plotCategory
-	$dataSeriesValues2								// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
+    \PHPExcel\Chart\DataSeries::GROUPING_STANDARD,	// plotGrouping
+    range(0, count($dataSeriesValues2)-1),			// plotOrder
+    $dataSeriesLabels2,								// plotLabel
+    $xAxisTickValues2,								// plotCategory
+    $dataSeriesValues2								// plotValues
 );
 //	Set additional dataseries parameters
 //		Make it a vertical column rather than a horizontal bar graph
@@ -186,14 +186,14 @@ 
 
 //	Create the chart
 $chart2 = new \PHPExcel\Chart(
-	'chart2',		// name
-	$title2,		// title
-	$legend2,		// legend
-	$plotArea2,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	NULL,			// xAxisLabel
-	$yAxisLabel2	// yAxisLabel
+    'chart2',		// name
+    $title2,		// title
+    $legend2,		// legend
+    $plotArea2,		// plotArea
+    true,			// plotVisibleOnly
+    0,				// displayBlanksAs
+    NULL,			// xAxisLabel
+    $yAxisLabel2	// yAxisLabel
 );
 
 //	Set the position where the chart should appear in the worksheet

Examples/20readexcel5.php

Indentation +1 added lines, -1 removed lines

@@ -40,7 +40,7 @@
 

 

 if (!file_exists("14excel5.xls")) {

-	exit("Please run 14excel5.php first.\n");

+    exit("Please run 14excel5.php first.\n");

 }

 

 echo date('H:i:s') , " Load workbook from Excel5 file" , EOL;

Examples/Quadratic2.php

Indentation +19 added lines, -19 removed lines

@@ -33,30 +33,30 @@
 <?php

 /**	If the user has submitted the form, then we need to execute a calculation **/

 if (isset($_POST['submit'])) {

-	if ($_POST['A'] == 0) {

-		echo 'The equation is not quadratic';

-	} else {

-		/**	So we include PHPExcel to perform the calculations	**/

-		include 'PHPExcel/Calculation.php';

+    if ($_POST['A'] == 0) {

+        echo 'The equation is not quadratic';

+    } else {

+        /**	So we include PHPExcel to perform the calculations	**/

+        include 'PHPExcel/Calculation.php';

 

-		/**	Calculate and Display the results			**/

-		echo '<hr /><b>Roots:</b><br />';

+        /**	Calculate and Display the results			**/

+        echo '<hr /><b>Roots:</b><br />';

 

-		$callStartTime = microtime(true);

-		$discriminantFormula = '=POWER('.$_POST['B'].',2) - (4 * '.$_POST['A'].' * '.$_POST['C'].')';

-		$discriminant = PHPExcel_Calculation::getInstance()->calculateFormula($discriminantFormula);

+        $callStartTime = microtime(true);

+        $discriminantFormula = '=POWER('.$_POST['B'].',2) - (4 * '.$_POST['A'].' * '.$_POST['C'].')';

+        $discriminant = PHPExcel_Calculation::getInstance()->calculateFormula($discriminantFormula);

 

-		$r1Formula = '=IMDIV(IMSUM(-'.$_POST['B'].',IMSQRT('.$discriminant.')),2 * '.$_POST['A'].')';

-		$r2Formula = '=IF('.$discriminant.'=0,"Only one root",IMDIV(IMSUB(-'.$_POST['B'].',IMSQRT('.$discriminant.')),2 * '.$_POST['A'].'))';

+        $r1Formula = '=IMDIV(IMSUM(-'.$_POST['B'].',IMSQRT('.$discriminant.')),2 * '.$_POST['A'].')';

+        $r2Formula = '=IF('.$discriminant.'=0,"Only one root",IMDIV(IMSUB(-'.$_POST['B'].',IMSQRT('.$discriminant.')),2 * '.$_POST['A'].'))';

 

-		echo PHPExcel_Calculation::getInstance()->calculateFormula($r1Formula).'<br />';

-		echo PHPExcel_Calculation::getInstance()->calculateFormula($r2Formula).'<br />';

-		$callEndTime = microtime(true);

-		$callTime = $callEndTime - $callStartTime;

+        echo PHPExcel_Calculation::getInstance()->calculateFormula($r1Formula).'<br />';

+        echo PHPExcel_Calculation::getInstance()->calculateFormula($r2Formula).'<br />';

+        $callEndTime = microtime(true);

+        $callTime = $callEndTime - $callStartTime;

 

-		echo '<hr />Call time for Quadratic Equation Solution was '.sprintf('%.4f',$callTime).' seconds<br /><hr />';

-		echo ' Peak memory usage: '.(memory_get_peak_usage(true) / 1024 / 1024).' MB<br />';

-	}

+        echo '<hr />Call time for Quadratic Equation Solution was '.sprintf('%.4f',$callTime).' seconds<br /><hr />';

+        echo ' Peak memory usage: '.(memory_get_peak_usage(true) / 1024 / 1024).' MB<br />';

+    }

 }

 

 ?>