PHPOffice / PhpSpreadsheet

src/PhpSpreadsheet/Reader/BaseReader.php

Spacing +3 added lines, -3 removed lines

@@ -239,13 +239,13 @@ 
     {
         // Check if file exists
         if (!file_exists($pFilename) || !is_readable($pFilename)) {
-            throw new Exception('Could not open '.$pFilename.' for reading! File does not exist.');
+            throw new Exception('Could not open ' . $pFilename . ' for reading! File does not exist.');
         }
 
         // Open file
         $this->fileHandle = fopen($pFilename, 'r');
         if ($this->fileHandle === false) {
-            throw new Exception('Could not open file '.$pFilename.' for reading.');
+            throw new Exception('Could not open file ' . $pFilename . ' for reading.');
         }
     }
 
@@ -258,7 +258,7 @@ 
      */
     public function securityScan($xml)
     {
-        $pattern = '/\\0?'.implode('\\0?', str_split('<!DOCTYPE')).'\\0?/';
+        $pattern = '/\\0?' . implode('\\0?', str_split('<!DOCTYPE')) . '\\0?/';
         if (preg_match($pattern, $xml)) {
             throw new Exception('Detected use of ENTITY in XML, spreadsheet file load() aborted to prevent XXE/XEE attacks');
         }

src/PhpSpreadsheet/Reader/SYLK.php

Spacing +9 added lines, -9 removed lines

@@ -131,7 +131,7 @@ 
     {
         // Open file
         if (!$this->canRead($pFilename)) {
-            throw new Exception($pFilename.' is an Invalid Spreadsheet file.');
+            throw new Exception($pFilename . ' is an Invalid Spreadsheet file.');
         }
         $this->openFile($pFilename);
         $fileHandle = $this->fileHandle;
@@ -221,7 +221,7 @@ 
     {
         // Open file
         if (!$this->canRead($pFilename)) {
-            throw new Exception($pFilename.' is an Invalid Spreadsheet file.');
+            throw new Exception($pFilename . ' is an Invalid Spreadsheet file.');
         }
         $this->openFile($pFilename);
         $fileHandle = $this->fileHandle;
@@ -292,7 +292,7 @@ 
                             break;
                     }
                 }
-                $this->formats['P'.$this->format++] = $formatArray;
+                $this->formats['P' . $this->format++] = $formatArray;
             //    Read cell value data
             } elseif ($dataType == 'C') {
                 $hasCalculatedValue = false;
@@ -311,7 +311,7 @@ 
                             $cellData = substr($rowDatum, 1);
                             break;
                         case 'E':
-                            $cellDataFormula = '='.substr($rowDatum, 1);
+                            $cellDataFormula = '=' . substr($rowDatum, 1);
                             //    Convert R1C1 style references to A1 style references (but only when not quoted)
                             $temp = explode('"', $cellDataFormula);
                             $key = false;
@@ -344,7 +344,7 @@ 
                                         if ($columnReference{0} == '[') {
                                             $columnReference = $column + trim($columnReference, '[]');
                                         }
-                                        $A1CellReference = \PhpOffice\PhpSpreadsheet\Cell::stringFromColumnIndex($columnReference - 1).$rowReference;
+                                        $A1CellReference = \PhpOffice\PhpSpreadsheet\Cell::stringFromColumnIndex($columnReference - 1) . $rowReference;
 
                                         $value = substr_replace($value, $A1CellReference, $cellReference[0][1], strlen($cellReference[0][0]));
                                     }
@@ -361,10 +361,10 @@ 
                 $cellData = \PhpOffice\PhpSpreadsheet\Calculation::unwrapResult($cellData);
 
                 // Set cell value
-                $spreadsheet->getActiveSheet()->getCell($columnLetter.$row)->setValue(($hasCalculatedValue) ? $cellDataFormula : $cellData);
+                $spreadsheet->getActiveSheet()->getCell($columnLetter . $row)->setValue(($hasCalculatedValue) ? $cellDataFormula : $cellData);
                 if ($hasCalculatedValue) {
                     $cellData = \PhpOffice\PhpSpreadsheet\Calculation::unwrapResult($cellData);
-                    $spreadsheet->getActiveSheet()->getCell($columnLetter.$row)->setCalculatedValue($cellData);
+                    $spreadsheet->getActiveSheet()->getCell($columnLetter . $row)->setCalculatedValue($cellData);
                 }
             //    Read cell formatting
             } elseif ($dataType == 'F') {
@@ -416,12 +416,12 @@ 
                 if (($formatStyle > '') && ($column > '') && ($row > '')) {
                     $columnLetter = \PhpOffice\PhpSpreadsheet\Cell::stringFromColumnIndex($column - 1);
                     if (isset($this->formats[$formatStyle])) {
-                        $spreadsheet->getActiveSheet()->getStyle($columnLetter.$row)->applyFromArray($this->formats[$formatStyle]);
+                        $spreadsheet->getActiveSheet()->getStyle($columnLetter . $row)->applyFromArray($this->formats[$formatStyle]);
                     }
                 }
                 if ((!empty($styleData)) && ($column > '') && ($row > '')) {
                     $columnLetter = \PhpOffice\PhpSpreadsheet\Cell::stringFromColumnIndex($column - 1);
-                    $spreadsheet->getActiveSheet()->getStyle($columnLetter.$row)->applyFromArray($styleData);
+                    $spreadsheet->getActiveSheet()->getStyle($columnLetter . $row)->applyFromArray($styleData);
                 }
                 if ($columnWidth > '') {
                     if ($startCol == $endCol) {

src/PhpSpreadsheet/Reader/Xls/Escher.php

Spacing +2 added lines, -2 removed lines

@@ -593,7 +593,7 @@ 
         $endOffsetY = \PhpOffice\PhpSpreadsheet\Reader\Xls::getInt2d($recordData, 16);
 
         // set the start coordinates
-        $this->object->setStartCoordinates(\PhpOffice\PhpSpreadsheet\Cell::stringFromColumnIndex($c1).($r1 + 1));
+        $this->object->setStartCoordinates(\PhpOffice\PhpSpreadsheet\Cell::stringFromColumnIndex($c1) . ($r1 + 1));
 
         // set the start offsetX
         $this->object->setStartOffsetX($startOffsetX);
@@ -602,7 +602,7 @@ 
         $this->object->setStartOffsetY($startOffsetY);
 
         // set the end coordinates
-        $this->object->setEndCoordinates(\PhpOffice\PhpSpreadsheet\Cell::stringFromColumnIndex($c2).($r2 + 1));
+        $this->object->setEndCoordinates(\PhpOffice\PhpSpreadsheet\Cell::stringFromColumnIndex($c2) . ($r2 + 1));
 
         // set the end offsetX
         $this->object->setEndOffsetX($endOffsetX);

src/PhpSpreadsheet/Reader/Ods.php

Spacing +18 added lines, -18 removed lines

@@ -59,7 +59,7 @@ 
     {
         // Check if file exists
         if (!file_exists($pFilename)) {
-            throw new Exception('Could not open '.$pFilename.' for reading! File does not exist.');
+            throw new Exception('Could not open ' . $pFilename . ' for reading! File does not exist.');
         }
 
         $zipClass = \PhpOffice\PhpSpreadsheet\Settings::getZipClass();
@@ -115,21 +115,21 @@ 
     {
         // Check if file exists
         if (!file_exists($pFilename)) {
-            throw new Exception('Could not open '.$pFilename.' for reading! File does not exist.');
+            throw new Exception('Could not open ' . $pFilename . ' for reading! File does not exist.');
         }
 
         $zipClass = \PhpOffice\PhpSpreadsheet\Settings::getZipClass();
 
         $zip = new $zipClass();
         if (!$zip->open($pFilename)) {
-            throw new Exception('Could not open '.$pFilename.' for reading! Error opening file.');
+            throw new Exception('Could not open ' . $pFilename . ' for reading! Error opening file.');
         }
 
         $worksheetNames = [];
 
         $xml = new XMLReader();
         $res = $xml->xml(
-            $this->securityScanFile('zip://'.realpath($pFilename).'#content.xml'),
+            $this->securityScanFile('zip://' . realpath($pFilename) . '#content.xml'),
             null,
             \PhpOffice\PhpSpreadsheet\Settings::getLibXmlLoaderOptions()
         );
@@ -172,7 +172,7 @@ 
     {
         // Check if file exists
         if (!file_exists($pFilename)) {
-            throw new Exception('Could not open '.$pFilename.' for reading! File does not exist.');
+            throw new Exception('Could not open ' . $pFilename . ' for reading! File does not exist.');
         }
 
         $worksheetInfo = [];
@@ -181,12 +181,12 @@ 
 
         $zip = new $zipClass();
         if (!$zip->open($pFilename)) {
-            throw new Exception('Could not open '.$pFilename.' for reading! Error opening file.');
+            throw new Exception('Could not open ' . $pFilename . ' for reading! Error opening file.');
         }
 
         $xml = new XMLReader();
         $res = $xml->xml(
-            $this->securityScanFile('zip://'.realpath($pFilename).'#content.xml'),
+            $this->securityScanFile('zip://' . realpath($pFilename) . '#content.xml'),
             null,
             \PhpOffice\PhpSpreadsheet\Settings::getLibXmlLoaderOptions()
         );
@@ -302,7 +302,7 @@ 
     {
         // Check if file exists
         if (!file_exists($pFilename)) {
-            throw new Exception('Could not open '.$pFilename.' for reading! File does not exist.');
+            throw new Exception('Could not open ' . $pFilename . ' for reading! File does not exist.');
         }
 
         $timezoneObj = new DateTimeZone('Europe/London');
@@ -312,7 +312,7 @@ 
 
         $zip = new $zipClass();
         if (!$zip->open($pFilename)) {
-            throw new Exception('Could not open '.$pFilename.' for reading! Error opening file.');
+            throw new Exception('Could not open ' . $pFilename . ' for reading! Error opening file.');
         }
 
         $xml = simplexml_load_string(
@@ -476,7 +476,7 @@ 
                                         }
                                     }
                                     $text = implode("\n", $textArray);
-                                    $spreadsheet->getActiveSheet()->getComment($columnID.$rowID)->setText($this->parseRichText($text));
+                                    $spreadsheet->getActiveSheet()->getComment($columnID . $rowID)->setText($this->parseRichText($text));
 //                                                                    ->setAuthor( $author )
                                 }
 
@@ -552,14 +552,14 @@ 
                                             list($year, $month, $day, $hour, $minute, $second) = explode(' ', $dateObj->format('Y m d H i s'));
                                             $dataValue = \PhpOffice\PhpSpreadsheet\Shared\Date::formattedPHPToExcel($year, $month, $day, $hour, $minute, $second);
                                             if ($dataValue != floor($dataValue)) {
-                                                $formatting = \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_XLSX15.' '.\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_TIME4;
+                                                $formatting = \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_XLSX15 . ' ' . \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_TIME4;
                                             } else {
                                                 $formatting = \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_XLSX15;
                                             }
                                             break;
                                         case 'time':
                                             $type = \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC;
-                                            $dataValue = \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel(strtotime('01-01-1970 '.implode(':', sscanf($cellDataOfficeAttributes['time-value'], 'PT%dH%dM%dS'))));
+                                            $dataValue = \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel(strtotime('01-01-1970 ' . implode(':', sscanf($cellDataOfficeAttributes['time-value'], 'PT%dH%dM%dS'))));
                                             $formatting = \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_TIME4;
                                             break;
                                     }
@@ -597,17 +597,17 @@ 
                                         if ($type !== \PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_NULL) {
                                             for ($rowAdjust = 0; $rowAdjust < $rowRepeats; ++$rowAdjust) {
                                                 $rID = $rowID + $rowAdjust;
-                                                $spreadsheet->getActiveSheet()->getCell($columnID.$rID)->setValueExplicit((($hasCalculatedValue) ? $cellDataFormula : $dataValue), $type);
+                                                $spreadsheet->getActiveSheet()->getCell($columnID . $rID)->setValueExplicit((($hasCalculatedValue) ? $cellDataFormula : $dataValue), $type);
                                                 if ($hasCalculatedValue) {
-                                                    $spreadsheet->getActiveSheet()->getCell($columnID.$rID)->setCalculatedValue($dataValue);
+                                                    $spreadsheet->getActiveSheet()->getCell($columnID . $rID)->setCalculatedValue($dataValue);
                                                 }
                                                 if ($formatting !== null) {
-                                                    $spreadsheet->getActiveSheet()->getStyle($columnID.$rID)->getNumberFormat()->setFormatCode($formatting);
+                                                    $spreadsheet->getActiveSheet()->getStyle($columnID . $rID)->getNumberFormat()->setFormatCode($formatting);
                                                 } else {
-                                                    $spreadsheet->getActiveSheet()->getStyle($columnID.$rID)->getNumberFormat()->setFormatCode(\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_GENERAL);
+                                                    $spreadsheet->getActiveSheet()->getStyle($columnID . $rID)->getNumberFormat()->setFormatCode(\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_GENERAL);
                                                 }
                                                 if ($hyperlink !== null) {
-                                                    $spreadsheet->getActiveSheet()->getCell($columnID.$rID)->getHyperlink()->setUrl($hyperlink);
+                                                    $spreadsheet->getActiveSheet()->getCell($columnID . $rID)->getHyperlink()->setUrl($hyperlink);
                                                 }
                                             }
                                         }
@@ -625,7 +625,7 @@ 
                                         if (isset($cellDataTableAttributes['number-rows-spanned'])) {
                                             $rowTo = $rowTo + $cellDataTableAttributes['number-rows-spanned'] - 1;
                                         }
-                                        $cellRange = $columnID.$rowID.':'.$columnTo.$rowTo;
+                                        $cellRange = $columnID . $rowID . ':' . $columnTo . $rowTo;
                                         $spreadsheet->getActiveSheet()->mergeCells($cellRange);
                                     }
                                 }

src/Bootstrap.php

Spacing +1 added lines, -1 removed lines

@@ -26,6 +26,6 @@
  *
  * @version    ##VERSION##, ##DATE##
  */
-include_once __DIR__.'/Autoloader.php';
+include_once __DIR__ . '/Autoloader.php';
 
 \PhpOffice\PhpSpreadsheet\Autoloader::register();

src/Autoloader.php

Spacing +3 added lines, -3 removed lines

@@ -56,9 +56,9 @@
             return false;
         }
 
-        $classFilePath = __DIR__.DIRECTORY_SEPARATOR.
-            'PhpSpreadsheet'.DIRECTORY_SEPARATOR.
-            str_replace([$prefix, '\\'], ['', '/'], $className).
+        $classFilePath = __DIR__ . DIRECTORY_SEPARATOR .
+            'PhpSpreadsheet' . DIRECTORY_SEPARATOR .
+            str_replace([$prefix, '\\'], ['', '/'], $className) .
             '.php';
 
         if ((file_exists($classFilePath) === false) || (is_readable($classFilePath) === false)) {