PHPOffice / PhpSpreadsheet

docs/Examples/Reading WorkBook Data/exampleWorkBookReader03.php

Spacing +2 added lines, -2 removed lines

@@ -41,7 +41,7 @@ 
 echo '<b>Custom Properties: </b><br />';
 /*  Loop through the list of custom properties  **/
 foreach ($customPropertyList as $customPropertyName) {
-    echo '<b>',$customPropertyName,': </b>';
+    echo '<b>', $customPropertyName, ': </b>';
     /*  Retrieve the property value  **/
     $propertyValue = $objPHPExcel->getProperties()->getCustomPropertyValue($customPropertyName);
     /*  Retrieve the property type  **/
@@ -68,7 +68,7 @@ 
             break;
     }
 
-    echo $propertyValue,' (',$propertyType,')<br />';
+    echo $propertyValue, ' (', $propertyType, ')<br />';
 }
 
 ?>

docs/Examples/Reading WorkBook Data/exampleWorkBookReader02.php

Spacing +1 added lines, -1 removed lines

@@ -40,7 +40,7 @@
 
 echo '<b>Custom Property names: </b><br />';
 foreach ($customPropertyList as $customPropertyName) {
-    echo $customPropertyName,'<br />';
+    echo $customPropertyName, '<br />';
 }
 
 ?>

docs/Examples/Reading WorkBook Data/exampleWorkBookReader01.php

Spacing +11 added lines, -11 removed lines

@@ -37,53 +37,53 @@
 
 /*  Read the document's creator property  **/
 $creator = $objPHPExcel->getProperties()->getCreator();
-echo '<b>Document Creator: </b>',$creator,'<br />';
+echo '<b>Document Creator: </b>', $creator, '<br />';
 
 /*  Read the Date when the workbook was created (as a PHP timestamp value)  **/
 $creationDatestamp = $objPHPExcel->getProperties()->getCreated();
 /*  Format the date and time using the standard PHP date() function  **/
 $creationDate = date('l, d<\s\up>S</\s\up> F Y', $creationDatestamp);
 $creationTime = date('g:i A', $creationDatestamp);
-echo '<b>Created On: </b>',$creationDate,' at ',$creationTime,'<br />';
+echo '<b>Created On: </b>', $creationDate, ' at ', $creationTime, '<br />';
 
 /*  Read the name of the last person to modify this workbook  **/
 $modifiedBy = $objPHPExcel->getProperties()->getLastModifiedBy();
-echo '<b>Last Modified By: </b>',$modifiedBy,'<br />';
+echo '<b>Last Modified By: </b>', $modifiedBy, '<br />';
 
 /*  Read the Date when the workbook was last modified (as a PHP timestamp value)  **/
 $modifiedDatestamp = $objPHPExcel->getProperties()->getModified();
 /*  Format the date and time using the standard PHP date() function  **/
 $modifiedDate = date('l, d<\s\up>S</\s\up> F Y', $modifiedDatestamp);
 $modifiedTime = date('g:i A', $modifiedDatestamp);
-echo '<b>Last Modified On: </b>',$modifiedDate,' at ',$modifiedTime,'<br />';
+echo '<b>Last Modified On: </b>', $modifiedDate, ' at ', $modifiedTime, '<br />';
 
 /*  Read the workbook title property  **/
 $workbookTitle = $objPHPExcel->getProperties()->getTitle();
-echo '<b>Title: </b>',$workbookTitle,'<br />';
+echo '<b>Title: </b>', $workbookTitle, '<br />';
 
 /*  Read the workbook description property  **/
 $description = $objPHPExcel->getProperties()->getDescription();
-echo '<b>Description: </b>',$description,'<br />';
+echo '<b>Description: </b>', $description, '<br />';
 
 /*  Read the workbook subject property  **/
 $subject = $objPHPExcel->getProperties()->getSubject();
-echo '<b>Subject: </b>',$subject,'<br />';
+echo '<b>Subject: </b>', $subject, '<br />';
 
 /*  Read the workbook keywords property  **/
 $keywords = $objPHPExcel->getProperties()->getKeywords();
-echo '<b>Keywords: </b>',$keywords,'<br />';
+echo '<b>Keywords: </b>', $keywords, '<br />';
 
 /*  Read the workbook category property  **/
 $category = $objPHPExcel->getProperties()->getCategory();
-echo '<b>Category: </b>',$category,'<br />';
+echo '<b>Category: </b>', $category, '<br />';
 
 /*  Read the workbook company property  **/
 $company = $objPHPExcel->getProperties()->getCompany();
-echo '<b>Company: </b>',$company,'<br />';
+echo '<b>Company: </b>', $company, '<br />';
 
 /*  Read the workbook manager property  **/
 $manager = $objPHPExcel->getProperties()->getManager();
-echo '<b>Manager: </b>',$manager,'<br />';
+echo '<b>Manager: </b>', $manager, '<br />';
 
 ?>
 <body>

docs/Examples/Reading WorkBook Data/exampleWorkBookReader04.php

Spacing +2 added lines, -2 removed lines

@@ -38,13 +38,13 @@
 echo 'Reading the number of Worksheets in the WorkBook<br />';
 /*  Use the PHPExcel object's getSheetCount() method to get a count of the number of WorkSheets in the WorkBook  */
 $sheetCount = $objPHPExcel->getSheetCount();
-echo 'There ',(($sheetCount == 1) ? 'is' : 'are'),' ',$sheetCount,' WorkSheet',(($sheetCount == 1) ? '' : 's'),' in the WorkBook<br /><br />';
+echo 'There ', (($sheetCount == 1) ? 'is' : 'are'), ' ', $sheetCount, ' WorkSheet', (($sheetCount == 1) ? '' : 's'), ' in the WorkBook<br /><br />';
 
 echo 'Reading the names of Worksheets in the WorkBook<br />';
 /*  Use the PHPExcel object's getSheetNames() method to get an array listing the names/titles of the WorkSheets in the WorkBook  */
 $sheetNames = $objPHPExcel->getSheetNames();
 foreach ($sheetNames as $sheetIndex => $sheetName) {
-    echo 'WorkSheet #',$sheetIndex,' is named "',$sheetName,'"<br />';
+    echo 'WorkSheet #', $sheetIndex, ' is named "', $sheetName, '"<br />';
 }
 
 ?>

docs/Examples/Reader/exampleReader18.php

Spacing +1 added lines, -1 removed lines

@@ -32,7 +32,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);
 $worksheetNames = $objReader->listWorksheetNames($inputFileName);

docs/Examples/Reader/exampleReader19.php

Spacing +1 added lines, -1 removed lines

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

docs/Examples/Calculations/DateTime/TIME.php

Indentation +3 added lines, -3 removed lines

@@ -33,7 +33,7 @@ 
 $testDates = [[3, 15],        [13, 15],    [15, 15, 15],    [3, 15, 30],
                     [15, 15, 15],    [5],        [9, 15, 0],        [9, 15, -1],
                     [13, -14, -15],    [0, 0, -1],
-                  ];
+                    ];
 $testDateCount = count($testDates);
 
 $worksheet->fromArray($testDates, null, 'A1', true);
@@ -43,8 +43,8 @@ 
     $worksheet->setCellValue('E' . $row, '=D' . $row);
 }
 $worksheet->getStyle('E1:E' . $testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('hh:mm:ss');
+            ->getNumberFormat()
+            ->setFormatCode('hh:mm:ss');
 
 echo '<hr />';
 

Spacing +9 added lines, -9 removed lines

@@ -30,9 +30,9 @@ 
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$testDates = [[3, 15],        [13, 15],    [15, 15, 15],    [3, 15, 30],
-                    [15, 15, 15],    [5],        [9, 15, 0],        [9, 15, -1],
-                    [13, -14, -15],    [0, 0, -1],
+$testDates = [[3, 15], [13, 15], [15, 15, 15], [3, 15, 30],
+                    [15, 15, 15], [5], [9, 15, 0], [9, 15, -1],
+                    [13, -14, -15], [0, 0, -1],
                   ];
 $testDateCount = count($testDates);
 
@@ -65,12 +65,12 @@ 
 	<?php
     for ($row = 1; $row <= $testDateCount; ++$row) {
         echo '<tr>';
-        echo '<td>' , $worksheet->getCell('A' . $row)->getFormattedValue() , '</td>';
-        echo '<td>' , $worksheet->getCell('B' . $row)->getFormattedValue() , '</td>';
-        echo '<td>' , $worksheet->getCell('C' . $row)->getFormattedValue() , '</td>';
-        echo '<td>' , $worksheet->getCell('D' . $row)->getValue() , '</td>';
-        echo '<td>' , $worksheet->getCell('D' . $row)->getFormattedValue() , '</td>';
-        echo '<td>' , $worksheet->getCell('E' . $row)->getFormattedValue() , '</td>';
+        echo '<td>', $worksheet->getCell('A' . $row)->getFormattedValue(), '</td>';
+        echo '<td>', $worksheet->getCell('B' . $row)->getFormattedValue(), '</td>';
+        echo '<td>', $worksheet->getCell('C' . $row)->getFormattedValue(), '</td>';
+        echo '<td>', $worksheet->getCell('D' . $row)->getValue(), '</td>';
+        echo '<td>', $worksheet->getCell('D' . $row)->getFormattedValue(), '</td>';
+        echo '<td>', $worksheet->getCell('E' . $row)->getFormattedValue(), '</td>';
         echo '</tr>';
     }
     ?>

docs/Examples/Calculations/DateTime/DATEVALUE.php

Indentation +3 added lines, -3 removed lines

@@ -34,7 +34,7 @@ 
                     '2012-Oct-31',        '5th November',    'January 1st',        'April 2012',
                     '17-03',            '03-2012',        '29 Feb 2011',        '03-05-07',
                     '03-MAY-07',        '03-13-07',
-                  ];
+                    ];
 $testDateCount = count($testDates);
 
 for ($row = 1; $row <= $testDateCount; ++$row) {
@@ -44,8 +44,8 @@ 
 }
 
 $worksheet->getStyle('C1:C' . $testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('yyyy-mmm-dd');
+            ->getNumberFormat()
+            ->setFormatCode('yyyy-mmm-dd');
 
 echo '<hr />';
 

Spacing +8 added lines, -8 removed lines

@@ -30,10 +30,10 @@ 
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$testDates = ['26 March 2012',    '29 Feb 2012',    'April 1, 2012',    '25/12/2012',
-                    '2012-Oct-31',        '5th November',    'January 1st',        'April 2012',
-                    '17-03',            '03-2012',        '29 Feb 2011',        '03-05-07',
-                    '03-MAY-07',        '03-13-07',
+$testDates = ['26 March 2012', '29 Feb 2012', 'April 1, 2012', '25/12/2012',
+                    '2012-Oct-31', '5th November', 'January 1st', 'April 2012',
+                    '17-03', '03-2012', '29 Feb 2011', '03-05-07',
+                    '03-MAY-07', '03-13-07',
                   ];
 $testDateCount = count($testDates);
 
@@ -62,10 +62,10 @@ 
 	<?php
     for ($row = 1; $row <= $testDateCount; ++$row) {
         echo '<tr>';
-        echo '<td>' , $worksheet->getCell('A' . $row)->getFormattedValue() , '</td>';
-        echo '<td>' , $worksheet->getCell('B' . $row)->getValue() , '</td>';
-        echo '<td>' , $worksheet->getCell('B' . $row)->getFormattedValue() , '</td>';
-        echo '<td>' , $worksheet->getCell('C' . $row)->getFormattedValue() , '</td>';
+        echo '<td>', $worksheet->getCell('A' . $row)->getFormattedValue(), '</td>';
+        echo '<td>', $worksheet->getCell('B' . $row)->getValue(), '</td>';
+        echo '<td>', $worksheet->getCell('B' . $row)->getFormattedValue(), '</td>';
+        echo '<td>', $worksheet->getCell('C' . $row)->getFormattedValue(), '</td>';
         echo '</tr>';
     }
     ?>

docs/Examples/Calculations/DateTime/TIMEVALUE.php

Indentation +3 added lines, -3 removed lines

@@ -31,7 +31,7 @@ 
 
 // Add some data
 $testDates = ['3:15',    '13:15',    '15:15:15',    '3:15 AM',    '3:15 PM',    '5PM',    '9:15AM',    '13:15AM',
-                  ];
+                    ];
 $testDateCount = count($testDates);
 
 for ($row = 1; $row <= $testDateCount; ++$row) {
@@ -41,8 +41,8 @@ 
 }
 
 $worksheet->getStyle('C1:C' . $testDateCount)
-          ->getNumberFormat()
-          ->setFormatCode('hh:mm:ss');
+            ->getNumberFormat()
+            ->setFormatCode('hh:mm:ss');
 
 echo '<hr />';
 

Spacing +5 added lines, -5 removed lines

@@ -30,7 +30,7 @@ 
 $worksheet = $objPHPExcel->getActiveSheet();
 
 // Add some data
-$testDates = ['3:15',    '13:15',    '15:15:15',    '3:15 AM',    '3:15 PM',    '5PM',    '9:15AM',    '13:15AM',
+$testDates = ['3:15', '13:15', '15:15:15', '3:15 AM', '3:15 PM', '5PM', '9:15AM', '13:15AM',
                   ];
 $testDateCount = count($testDates);
 
@@ -58,10 +58,10 @@ 
 	<?php
     for ($row = 1; $row <= $testDateCount; ++$row) {
         echo '<tr>';
-        echo '<td>' , $worksheet->getCell('A' . $row)->getFormattedValue() , '</td>';
-        echo '<td>' , $worksheet->getCell('B' . $row)->getValue() , '</td>';
-        echo '<td>' , $worksheet->getCell('B' . $row)->getFormattedValue() , '</td>';
-        echo '<td>' , $worksheet->getCell('C' . $row)->getFormattedValue() , '</td>';
+        echo '<td>', $worksheet->getCell('A' . $row)->getFormattedValue(), '</td>';
+        echo '<td>', $worksheet->getCell('B' . $row)->getValue(), '</td>';
+        echo '<td>', $worksheet->getCell('B' . $row)->getFormattedValue(), '</td>';
+        echo '<td>', $worksheet->getCell('C' . $row)->getFormattedValue(), '</td>';
         echo '</tr>';
     }
     ?>