PHPOffice / PhpSpreadsheet

Documentation/Examples/Reader/exampleReader08.php

Spacing +6 added lines, -6 removed lines

@@ -32,21 +32,21 @@
 //	$inputFileType = 'OOCalc';

 //	$inputFileType = 'Gnumeric';

 $inputFileName = './sampleData/example1.xls';

-$sheetnames = array('Data Sheet #1','Data Sheet #3');

+$sheetnames = array('Data Sheet #1', 'Data Sheet #3');

 

-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';

+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';

 $objReader = PHPExcel_IOFactory::createReader($inputFileType);

-echo 'Loading Sheet',((count($sheetnames) == 1) ? '' : 's'),' "',implode('" and "',$sheetnames),'" only<br />';

+echo 'Loading Sheet', ((count($sheetnames) == 1) ? '' : 's'), ' "', implode('" and "', $sheetnames), '" only<br />';

 $objReader->setLoadSheetsOnly($sheetnames);

 $objPHPExcel = $objReader->load($inputFileName);

 

 

 echo '<hr />';

 

-echo $objPHPExcel->getSheetCount(),' worksheet',(($objPHPExcel->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';

+echo $objPHPExcel->getSheetCount(), ' worksheet', (($objPHPExcel->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';

 $loadedSheetNames = $objPHPExcel->getSheetNames();

-foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {

-	echo $sheetIndex,' -> ',$loadedSheetName,'<br />';

+foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {

+	echo $sheetIndex, ' -> ', $loadedSheetName, '<br />';

 }

 

 

Documentation/Examples/Reader/exampleReader14.php

Spacing +11 added lines, -11 removed lines

@@ -33,8 +33,8 @@ 
 

 	/**  Set the list of rows that we want to read  */

 	public function setRows($startRow, $chunkSize) {

-		$this->_startRow	= $startRow;

-		$this->_endRow		= $startRow + $chunkSize;

+		$this->_startRow = $startRow;

+		$this->_endRow = $startRow + $chunkSize;

 	}

 

 	public function readCell($column, $row, $worksheetName = '') {

@@ -47,7 +47,7 @@ 
 }

 

 

-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';

+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';

 /**  Create a new Reader of the type defined in $inputFileType  **/

 $objReader = PHPExcel_IOFactory::createReader($inputFileType);

 

@@ -74,28 +74,28 @@ 
 /**  Loop to read our worksheet in "chunk size" blocks  **/

 /**  $startRow is set to 2 initially because we always read the headings in row #1  **/

 for ($startRow = 2; $startRow <= 240; $startRow += $chunkSize) {

-	echo 'Loading WorkSheet #',($sheet+1),' using configurable filter for headings row 1 and for rows ',$startRow,' to ',($startRow+$chunkSize-1),'<br />';

+	echo 'Loading WorkSheet #', ($sheet + 1), ' using configurable filter for headings row 1 and for rows ', $startRow, ' to ', ($startRow + $chunkSize - 1), '<br />';

 	/**  Tell the Read Filter, the limits on which rows we want to read this iteration  **/

-	$chunkFilter->setRows($startRow,$chunkSize);

+	$chunkFilter->setRows($startRow, $chunkSize);

 

     /**  Increment the worksheet index pointer for the Reader  **/

     $objReader->setSheetIndex($sheet);

 	/**  Load only the rows that match our filter into a new worksheet in the PHPExcel Object  **/

-    $objReader->loadIntoExisting($inputFileName,$objPHPExcel);

+    $objReader->loadIntoExisting($inputFileName, $objPHPExcel);

     /**  Set the worksheet title (to reference the "sheet" of data that we've loaded)  **/

     /**    and increment the sheet index as well  **/

-    $objPHPExcel->getActiveSheet()->setTitle('Country Data #'.(++$sheet));

+    $objPHPExcel->getActiveSheet()->setTitle('Country Data #' . (++$sheet));

 }

 

 

 echo '<hr />';

 

-echo $objPHPExcel->getSheetCount(),' worksheet',(($objPHPExcel->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';

+echo $objPHPExcel->getSheetCount(), ' worksheet', (($objPHPExcel->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';

 $loadedSheetNames = $objPHPExcel->getSheetNames();

-foreach($loadedSheetNames as $sheetIndex => $loadedSheetName) {

-	echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,'</b><br />';

+foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {

+	echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, '</b><br />';

 	$objPHPExcel->setActiveSheetIndexByName($loadedSheetName);

-	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,false,false,true);

+	$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, false, false, true);

 	var_dump($sheetData);

 	echo '<br />';

 }

Documentation/Examples/Reader/exampleReader05.php

Spacing +2 added lines, -2 removed lines

@@ -33,7 +33,7 @@ 
 //	$inputFileType = 'Gnumeric';

 $inputFileName = './sampleData/example1.xls';

 

-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';

+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';

 $objReader = PHPExcel_IOFactory::createReader($inputFileType);

 echo 'Turning Formatting off for Load<br />';

 $objReader->setReadDataOnly(true);

@@ -42,7 +42,7 @@ 
 

 echo '<hr />';

 

-$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

+$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);

 var_dump($sheetData);

 

 

Documentation/Examples/Reader/exampleReader19.php

Spacing +1 added lines, -1 removed lines

@@ -33,7 +33,7 @@
 //	$inputFileType = 'Gnumeric';
 $inputFileName = './sampleData/example1.xls';
 
-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' information using IOFactory with a defined reader type of ',$inputFileType,'<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' information using IOFactory with a defined reader type of ', $inputFileType, '<br />';
 
 $objReader = PHPExcel_IOFactory::createReader($inputFileType);
 $worksheetData = $objReader->listWorksheetInfo($inputFileName);

Documentation/Examples/index.php

Spacing +8 added lines, -8 removed lines

@@ -17,15 +17,15 @@ 
 

 <?php

 

-$exampleTypeList = glob('./*',GLOB_ONLYDIR);

+$exampleTypeList = glob('./*', GLOB_ONLYDIR);

 

-foreach($exampleTypeList as $exampleType) {

+foreach ($exampleTypeList as $exampleType) {

 

-	echo '<h1>PHPExcel ' . pathinfo($exampleType,PATHINFO_BASENAME) . ' Examples</h1>';

+	echo '<h1>PHPExcel ' . pathinfo($exampleType, PATHINFO_BASENAME) . ' Examples</h1>';

 

-	$exampleList = glob('./'.$exampleType.'/*.php');

+	$exampleList = glob('./' . $exampleType . '/*.php');

 

-	foreach($exampleList as $exampleFile) {

+	foreach ($exampleList as $exampleFile) {

 		$fileData = file_get_contents($exampleFile);

 

 		$h1Pattern = '#<h1>(.*?)</h1>#';

@@ -35,10 +35,10 @@ 
 			$h1Text = $out[1];

 			$h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';

 

-			echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';

+			echo '<a href="', $exampleFile, '">', $h1Text, '</a><br />';

 			if (($h2Text > '') &&

-				(pathinfo($exampleType,PATHINFO_BASENAME) != 'Calculations')) {

-				echo $h2Text,'<br />';

+				(pathinfo($exampleType, PATHINFO_BASENAME) != 'Calculations')) {

+				echo $h2Text, '<br />';

 			}

 		}

 

Documentation/Examples/Reader/exampleReader18.php

Spacing +1 added lines, -1 removed lines

@@ -33,7 +33,7 @@
 //	$inputFileType = 'Gnumeric';
 $inputFileName = './sampleData/example1.xls';
 
-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' information using IOFactory with a defined reader type of ',$inputFileType,'<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' information using IOFactory with a defined reader type of ', $inputFileType, '<br />';
 
 $objReader = PHPExcel_IOFactory::createReader($inputFileType);
 $worksheetData = $objReader->listWorksheetInfo($inputFileName);

Documentation/Examples/Reader/exampleReader03.php

Spacing +2 added lines, -2 removed lines

@@ -33,7 +33,7 @@ 
 //	$inputFileType = 'Gnumeric';

 $inputFileName = './sampleData/example1.xls';

 

-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />';

+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />';

 $objReader = PHPExcel_IOFactory::createReader($inputFileType);

 echo 'Turning Formatting off for Load<br />';

 $objReader->setReadDataOnly(true);

@@ -42,7 +42,7 @@ 
 

 echo '<hr />';

 

-$sheetData = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);

+$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);

 var_dump($sheetData);

 

 

Documentation/Examples/Calculations/Database/DPRODUCT.php

Spacing +17 added lines, -17 removed lines

@@ -32,21 +32,21 @@ 
 $worksheet = $objPHPExcel->getActiveSheet();

 

 // Add some data

-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),

-                   array( 'Apple',  18,       20,    14,      105.00  ),

-                   array( 'Pear',   12,       12,    10,       96.00  ),

-                   array( 'Cherry', 13,       14,     9,      105.00  ),

-                   array( 'Apple',  14,       15,    10,       75.00  ),

-                   array( 'Pear',    9,        8,     8,       76.80  ),

-                   array( 'Apple',   8,        9,     6,       45.00  ),

+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),

+                   array('Apple', 18, 20, 14, 105.00),

+                   array('Pear', 12, 12, 10, 96.00),

+                   array('Cherry', 13, 14, 9, 105.00),

+                   array('Apple', 14, 15, 10, 75.00),

+                   array('Pear', 9, 8, 8, 76.80),

+                   array('Apple', 8, 9, 6, 45.00),

                  );

-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),

-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),

-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )

+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),

+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),

+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)

                  );

 

-$worksheet->fromArray( $criteria, NULL, 'A1' );

-$worksheet->fromArray( $database, NULL, 'A4' );

+$worksheet->fromArray($criteria, NULL, 'A1');

+$worksheet->fromArray($database, NULL, 'A4');

 

 $worksheet->setCellValue('A12', 'The height of the Apple tree between 10\' and 16\' tall');

 $worksheet->setCellValue('B12', '=DGET(A4:E10,"Height",A1:F2)');

@@ -57,7 +57,7 @@ 
 

 echo '<h4>Database</h4>';

 

-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);

+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);

 var_dump($databaseData);

 

 

@@ -69,15 +69,15 @@ 
 

 echo 'ALL' . '<br /><br />';

 

-echo $worksheet->getCell("A12")->getValue() .'<br />';

-echo 'DMAX() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';

+echo $worksheet->getCell("A12")->getValue() . '<br />';

+echo 'DMAX() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';

 

 echo '<h4>Criteria</h4>';

 

-$criteriaData = $worksheet->rangeToArray('A1:A2',null,true,true,true);

+$criteriaData = $worksheet->rangeToArray('A1:A2', null, true, true, true);

 var_dump($criteriaData);

 

-echo $worksheet->getCell("A13")->getValue() .'<br />';

+echo $worksheet->getCell("A13")->getValue() . '<br />';

 echo 'DMAX() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();

 

 

Documentation/Examples/Calculations/Database/DMAX.php

Spacing +17 added lines, -17 removed lines

@@ -32,21 +32,21 @@ 
 $worksheet = $objPHPExcel->getActiveSheet();

 

 // Add some data

-$database = array( array( 'Tree',  'Height', 'Age', 'Yield', 'Profit' ),

-                   array( 'Apple',  18,       20,    14,      105.00  ),

-                   array( 'Pear',   12,       12,    10,       96.00  ),

-                   array( 'Cherry', 13,       14,     9,      105.00  ),

-                   array( 'Apple',  14,       15,    10,       75.00  ),

-                   array( 'Pear',    9,        8,     8,       76.80  ),

-                   array( 'Apple',   8,        9,     6,       45.00  ),

+$database = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit'),

+                   array('Apple', 18, 20, 14, 105.00),

+                   array('Pear', 12, 12, 10, 96.00),

+                   array('Cherry', 13, 14, 9, 105.00),

+                   array('Apple', 14, 15, 10, 75.00),

+                   array('Pear', 9, 8, 8, 76.80),

+                   array('Apple', 8, 9, 6, 45.00),

                  );

-$criteria = array( array( 'Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height' ),

-                   array( '="=Apple"', '>10',    NULL,  NULL,    NULL,     '<16'    ),

-                   array( '="=Pear"',  NULL,     NULL,  NULL,    NULL,     NULL     )

+$criteria = array(array('Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'),

+                   array('="=Apple"', '>10', NULL, NULL, NULL, '<16'),

+                   array('="=Pear"', NULL, NULL, NULL, NULL, NULL)

                  );

 

-$worksheet->fromArray( $criteria, NULL, 'A1' );

-$worksheet->fromArray( $database, NULL, 'A4' );

+$worksheet->fromArray($criteria, NULL, 'A1');

+$worksheet->fromArray($database, NULL, 'A4');

 

 $worksheet->setCellValue('A12', 'The height of the Apple tree between 10\' and 16\' tall');

 $worksheet->setCellValue('B12', '=DGET(A4:E10,"Height",A1:F2)');

@@ -57,7 +57,7 @@ 
 

 echo '<h4>Database</h4>';

 

-$databaseData = $worksheet->rangeToArray('A4:E10',null,true,true,true);

+$databaseData = $worksheet->rangeToArray('A4:E10', null, true, true, true);

 var_dump($databaseData);

 

 

@@ -69,15 +69,15 @@ 
 

 echo 'ALL' . '<br /><br />';

 

-echo $worksheet->getCell("A12")->getValue() .'<br />';

-echo 'DMAX() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() .'<br /><br />';

+echo $worksheet->getCell("A12")->getValue() . '<br />';

+echo 'DMAX() Result is ' . $worksheet->getCell("B12")->getCalculatedValue() . '<br /><br />';

 

 echo '<h4>Criteria</h4>';

 

-$criteriaData = $worksheet->rangeToArray('A1:A2',null,true,true,true);

+$criteriaData = $worksheet->rangeToArray('A1:A2', null, true, true, true);

 var_dump($criteriaData);

 

-echo $worksheet->getCell("A13")->getValue() .'<br />';

+echo $worksheet->getCell("A13")->getValue() . '<br />';

 echo 'DMAX() Result is ' . $worksheet->getCell("B13")->getCalculatedValue();