PHPOffice / PhpSpreadsheet

Examples/26utf8.php

Indentation +16 added lines, -16 removed lines

@@ -77,23 +77,23 @@
 // Export to PDF (.pdf)
 echo date('H:i:s') , " Write to PDF format" , EOL;
 try {
-	if (!\PHPExcel\Settings::setPdfRenderer(
-		$rendererName,
-		$rendererLibraryPath
-	)) {
-		echo (
-			'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
-			EOL .
-			'at the top of this script as appropriate for your directory structure' .
-			EOL
-		);
-	} else {
-		$objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF');
-		$objWriter->save(str_replace('.php', '.pdf', __FILE__));
-		echo date('H:i:s') , " File written to " , str_replace('.php', '.pdf', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
-	}
+    if (!\PHPExcel\Settings::setPdfRenderer(
+        $rendererName,
+        $rendererLibraryPath
+    )) {
+        echo (
+            'NOTICE: Please set the $rendererName and $rendererLibraryPath values' .
+            EOL .
+            'at the top of this script as appropriate for your directory structure' .
+            EOL
+        );
+    } else {
+        $objWriter = \PHPExcel\IOFactory::createWriter($objPHPExcel, 'PDF');
+        $objWriter->save(str_replace('.php', '.pdf', __FILE__));
+        echo date('H:i:s') , " File written to " , str_replace('.php', '.pdf', pathinfo(__FILE__, PATHINFO_BASENAME)) , EOL;
+    }
 } catch (Exception $e) {
-	echo date('H:i:s') , ' EXCEPTION: ', $e->getMessage() , EOL;
+    echo date('H:i:s') , ' EXCEPTION: ', $e->getMessage() , EOL;
 }
 
 // Remove first two rows with field headers before exporting to CSV

Examples/06largescale-with-cellcaching-sqlite.php

Indentation +13 added lines, -13 removed lines

@@ -52,12 +52,12 @@ 
 // Set document properties
 echo date('H:i:s') , " Set 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
@@ -79,8 +79,8 @@ 
 // Set outline levels
 echo date('H:i:s') , " Set outline levels" , EOL;
 $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1)
-                                                       ->setVisible(false)
-                                                       ->setCollapsed(true);
+                                                        ->setVisible(false)
+                                                        ->setCollapsed(true);
 
 // Freeze panes
 echo date('H:i:s') , " Freeze panes" , EOL;
@@ -94,11 +94,11 @@ 
 
 // Add data
 for ($i = 2; $i <= 5000; $i++) {
-	$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
-	                              ->setCellValue('B' . $i, "LName $i")
-	                              ->setCellValue('C' . $i, "PhoneNo $i")
-	                              ->setCellValue('D' . $i, "FaxNo $i")
-	                              ->setCellValue('E' . $i, true);
+    $objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "FName $i")
+                                    ->setCellValue('B' . $i, "LName $i")
+                                    ->setCellValue('C' . $i, "PhoneNo $i")
+                                    ->setCellValue('D' . $i, "FaxNo $i")
+                                    ->setCellValue('E' . $i, true);
 }
 
 

Examples/33chartcreate-bar.php

Indentation +28 added lines, -28 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,9 +60,9 @@ 
 //		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
 //		Datatype
@@ -72,7 +72,7 @@ 
 //		Data values
 //		Data Marker
 $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
@@ -82,19 +82,19 @@ 
 //		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_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 horizontal bar rather than a vertical column graph
@@ -111,14 +111,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/37page_layout_view.php

Indentation +6 added lines, -6 removed lines

@@ -44,12 +44,12 @@
 // Set document properties
 echo date('H:i:s') , " Set document properties" , EOL;
 $objPHPExcel->getProperties()->setCreator("PHPOffice")
-							 ->setLastModifiedBy("PHPOffice")
-							 ->setTitle("PHPExcel Test Document")
-							 ->setSubject("PHPExcel Test Document")
-							 ->setDescription("Test document for PHPExcel, generated using PHP classes.")
-							 ->setKeywords("Office PHPExcel php")
-							 ->setCategory("Test result file");
+                                ->setLastModifiedBy("PHPOffice")
+                                ->setTitle("PHPExcel Test Document")
+                                ->setSubject("PHPExcel Test Document")
+                                ->setDescription("Test document for PHPExcel, generated using PHP classes.")
+                                ->setKeywords("Office PHPExcel php")
+                                ->setCategory("Test result file");
 
 
 // Add some data

Examples/42richText.php

Indentation +6 added lines, -6 removed lines

@@ -44,12 +44,12 @@
 // Set document properties
 echo date('H:i:s') , " Set document properties" , EOL;
 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
-	->setLastModifiedBy("Maarten Balliauw")
-	->setTitle("PHPExcel Test Document")
-	->setSubject("PHPExcel Test Document")
-	->setDescription("Test document for PHPExcel, generated using PHP classes.")
-	->setKeywords("office PHPExcel php")
-	->setCategory("Test result file");
+    ->setLastModifiedBy("Maarten Balliauw")
+    ->setTitle("PHPExcel Test Document")
+    ->setSubject("PHPExcel Test Document")
+    ->setDescription("Test document for PHPExcel, generated using PHP classes.")
+    ->setKeywords("office PHPExcel php")
+    ->setCategory("Test result file");
 
 
 // Add some data

Examples/39dropdown.php

Indentation +6 added lines, -6 removed lines

@@ -45,12 +45,12 @@
 echo date('H:i:s') , " Set document properties" , EOL;
 $objPHPExcel->getProperties()
     ->setCreator("PHPOffice")
-	->setLastModifiedBy("PHPOffice")
-	->setTitle("PHPExcel Test Document")
-	->setSubject("PHPExcel Test Document")
-	->setDescription("Test document for PHPExcel, generated using PHP classes.")
-	->setKeywords("Office PHPExcel php")
-	->setCategory("Test result file");
+    ->setLastModifiedBy("PHPOffice")
+    ->setTitle("PHPExcel Test Document")
+    ->setSubject("PHPExcel Test Document")
+    ->setDescription("Test document for PHPExcel, generated using PHP classes.")
+    ->setKeywords("Office PHPExcel php")
+    ->setCategory("Test result file");
 
 
 function transpose($value) {

Examples/Quadratic.php

Indentation +21 added lines, -21 removed lines

@@ -33,33 +33,33 @@
 <?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/IOFactory.php';

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

+        echo 'The equation is not quadratic';

+    } else {

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

+        include 'PHPExcel/IOFactory.php';

 

-		/**	Load the quadratic equation solver worksheet into memory			**/

-		$objPHPExcel = \PHPExcel\IOFactory::load('./Quadratic.xlsx');

+        /**	Load the quadratic equation solver worksheet into memory			**/

+        $objPHPExcel = \PHPExcel\IOFactory::load('./Quadratic.xlsx');

 

-		/**	Set our A, B and C values			**/

-		$objPHPExcel->getActiveSheet()->setCellValue('A1', $_POST['A']);

-		$objPHPExcel->getActiveSheet()->setCellValue('B1', $_POST['B']);

-		$objPHPExcel->getActiveSheet()->setCellValue('C1', $_POST['C']);

+        /**	Set our A, B and C values			**/

+        $objPHPExcel->getActiveSheet()->setCellValue('A1', $_POST['A']);

+        $objPHPExcel->getActiveSheet()->setCellValue('B1', $_POST['B']);

+        $objPHPExcel->getActiveSheet()->setCellValue('C1', $_POST['C']);

 

 

-		/**	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);

-		echo $objPHPExcel->getActiveSheet()->getCell('B5')->getCalculatedValue().'<br />';

-		echo $objPHPExcel->getActiveSheet()->getCell('B6')->getCalculatedValue().'<br />';

-		$callEndTime = microtime(true);

-		$callTime = $callEndTime - $callStartTime;

+        $callStartTime = microtime(true);

+        echo $objPHPExcel->getActiveSheet()->getCell('B5')->getCalculatedValue().'<br />';

+        echo $objPHPExcel->getActiveSheet()->getCell('B6')->getCalculatedValue().'<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 />';

+    }

 }

 

 ?>

Examples/07reader.php

Indentation +1 added lines, -1 removed lines

@@ -38,7 +38,7 @@
 
 
 if (!file_exists("05featuredemo.xlsx")) {
-	exit("Please run 05featuredemo.php first." . EOL);
+    exit("Please run 05featuredemo.php first." . EOL);
 }
 
 echo date('H:i:s') , " Load from Excel2007 file" , EOL;

Examples/34chartupdate.php

Indentation +9 added lines, -9 removed lines

@@ -40,7 +40,7 @@ 
 require_once dirname(__FILE__) . '/../src/Bootstrap.php';
 
 if (!file_exists("33chartcreate-bar.xlsx")) {
-	exit("Please run 33chartcreate-bar.php first." . EOL);
+    exit("Please run 33chartcreate-bar.php first." . EOL);
 }
 
 echo date('H:i:s') , " Load from Excel2007 file" , EOL;
@@ -52,14 +52,14 @@ 
 echo date('H:i:s') , " Update cell data values that are displayed in the chart" , EOL;
 $objWorksheet = $objPHPExcel->getActiveSheet();
 $objWorksheet->fromArray(
-	array(
-		array(50-12,   50-15,		50-21),
-		array(50-56,   50-73,		50-86),
-		array(50-52,   50-61,		50-69),
-		array(50-30,   50-32,		50),
-	),
-	NULL,
-	'B2'
+    array(
+        array(50-12,   50-15,		50-21),
+        array(50-56,   50-73,		50-86),
+        array(50-52,   50-61,		50-69),
+        array(50-30,   50-32,		50),
+    ),
+    NULL,
+    'B2'
 );
 
 // Save Excel 2007 file