View GitHub Repository PhpSpreadsheet

Schedule Inspection
Subscribe
Completed
Push — develop ( 3ee9cc...870d86 )
by Adrien
29:45
created
Status
Category
Toggle Patches
docs/Examples/Reader/exampleReader04.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch 
@@ -28,9 +28,9 @@
 
 block discarded – undo
28 28 
 $inputFileName = './sampleData/example1.xls';
29 29
30 30 
 $inputFileType = \PhpOffice\PhpSpreadsheet\IOFactory::identify($inputFileName);
31 
-echo 'File ',pathinfo($inputFileName, PATHINFO_BASENAME),' has been identified as an ',$inputFileType,' file<br />';
31 
+echo 'File ', pathinfo($inputFileName, PATHINFO_BASENAME), ' has been identified as an ', $inputFileType, ' file<br />';
32 32
33 
-echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with the identified reader type<br />';
33 
+echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with the identified reader type<br />';
34 34 
 $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType);
35 35 
 $spreadsheet = $reader->load($inputFileName);
36 36
Please login to merge, or discard this patch.
docs/Examples/Reading WorkBook Data/exampleWorkBookReader01.php 1 patch
Spacing   +11 added lines, -11 removed lines patch added patch discarded remove patch 
@@ -37,53 +37,53 @@
 
 block discarded – undo
37 37
38 38 
 /*  Read the document's creator property  **/
39 39 
 $creator = $spreadsheet->getProperties()->getCreator();
40 
-echo '<b>Document Creator: </b>',$creator,'<br />';
40 
+echo '<b>Document Creator: </b>', $creator, '<br />';
41 41
42 42 
 /*  Read the Date when the workbook was created (as a PHP timestamp value)  **/
43 43 
 $creationDatestamp = $spreadsheet->getProperties()->getCreated();
44 44 
 /*  Format the date and time using the standard PHP date() function  **/
45 45 
 $creationDate = date('l, d<\s\up>S</\s\up> F Y', $creationDatestamp);
46 46 
 $creationTime = date('g:i A', $creationDatestamp);
47 
-echo '<b>Created On: </b>',$creationDate,' at ',$creationTime,'<br />';
47 
+echo '<b>Created On: </b>', $creationDate, ' at ', $creationTime, '<br />';
48 48
49 49 
 /*  Read the name of the last person to modify this workbook  **/
50 50 
 $modifiedBy = $spreadsheet->getProperties()->getLastModifiedBy();
51 
-echo '<b>Last Modified By: </b>',$modifiedBy,'<br />';
51 
+echo '<b>Last Modified By: </b>', $modifiedBy, '<br />';
52 52
53 53 
 /*  Read the Date when the workbook was last modified (as a PHP timestamp value)  **/
54 54 
 $modifiedDatestamp = $spreadsheet->getProperties()->getModified();
55 55 
 /*  Format the date and time using the standard PHP date() function  **/
56 56 
 $modifiedDate = date('l, d<\s\up>S</\s\up> F Y', $modifiedDatestamp);
57 57 
 $modifiedTime = date('g:i A', $modifiedDatestamp);
58 
-echo '<b>Last Modified On: </b>',$modifiedDate,' at ',$modifiedTime,'<br />';
58 
+echo '<b>Last Modified On: </b>', $modifiedDate, ' at ', $modifiedTime, '<br />';
59 59
60 60 
 /*  Read the workbook title property  **/
61 61 
 $workbookTitle = $spreadsheet->getProperties()->getTitle();
62 
-echo '<b>Title: </b>',$workbookTitle,'<br />';
62 
+echo '<b>Title: </b>', $workbookTitle, '<br />';
63 63
64 64 
 /*  Read the workbook description property  **/
65 65 
 $description = $spreadsheet->getProperties()->getDescription();
66 
-echo '<b>Description: </b>',$description,'<br />';
66 
+echo '<b>Description: </b>', $description, '<br />';
67 67
68 68 
 /*  Read the workbook subject property  **/
69 69 
 $subject = $spreadsheet->getProperties()->getSubject();
70 
-echo '<b>Subject: </b>',$subject,'<br />';
70 
+echo '<b>Subject: </b>', $subject, '<br />';
71 71
72 72 
 /*  Read the workbook keywords property  **/
73 73 
 $keywords = $spreadsheet->getProperties()->getKeywords();
74 
-echo '<b>Keywords: </b>',$keywords,'<br />';
74 
+echo '<b>Keywords: </b>', $keywords, '<br />';
75 75
76 76 
 /*  Read the workbook category property  **/
77 77 
 $category = $spreadsheet->getProperties()->getCategory();
78 
-echo '<b>Category: </b>',$category,'<br />';
78 
+echo '<b>Category: </b>', $category, '<br />';
79 79
80 80 
 /*  Read the workbook company property  **/
81 81 
 $company = $spreadsheet->getProperties()->getCompany();
82 
-echo '<b>Company: </b>',$company,'<br />';
82 
+echo '<b>Company: </b>', $company, '<br />';
83 83
84 84 
 /*  Read the workbook manager property  **/
85 85 
 $manager = $spreadsheet->getProperties()->getManager();
86 
-echo '<b>Manager: </b>',$manager,'<br />';
86 
+echo '<b>Manager: </b>', $manager, '<br />';
87 87
88 88 
 ?>
89 89 
 <body>
Please login to merge, or discard this patch.
docs/Examples/Calculations/Database/DAVERAGE.php 1 patch
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch 
@@ -30,17 +30,17 @@
 
 block discarded – undo
30 30 
 $worksheet = $spreadsheet->getActiveSheet();
31 31
32 32 
 // Add some data
33 
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
34 
-                   ['Apple',  18,       20,    14,      105.00],
35 
-                   ['Pear',   12,       12,    10,       96.00],
36 
-                   ['Cherry', 13,       14,     9,      105.00],
37 
-                   ['Apple',  14,       15,    10,       75.00],
38 
-                   ['Pear',    9,        8,     8,       76.80],
39 
-                   ['Apple',   8,        9,     6,       45.00],
33 
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34 
+                   ['Apple', 18, 20, 14, 105.00],
35 
+                   ['Pear', 12, 12, 10, 96.00],
36 
+                   ['Cherry', 13, 14, 9, 105.00],
37 
+                   ['Apple', 14, 15, 10, 75.00],
38 
+                   ['Pear', 9, 8, 8, 76.80],
39 
+                   ['Apple', 8, 9, 6, 45.00],
40 40 
                  ];
41 
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
-                   ['="=Pear"',  null,     null,  null,    null,     null],
41 
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
+                   ['="=Apple"', '>10', null, null, null, '<16'],
43 
+                   ['="=Pear"', null, null, null, null, null],
44 44 
                  ];
45 45
46 46 
 $worksheet->fromArray($criteria, null, 'A1');
Please login to merge, or discard this patch.
docs/Examples/Calculations/index.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch 
@@ -36,9 +36,9 @@
 
 block discarded – undo
36 36 
             $h1Text = $out[1];
37 37 
             $h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : '';
38 38
39 
-            echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />';
39 
+            echo '<a href="', $exampleFile, '">', $h1Text, '</a><br />';
40 40 
             if ($h2Text > '') {
41 
-                echo $h2Text,'<br />';
41 
+                echo $h2Text, '<br />';
42 42 
             }
43 43 
         }
44 44 
     }
Please login to merge, or discard this patch.
src/PhpSpreadsheet/Writer/Xls/Font.php 1 patch
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch 
@@ -82,9 +82,9 @@  discard block
 
 block discarded – undo
82 82 
         $bFamily = 0; // Font family
83 83 
         $bCharSet = \PhpOffice\PhpSpreadsheet\Shared\Font::getCharsetFromFontName($this->font->getName()); // Character set
84 84
85 
-        $record = 0x31;        // Record identifier
86 
-        $reserved = 0x00;    // Reserved
87 
-        $grbit = 0x00;        // Font attributes
85 
+        $record = 0x31; // Record identifier
86 
+        $reserved = 0x00; // Reserved
87 
+        $grbit = 0x00; // Font attributes
88 88 
         if ($this->font->getItalic()) {
89 89 
             $grbit |= 0x02;
90 90 
         }
 
@@ -132,10 +132,10 @@  discard block
 
 block discarded – undo
132 132 
     private static function mapBold($bold)
133 133 
     {
134 134 
         if ($bold) {
135 
-            return 0x2BC;  //  700 = Bold font weight
135 
+            return 0x2BC; //  700 = Bold font weight
136 136 
         }
137 137
138 
-        return 0x190;      //  400 = Normal font weight
138 
+        return 0x190; //  400 = Normal font weight
139 139 
     }
140 140
141 141 
     /**
Please login to merge, or discard this patch.
docs/Examples/Calculations/Database/DPRODUCT.php 1 patch
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch 
@@ -30,17 +30,17 @@
 
 block discarded – undo
30 30 
 $worksheet = $spreadsheet->getActiveSheet();
31 31
32 32 
 // Add some data
33 
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
34 
-                   ['Apple',  18,       20,    14,      105.00],
35 
-                   ['Pear',   12,       12,    10,       96.00],
36 
-                   ['Cherry', 13,       14,     9,      105.00],
37 
-                   ['Apple',  14,       15,    10,       75.00],
38 
-                   ['Pear',    9,        8,     8,       76.80],
39 
-                   ['Apple',   8,        9,     6,       45.00],
33 
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34 
+                   ['Apple', 18, 20, 14, 105.00],
35 
+                   ['Pear', 12, 12, 10, 96.00],
36 
+                   ['Cherry', 13, 14, 9, 105.00],
37 
+                   ['Apple', 14, 15, 10, 75.00],
38 
+                   ['Pear', 9, 8, 8, 76.80],
39 
+                   ['Apple', 8, 9, 6, 45.00],
40 40 
                  ];
41 
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
-                   ['="=Pear"',  null,     null,  null,    null,     null],
41 
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
+                   ['="=Apple"', '>10', null, null, null, '<16'],
43 
+                   ['="=Pear"', null, null, null, null, null],
44 44 
                  ];
45 45
46 46 
 $worksheet->fromArray($criteria, null, 'A1');
Please login to merge, or discard this patch.
docs/Examples/Calculations/Database/DMAX.php 1 patch
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch 
@@ -30,17 +30,17 @@
 
 block discarded – undo
30 30 
 $worksheet = $spreadsheet->getActiveSheet();
31 31
32 32 
 // Add some data
33 
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
34 
-                   ['Apple',  18,       20,    14,      105.00],
35 
-                   ['Pear',   12,       12,    10,       96.00],
36 
-                   ['Cherry', 13,       14,     9,      105.00],
37 
-                   ['Apple',  14,       15,    10,       75.00],
38 
-                   ['Pear',    9,        8,     8,       76.80],
39 
-                   ['Apple',   8,        9,     6,       45.00],
33 
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34 
+                   ['Apple', 18, 20, 14, 105.00],
35 
+                   ['Pear', 12, 12, 10, 96.00],
36 
+                   ['Cherry', 13, 14, 9, 105.00],
37 
+                   ['Apple', 14, 15, 10, 75.00],
38 
+                   ['Pear', 9, 8, 8, 76.80],
39 
+                   ['Apple', 8, 9, 6, 45.00],
40 40 
                  ];
41 
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
-                   ['="=Pear"',  null,     null,  null,    null,     null],
41 
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
+                   ['="=Apple"', '>10', null, null, null, '<16'],
43 
+                   ['="=Pear"', null, null, null, null, null],
44 44 
                  ];
45 45
46 46 
 $worksheet->fromArray($criteria, null, 'A1');
Please login to merge, or discard this patch.
docs/Examples/Calculations/Database/DVARP.php 1 patch
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch 
@@ -30,17 +30,17 @@
 
 block discarded – undo
30 30 
 $worksheet = $spreadsheet->getActiveSheet();
31 31
32 32 
 // Add some data
33 
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
34 
-                   ['Apple',  18,       20,    14,      105.00],
35 
-                   ['Pear',   12,       12,    10,       96.00],
36 
-                   ['Cherry', 13,       14,     9,      105.00],
37 
-                   ['Apple',  14,       15,    10,       75.00],
38 
-                   ['Pear',    9,        8,     8,       76.80],
39 
-                   ['Apple',   8,        9,     6,       45.00],
33 
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34 
+                   ['Apple', 18, 20, 14, 105.00],
35 
+                   ['Pear', 12, 12, 10, 96.00],
36 
+                   ['Cherry', 13, 14, 9, 105.00],
37 
+                   ['Apple', 14, 15, 10, 75.00],
38 
+                   ['Pear', 9, 8, 8, 76.80],
39 
+                   ['Apple', 8, 9, 6, 45.00],
40 40 
                  ];
41 
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
-                   ['="=Pear"',  null,     null,  null,    null,     null],
41 
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
+                   ['="=Apple"', '>10', null, null, null, '<16'],
43 
+                   ['="=Pear"', null, null, null, null, null],
44 44 
                  ];
45 45
46 46 
 $worksheet->fromArray($criteria, null, 'A1');
Please login to merge, or discard this patch.
docs/Examples/Calculations/Database/DSTDEV.php 1 patch
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch 
@@ -30,17 +30,17 @@
 
 block discarded – undo
30 30 
 $worksheet = $spreadsheet->getActiveSheet();
31 31
32 32 
 // Add some data
33 
-$database = [['Tree',  'Height', 'Age', 'Yield', 'Profit'],
34 
-                   ['Apple',  18,       20,    14,      105.00],
35 
-                   ['Pear',   12,       12,    10,       96.00],
36 
-                   ['Cherry', 13,       14,     9,      105.00],
37 
-                   ['Apple',  14,       15,    10,       75.00],
38 
-                   ['Pear',    9,        8,     8,       76.80],
39 
-                   ['Apple',   8,        9,     6,       45.00],
33 
+$database = [['Tree', 'Height', 'Age', 'Yield', 'Profit'],
34 
+                   ['Apple', 18, 20, 14, 105.00],
35 
+                   ['Pear', 12, 12, 10, 96.00],
36 
+                   ['Cherry', 13, 14, 9, 105.00],
37 
+                   ['Apple', 14, 15, 10, 75.00],
38 
+                   ['Pear', 9, 8, 8, 76.80],
39 
+                   ['Apple', 8, 9, 6, 45.00],
40 40 
                  ];
41 
-$criteria = [['Tree',      'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
-                   ['="=Apple"', '>10',    null,  null,    null,     '<16'],
43 
-                   ['="=Pear"',  null,     null,  null,    null,     null],
41 
+$criteria = [['Tree', 'Height', 'Age', 'Yield', 'Profit', 'Height'],
42 
+                   ['="=Apple"', '>10', null, null, null, '<16'],
43 
+                   ['="=Pear"', null, null, null, null, null],
44 44 
                  ];
45 45
46 46 
 $worksheet->fromArray($criteria, null, 'A1');
Please login to merge, or discard this patch.