PHPOffice / PhpSpreadsheet

Documentation/Examples/Reader/exampleReader15.php

Spacing +13 added lines, -13 removed lines

@@ -21,47 +21,47 @@
 include 'PHPExcel/IOFactory.php';

 

 

-PHPExcel_Cell::setValueBinder( new PHPExcel_Cell_AdvancedValueBinder() );

+PHPExcel_Cell::setValueBinder(new PHPExcel_Cell_AdvancedValueBinder());

 

 

 $inputFileType = 'CSV';

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

 

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

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

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

 $objReader->setDelimiter("\t");

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

-$objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName,PATHINFO_BASENAME));

+$objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME));

 

 

 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,' (Formatted)</b><br />';

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

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

 	$objPHPExcel->setActiveSheetIndexByName($loadedSheetName);

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

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

 	var_dump($sheetData);

 	echo '<br />';

 }

 

 echo '<hr />';

 

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

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

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

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

 	$objPHPExcel->setActiveSheetIndexByName($loadedSheetName);

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

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

 	var_dump($sheetData);

 	echo '<br />';

 }

 

 echo '<hr />';

 

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

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

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

+	echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, ' (Raw)</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/exampleReader06.php

Spacing +4 added lines, -4 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 'Loading all WorkSheets<br />';

 $objReader->setLoadAllSheets();

@@ -42,10 +42,10 @@ 
 

 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/exampleReader11.php

Spacing +6 added lines, -6 removed lines

@@ -43,8 +43,8 @@ 
 

 	/**  We expect a list of the rows that we want to read to be passed into the constructor  */

 	public function __construct($startRow, $chunkSize) {

-		$this->_startRow	= $startRow;

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

+		$this->_startRow = $startRow;

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

 	}

 

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

@@ -57,7 +57,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);

 

@@ -70,9 +70,9 @@ 
 

 /**  Loop to read our worksheet in "chunk size" blocks  **/

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

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

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

 	/**  Create a new Instance of our Read Filter, passing in the limits on which rows we want to read  **/

-	$chunkFilter = new chunkReadFilter($startRow,$chunkSize);

+	$chunkFilter = new chunkReadFilter($startRow, $chunkSize);

 	/**  Tell the Reader that we want to use the new Read Filter that we've just Instantiated  **/

 	$objReader->setReadFilter($chunkFilter);

 	/**  Load only the rows that match our filter from $inputFileName to a PHPExcel Object  **/

@@ -80,7 +80,7 @@ 
 

 	//	Do some processing here

 

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

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

 	var_dump($sheetData);

 	echo '<br /><br />';

 }

Documentation/Examples/Reader/exampleReader16.php

Spacing +4 added lines, -4 removed lines

@@ -27,17 +27,17 @@
 

 

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

-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' using IOFactory to identify the format<br />';

+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory to identify the format<br />';

 try {

 	$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);

-} catch(\PHPExcel\Reader\Exception $e) {

-	die('Error loading file "'.pathinfo($inputFileName,PATHINFO_BASENAME).'": '.$e->getMessage());

+} catch (\PHPExcel\Reader\Exception $e) {

+	die('Error loading file "' . pathinfo($inputFileName, PATHINFO_BASENAME) . '": ' . $e->getMessage());

 }

 

 

 echo '<hr />';

 

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

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

 var_dump($sheetData);

 

 

Documentation/Examples/Reader/exampleReader12.php

Spacing +6 added lines, -6 removed lines

@@ -43,8 +43,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 = '') {

@@ -57,7 +57,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);

 

@@ -75,15 +75,15 @@ 
 

 /**  Loop to read our worksheet in "chunk size" blocks  **/

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

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

+	echo 'Loading WorkSheet 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);

 	/**  Load only the rows that match our filter from $inputFileName to a PHPExcel Object  **/

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

 

 	//	Do some processing here

 

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

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

 	var_dump($sheetData);

 	echo '<br /><br />';

 }

Documentation/Examples/Reader/exampleReader04.php

Spacing +3 added lines, -3 removed lines

@@ -29,16 +29,16 @@
 $inputFileName = './sampleData/example1.xls';

 

 $inputFileType = PHPExcel_IOFactory::identify($inputFileName);

-echo 'File ',pathinfo($inputFileName,PATHINFO_BASENAME),' has been identified as an ',$inputFileType,' file<br />';

+echo 'File ', pathinfo($inputFileName, PATHINFO_BASENAME), ' has been identified as an ', $inputFileType, ' file<br />';

 

-echo 'Loading file ',pathinfo($inputFileName,PATHINFO_BASENAME),' using IOFactory with the identified reader type<br />';

+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with the identified reader type<br />';

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

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

 

 

 echo '<hr />';

 

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

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

 var_dump($sheetData);

 

 

Documentation/Examples/Reader/exampleReader07.php

Spacing +5 added lines, -5 removed lines

@@ -34,19 +34,19 @@
 $inputFileName = './sampleData/example1.xls';

 $sheetname = 'Data Sheet #2';

 

-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 "',$sheetname,'" only<br />';

+echo 'Loading Sheet "', $sheetname, '" only<br />';

 $objReader->setLoadSheetsOnly($sheetname);

 $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/exampleReader10.php

Spacing +6 added lines, -6 removed lines

@@ -45,13 +45,13 @@ 
 

 	public function __construct($startRow, $endRow, $columns) {

 		$this->_startRow	= $startRow;

-		$this->_endRow		= $endRow;

+		$this->_endRow = $endRow;

 		$this->_columns		= $columns;

 	}

 

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

 		if ($row >= $this->_startRow && $row <= $this->_endRow) {

-			if (in_array($column,$this->_columns)) {

+			if (in_array($column, $this->_columns)) {

 				return true;

 			}

 		}

@@ -59,12 +59,12 @@ 
 	}

 }

 

-$filterSubset = new MyReadFilter(9,15,range('G','K'));

+$filterSubset = new MyReadFilter(9, 15, range('G', 'K'));

 

 

-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 "',$sheetname,'" only<br />';

+echo 'Loading Sheet "', $sheetname, '" only<br />';

 $objReader->setLoadSheetsOnly($sheetname);

 echo 'Loading Sheet using configurable filter<br />';

 $objReader->setReadFilter($filterSubset);

@@ -73,7 +73,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/exampleReader17.php

Spacing +4 added lines, -4 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);

 

 

@@ -41,9 +41,9 @@ 
 echo 'Read the list of Worksheets in the WorkBook<br />';

 $worksheetNames = $objReader->listWorksheetNames($inputFileName);

 

-echo 'There are ',count($worksheetNames),' worksheet',((count($worksheetNames) == 1) ? '' : 's'),' in the workbook<br /><br />';

-foreach($worksheetNames as $worksheetName) {

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

+echo 'There are ', count($worksheetNames), ' worksheet', ((count($worksheetNames) == 1) ? '' : 's'), ' in the workbook<br /><br />';

+foreach ($worksheetNames as $worksheetName) {

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

 }