PHPOffice / PhpSpreadsheet

Examples/13calculationCyclicFormulae.php

Indentation +5 added lines, -5 removed lines

@@ -46,9 +46,9 @@ 
 // Add some data, we will use some formulas here
 echo date('H:i:s') , " Add some data and formulas" , EOL;
 $objPHPExcel->getActiveSheet()->setCellValue('A1', '=B1')
-                              ->setCellValue('A2', '=B2+1')
-                              ->setCellValue('B1', '=A1+1')
-                              ->setCellValue('B2', '=A2');
+                                ->setCellValue('A2', '=B2+1')
+                                ->setCellValue('B1', '=A1+1')
+                                ->setCellValue('B2', '=A2');
 
 \PHPExcel\Calculation::getInstance($objPHPExcel)->cyclicFormulaCount = 100;
 
@@ -57,9 +57,9 @@ 
 for($row = 1; $row <= 2; ++$row) {
     for ($col = 'A'; $col != 'C'; ++$col) {
         if ((!is_null($formula = $objPHPExcel->getActiveSheet()->getCell($col.$row)->getValue())) &&
-			($formula[0] == '=')) {
+            ($formula[0] == '=')) {
             echo 'Value of ' , $col , $row , ' [' , $formula , ']: ' ,
-                               $objPHPExcel->getActiveSheet()->getCell($col.$row)->getCalculatedValue() . EOL;
+                                $objPHPExcel->getActiveSheet()->getCell($col.$row)->getCalculatedValue() . EOL;
         }
     }
 }

Examples/15datavalidation-xls.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/runall.php

Indentation +84 added lines, -84 removed lines

@@ -29,104 +29,104 @@
 error_reporting(E_ALL);
 
 if (PHP_SAPI != 'cli') {
-	die ('This script executes all tests, and should only be run from the command line');
+    die ('This script executes all tests, and should only be run from the command line');
 }
 
 // List of tests
 $aTests = array(
-	  '01simple.php'
-	, '01simplePCLZip.php'
-	, '02types.php'
-	, '02types-xls.php'
-	, '03formulas.php'
-	, '04printing.php'
-	, '05featuredemo.php'
-	, '06largescale.php'
-	, '06largescale-with-cellcaching.php'
-	, '06largescale-with-cellcaching-sqlite.php'
-	, '06largescale-with-cellcaching-sqlite3.php'
-	, '06largescale-xls.php'
-	, '07reader.php'
-	, '07readerPCLZip.php'
-	, '08conditionalformatting.php'
-	, '08conditionalformatting2.php'
-	, '09pagebreaks.php'
-	, '10autofilter.php'
-	, '10autofilter-selection-1.php'
-	, '10autofilter-selection-2.php'
-	, '10autofilter-selection-display.php'
-	, '11documentsecurity.php'
-	, '11documentsecurity-xls.php'
-	, '12cellProtection.php'
-	, '13calculation.php'
+        '01simple.php'
+    , '01simplePCLZip.php'
+    , '02types.php'
+    , '02types-xls.php'
+    , '03formulas.php'
+    , '04printing.php'
+    , '05featuredemo.php'
+    , '06largescale.php'
+    , '06largescale-with-cellcaching.php'
+    , '06largescale-with-cellcaching-sqlite.php'
+    , '06largescale-with-cellcaching-sqlite3.php'
+    , '06largescale-xls.php'
+    , '07reader.php'
+    , '07readerPCLZip.php'
+    , '08conditionalformatting.php'
+    , '08conditionalformatting2.php'
+    , '09pagebreaks.php'
+    , '10autofilter.php'
+    , '10autofilter-selection-1.php'
+    , '10autofilter-selection-2.php'
+    , '10autofilter-selection-display.php'
+    , '11documentsecurity.php'
+    , '11documentsecurity-xls.php'
+    , '12cellProtection.php'
+    , '13calculation.php'
     , '13calculationCyclicFormulae.php'
-	, '14excel5.php'
-	, '15datavalidation.php'
-	, '15datavalidation-xls.php'
-	, '16csv.php'
-	, '17html.php'
-	, '18extendedcalculation.php'
-	, '19namedrange.php'
-	, '20readexcel5.php'
-	, '21pdf.php'
-	, '22heavilyformatted.php'
-	, '23sharedstyles.php'
-	, '24readfilter.php'
-	, '25inmemoryimage.php'
-	, '26utf8.php'
-	, '27imagesexcel5.php'
-	, '28iterator.php'
-	, '29advancedvaluebinder.php'
-	, '30template.php'
-	, '31docproperties_write.php'
-	, '31docproperties_write-xls.php'
-	, '32chartreadwrite.php'
-	, '33chartcreate-area.php'
-	, '33chartcreate-bar.php'
-	, '33chartcreate-bar-stacked.php'
-	, '33chartcreate-column.php'
-	, '33chartcreate-column-2.php'
-	, '33chartcreate-line.php'
-	, '33chartcreate-pie.php'
-	, '33chartcreate-radar.php'
-	, '33chartcreate-stock.php'
-	, '33chartcreate-multiple-charts.php'
-	, '33chartcreate-composite.php'
-	, '34chartupdate.php'
-	, '35chartrender.php'
-	, '36chartreadwriteHTML.php'
-	, '36chartreadwritePDF.php'
-	, '37page_layout_view.php'
-	, '38cloneWorksheet.php'
+    , '14excel5.php'
+    , '15datavalidation.php'
+    , '15datavalidation-xls.php'
+    , '16csv.php'
+    , '17html.php'
+    , '18extendedcalculation.php'
+    , '19namedrange.php'
+    , '20readexcel5.php'
+    , '21pdf.php'
+    , '22heavilyformatted.php'
+    , '23sharedstyles.php'
+    , '24readfilter.php'
+    , '25inmemoryimage.php'
+    , '26utf8.php'
+    , '27imagesexcel5.php'
+    , '28iterator.php'
+    , '29advancedvaluebinder.php'
+    , '30template.php'
+    , '31docproperties_write.php'
+    , '31docproperties_write-xls.php'
+    , '32chartreadwrite.php'
+    , '33chartcreate-area.php'
+    , '33chartcreate-bar.php'
+    , '33chartcreate-bar-stacked.php'
+    , '33chartcreate-column.php'
+    , '33chartcreate-column-2.php'
+    , '33chartcreate-line.php'
+    , '33chartcreate-pie.php'
+    , '33chartcreate-radar.php'
+    , '33chartcreate-stock.php'
+    , '33chartcreate-multiple-charts.php'
+    , '33chartcreate-composite.php'
+    , '34chartupdate.php'
+    , '35chartrender.php'
+    , '36chartreadwriteHTML.php'
+    , '36chartreadwritePDF.php'
+    , '37page_layout_view.php'
+    , '38cloneWorksheet.php'
     , '39dropdown.php'
-	, '40duplicateStyle.php'
-	, '41password.php'
-	, '42richText.php'
+    , '40duplicateStyle.php'
+    , '41password.php'
+    , '42richText.php'
     , '43mergeWorkbooks.php'
     , '44worksheetInfo.php'
-	, 'OOCalcReader.php'
-	, 'OOCalcReaderPCLZip.php'
-	, 'SylkReader.php'
-	, 'Excel2003XMLReader.php'
-	, 'XMLReader.php'
-	, 'GnumericReader.php'
+    , 'OOCalcReader.php'
+    , 'OOCalcReaderPCLZip.php'
+    , 'SylkReader.php'
+    , 'Excel2003XMLReader.php'
+    , 'XMLReader.php'
+    , 'GnumericReader.php'
 );
 
 // First, clear all previous run results
 foreach ($aTests as $sTest) {
-	@unlink( str_replace('.php', '.xls', 	$sTest) );
-	@unlink( str_replace('.php', '.xlsx', 	$sTest) );
-	@unlink( str_replace('.php', '.csv',	$sTest) );
-	@unlink( str_replace('.php', '.htm',	$sTest) );
-	@unlink( str_replace('.php', '.pdf',	$sTest) );
+    @unlink( str_replace('.php', '.xls', 	$sTest) );
+    @unlink( str_replace('.php', '.xlsx', 	$sTest) );
+    @unlink( str_replace('.php', '.csv',	$sTest) );
+    @unlink( str_replace('.php', '.htm',	$sTest) );
+    @unlink( str_replace('.php', '.pdf',	$sTest) );
 }
 
 // Run all tests
 foreach ($aTests as $sTest) {
-	echo '============== TEST ==============' . "\r\n";
-	echo 'Test name: ' . $sTest . "\r\n";
-	echo "\r\n";
-	echo shell_exec('php ' . $sTest);
-	echo "\r\n";
-	echo "\r\n";
+    echo '============== TEST ==============' . "\r\n";
+    echo 'Test name: ' . $sTest . "\r\n";
+    echo "\r\n";
+    echo shell_exec('php ' . $sTest);
+    echo "\r\n";
+    echo "\r\n";
 }
\ No newline at end of file

Examples/33chartcreate-column-2.php

Indentation +36 added lines, -36 removed lines

@@ -43,21 +43,21 @@ 
 $objPHPExcel = new \PHPExcel\Spreadsheet();
 $objWorksheet = $objPHPExcel->getActiveSheet();
 $objWorksheet->fromArray(
-	array(
-		array('',		'',		'Budget',	'Forecast',	'Actual'),
-		array('2010',	'Q1',   47,   		44,			43		),
-		array('',		'Q2',   56,   		53,			50		),
-		array('',		'Q3',   52,   		46,			45		),
-		array('',		'Q4',   45,   		40,			40		),
-		array('2011',	'Q1',   51,   		42,			46		),
-		array('',		'Q2',   53,   		58,			56		),
-		array('',		'Q3',   64,   		66,			69		),
-		array('',		'Q4',   54,   		55,			56		),
-		array('2012',	'Q1',   49,   		52,			58		),
-		array('',		'Q2',   68,   		73,			86		),
-		array('',		'Q3',   72,   		78,			0		),
-		array('',		'Q4',   50,   		60,			0		),
-	)
+    array(
+        array('',		'',		'Budget',	'Forecast',	'Actual'),
+        array('2010',	'Q1',   47,   		44,			43		),
+        array('',		'Q2',   56,   		53,			50		),
+        array('',		'Q3',   52,   		46,			45		),
+        array('',		'Q4',   45,   		40,			40		),
+        array('2011',	'Q1',   51,   		42,			46		),
+        array('',		'Q2',   53,   		58,			56		),
+        array('',		'Q3',   64,   		66,			69		),
+        array('',		'Q4',   54,   		55,			56		),
+        array('2012',	'Q1',   49,   		52,			58		),
+        array('',		'Q2',   68,   		73,			86		),
+        array('',		'Q3',   72,   		78,			0		),
+        array('',		'Q4',   50,   		60,			0		),
+    )
 );
 
 //	Set the Labels for each data series we want to plot
@@ -68,9 +68,9 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesLabels = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	'Budget'
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	'Forecast'
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$E$1', NULL, 1),	//	'Actual'
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$C$1', NULL, 1),	//	'Budget'
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$D$1', NULL, 1),	//	'Forecast'
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$E$1', NULL, 1),	//	'Actual'
 );
 //	Set the X-Axis Labels
 //		Datatype
@@ -80,7 +80,7 @@ 
 //		Data values
 //		Data Marker
 $xAxisTickValues = array(
-	new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$B$13', NULL, 12),	//	Q1 to Q4 for 2010 to 2012
+    new \PHPExcel\Chart\DataSeriesValues('String', 'Worksheet!$A$2:$B$13', NULL, 12),	//	Q1 to Q4 for 2010 to 2012
 );
 //	Set the Data values for each data series we want to plot
 //		Datatype
@@ -90,19 +90,19 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesValues = array(
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$13', NULL, 12),
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$13', NULL, 12),
-	new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$E$2:$E$13', NULL, 12),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$C$2:$C$13', NULL, 12),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$D$2:$D$13', NULL, 12),
+    new \PHPExcel\Chart\DataSeriesValues('Number', 'Worksheet!$E$2:$E$13', NULL, 12),
 );
 
 //	Build the dataseries
 $series = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
-	\PHPExcel\Chart\DataSeries::GROUPING_CLUSTERED,	// plotGrouping
-	range(0, count($dataSeriesValues)-1),			// plotOrder
-	$dataSeriesLabels,								// plotLabel
-	$xAxisTickValues,								// plotCategory
-	$dataSeriesValues								// plotValues
+    \PHPExcel\Chart\DataSeries::TYPE_BARCHART,		// plotType
+    \PHPExcel\Chart\DataSeries::GROUPING_CLUSTERED,	// plotGrouping
+    range(0, count($dataSeriesValues)-1),			// plotOrder
+    $dataSeriesLabels,								// plotLabel
+    $xAxisTickValues,								// plotCategory
+    $dataSeriesValues								// plotValues
 );
 //	Set additional dataseries parameters
 //		Make it a vertical column rather than a horizontal bar graph
@@ -120,14 +120,14 @@ 
 
 //	Create the chart
 $chart = new \PHPExcel\Chart(
-	'chart1',		// name
-	$title,			// title
-	$legend,		// legend
-	$plotArea,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	$xAxisLabel,	// xAxisLabel
-	$yAxisLabel		// yAxisLabel
+    'chart1',		// name
+    $title,			// title
+    $legend,		// legend
+    $plotArea,		// plotArea
+    true,			// plotVisibleOnly
+    0,				// displayBlanksAs
+    $xAxisLabel,	// xAxisLabel
+    $yAxisLabel		// yAxisLabel
 );
 
 //	Set the position where the chart should appear in the worksheet

Examples/33chartcreate-scatter.php

Indentation +30 added lines, -30 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),
+    )
 );
 
 //	Set the Labels for each data series we want to plot
@@ -60,13 +60,13 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesLabels = 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
 $xAxisTickValues = 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
@@ -76,21 +76,21 @@ 
 //		Data values
 //		Data Marker
 $dataSeriesValues = 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
 $series = new \PHPExcel\Chart\DataSeries(
-	\PHPExcel\Chart\DataSeries::TYPE_SCATTERCHART,	// plotType
-	NULL,											// plotGrouping (Scatter charts don't have any grouping)
-	range(0, count($dataSeriesValues)-1),			// plotOrder
-	$dataSeriesLabels,								// plotLabel
-	$xAxisTickValues,								// plotCategory
-	$dataSeriesValues,								// plotValues
-	NULL,											// smooth line
-	\PHPExcel\Chart\DataSeries::STYLE_LINEMARKER		// plotStyle
+    \PHPExcel\Chart\DataSeries::TYPE_SCATTERCHART,	// plotType
+    NULL,											// plotGrouping (Scatter charts don't have any grouping)
+    range(0, count($dataSeriesValues)-1),			// plotOrder
+    $dataSeriesLabels,								// plotLabel
+    $xAxisTickValues,								// plotCategory
+    $dataSeriesValues,								// plotValues
+    NULL,											// smooth line
+    \PHPExcel\Chart\DataSeries::STYLE_LINEMARKER		// plotStyle
 );
 
 //	Set the series in the plot area
@@ -104,14 +104,14 @@ 
 
 //	Create the chart
 $chart = new \PHPExcel\Chart(
-	'chart1',		// name
-	$title,			// title
-	$legend,		// legend
-	$plotArea,		// plotArea
-	true,			// plotVisibleOnly
-	0,				// displayBlanksAs
-	NULL,			// xAxisLabel
-	$yAxisLabel		// yAxisLabel
+    'chart1',		// name
+    $title,			// title
+    $legend,		// legend
+    $plotArea,		// plotArea
+    true,			// plotVisibleOnly
+    0,				// displayBlanksAs
+    NULL,			// xAxisLabel
+    $yAxisLabel		// yAxisLabel
 );
 
 //	Set the position where the chart should appear in the worksheet

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/44worksheetInfo.php

Indentation +1 added lines, -1 removed lines

@@ -37,7 +37,7 @@
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
 
 if (!file_exists("05featuredemo.xlsx")) {
-	exit("Please run 05featuredemo.php first." . EOL);
+    exit("Please run 05featuredemo.php first." . EOL);
 }
 
 $inputFileName = "05featuredemo.xlsx";

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/04printing.php

Indentation +8 added lines, -8 removed lines

@@ -45,19 +45,19 @@
 // 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, we will use printing features
 echo date('H:i:s') , " Add some data" , EOL;
 for ($i = 1; $i < 200; $i++) {
-	$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $i);
-	$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, 'Test value');
+    $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, $i);
+    $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, 'Test value');
 }
 
 // Set header and footer. When no different headers for odd/even are used, odd header is assumed.