PHPOffice / PhpSpreadsheet

docs/Examples/Reader/exampleReader08.php

Spacing +4 added lines, -4 removed lines

@@ -31,18 +31,18 @@
 $inputFileName = './sampleData/example1.xls';
 $sheetnames = ['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 />';
 $reader = 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 />';
 $reader->setLoadSheetsOnly($sheetnames);
 $spreadsheet = $reader->load($inputFileName);
 
 echo '<hr />';
 
-echo $spreadsheet->getSheetCount(),' worksheet',(($spreadsheet->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />';
+echo $spreadsheet->getSheetCount(), ' worksheet', (($spreadsheet->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />';
 $loadedSheetNames = $spreadsheet->getSheetNames();
 foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {
-    echo $sheetIndex,' -> ',$loadedSheetName,'<br />';
+    echo $sheetIndex, ' -> ', $loadedSheetName, '<br />';
 }
 
 ?>

docs/Examples/Reader/exampleReader18.php

Spacing +1 added lines, -1 removed lines

@@ -30,7 +30,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 />';
 
 $reader = IOFactory::createReader($inputFileType);
 $worksheetNames = $reader->listWorksheetNames($inputFileName);

docs/Examples/Reader/exampleReader05.php

Spacing +1 added lines, -1 removed lines

@@ -30,7 +30,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 />';
 $reader = IOFactory::createReader($inputFileType);
 echo 'Turning Formatting off for Load<br />';
 $reader->setReadDataOnly(true);

docs/Examples/Reader/exampleReader06.php

Spacing +1 added lines, -1 removed lines

@@ -30,7 +30,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 />';
 $reader = IOFactory::createReader($inputFileType);
 echo 'Loading all WorkSheets<br />';
 $reader->setLoadAllSheets();

docs/Examples/Reader/exampleReader10.php

Spacing +2 added lines, -2 removed lines

@@ -60,9 +60,9 @@
 
 $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 />';
 $reader = IOFactory::createReader($inputFileType);
-echo 'Loading Sheet "',$sheetname,'" only<br />';
+echo 'Loading Sheet "', $sheetname, '" only<br />';
 $reader->setLoadSheetsOnly($sheetname);
 echo 'Loading Sheet using configurable filter<br />';
 $reader->setReadFilter($filterSubset);

docs/Examples/Reader/exampleReader12.php

Spacing +1 added lines, -1 removed lines

@@ -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  **/
 $reader = IOFactory::createReader($inputFileType);
 

docs/Examples/Reader/exampleReader16.php

Spacing +1 added lines, -1 removed lines

@@ -25,7 +25,7 @@
 require_once __DIR__ . '/../../../src/Bootstrap.php';
 
 $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 {
     $spreadsheet = IOFactory::load($inputFileName);
 } catch (InvalidArgumentException $e) {

docs/Examples/Reader/exampleReader02.php

Spacing +1 added lines, -1 removed lines

@@ -25,7 +25,7 @@
 
 $inputFileName = './sampleData/example1.xls';
 
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using \PhpOffice\PhpSpreadsheet\Reader\Xls<br />';
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using \PhpOffice\PhpSpreadsheet\Reader\Xls<br />';
 $reader = new Xls();
 //	$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
 //	$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xml();

src/PhpSpreadsheet/Reader/Html.php

Spacing +7 added lines, -7 removed lines

@@ -443,22 +443,22 @@
                         $this->processDomElement($child, $sheet, $row, $column, $cellContent);
 
                         // add color styles (background & text) from dom element,currently support : td & th, using ONLY inline css style with RGB color
-                        if (isset($attributeArray['style'])){
-                            $styles = explode(';',$attributeArray['style']);
+                        if (isset($attributeArray['style'])) {
+                            $styles = explode(';', $attributeArray['style']);
                             foreach ($styles as $st) {
                                 $value = explode(':', $st);
                                 if (!empty($value[0])) {
-                                    if(trim($value[0])=="background-color" || trim($value[0])=="color" ) {
+                                    if (trim($value[0]) == "background-color" || trim($value[0]) == "color") {
                                         $style_color = null;
                                         //check if has #, so we can get clean hex
-                                        if ( substr(trim($value[1]), 0, 1) == "#" ) {
+                                        if (substr(trim($value[1]), 0, 1) == "#") {
                                             $style_color = substr(trim($value[1]), 1);
                                         }
-                                        if($style_color) {
+                                        if ($style_color) {
                                             if (trim($value[0]) == "background-color") {
-                                                    $sheet->getStyle($column . $row)->applyFromArray( ['fill' => ['type' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID,'color' => ['rgb' => "{$style_color}" ],], ] );
+                                                    $sheet->getStyle($column . $row)->applyFromArray(['fill' => ['type' => \PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID, 'color' => ['rgb' => "{$style_color}"], ], ]);
                                             } elseif (trim($value[0]) == "color") {
-                                                    $sheet->getStyle($column . $row)->applyFromArray( ['font' => ['color' => [ 'rgb' => "$style_color}" ]], ]);
+                                                    $sheet->getStyle($column . $row)->applyFromArray(['font' => ['color' => ['rgb' => "$style_color}"]], ]);
                                             }
                                         }
                                     }