@@ -56,7 +56,7 @@ discard block |
||
56 | 56 | * If a resource pointer to a stream created by fopen() is passed |
57 | 57 | * it will be used, but you have to close such stream by yourself. |
58 | 58 | * |
59 | - * @param string|resource $filename the name of the file or stream where to save the OLE container |
|
59 | + * @param string $filename the name of the file or stream where to save the OLE container |
|
60 | 60 | * |
61 | 61 | * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception |
62 | 62 | * |
@@ -121,7 +121,7 @@ discard block |
||
121 | 121 | * |
122 | 122 | * @param array $raList Reference to an array of PPS's |
123 | 123 | * |
124 | - * @return float[] The array of numbers |
|
124 | + * @return double[] The array of numbers |
|
125 | 125 | */ |
126 | 126 | public function _calcSize(&$raList) |
127 | 127 | { |
@@ -218,7 +218,7 @@ discard block |
||
218 | 218 | * set ribbon XML data. |
219 | 219 | * |
220 | 220 | * @param null|mixed $target |
221 | - * @param null|mixed $xmlData |
|
221 | + * @param string $xmlData |
|
222 | 222 | */ |
223 | 223 | public function setRibbonXMLData($target, $xmlData) |
224 | 224 | { |
@@ -285,7 +285,7 @@ discard block |
||
285 | 285 | /** |
286 | 286 | * retrieve Binaries Ribbon Objects. |
287 | 287 | * |
288 | - * @param mixed $what |
|
288 | + * @param string $what |
|
289 | 289 | */ |
290 | 290 | public function getRibbonBinObjects($what = 'all') |
291 | 291 | { |
@@ -471,7 +471,7 @@ discard block |
||
471 | 471 | /** |
472 | 472 | * Set Columns to repeat at left. |
473 | 473 | * |
474 | - * @param array $pValue Containing start column and end column, empty array if option unset |
|
474 | + * @param string[] $pValue Containing start column and end column, empty array if option unset |
|
475 | 475 | * |
476 | 476 | * @return PageSetup |
477 | 477 | */ |
@@ -526,7 +526,7 @@ discard block |
||
526 | 526 | /** |
527 | 527 | * Set Rows to repeat at top. |
528 | 528 | * |
529 | - * @param array $pValue Containing start column and end column, empty array if option unset |
|
529 | + * @param string[] $pValue Containing start column and end column, empty array if option unset |
|
530 | 530 | * |
531 | 531 | * @return PageSetup |
532 | 532 | */ |
@@ -48,9 +48,9 @@ |
||
48 | 48 | |
49 | 49 | $filterSubset = new MyReadFilter(); |
50 | 50 | |
51 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />'; |
|
51 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />'; |
|
52 | 52 | $reader = IOFactory::createReader($inputFileType); |
53 | -echo 'Loading Sheet "',$sheetname,'" only<br />'; |
|
53 | +echo 'Loading Sheet "', $sheetname, '" only<br />'; |
|
54 | 54 | $reader->setLoadSheetsOnly($sheetname); |
55 | 55 | echo 'Loading Sheet using filter<br />'; |
56 | 56 | $reader->setReadFilter($filterSubset); |
@@ -32,7 +32,7 @@ |
||
32 | 32 | // $inputFileType = 'Csv'; |
33 | 33 | $inputFileName = './sampleData/example1.xls'; |
34 | 34 | |
35 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />'; |
|
35 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />'; |
|
36 | 36 | $reader = IOFactory::createReader($inputFileType); |
37 | 37 | $spreadsheet = $reader->load($inputFileName); |
38 | 38 |
@@ -71,7 +71,7 @@ |
||
71 | 71 | /* Tell the Reader that we want to use the Read Filter that we've Instantiated **/ |
72 | 72 | /* and that we want to store it in contiguous rows/columns **/ |
73 | 73 | $reader->setReadFilter($chunkFilter) |
74 | - ->setContiguous(true); |
|
74 | + ->setContiguous(true); |
|
75 | 75 | |
76 | 76 | /* Instantiate a new PhpSpreadsheet object manually **/ |
77 | 77 | $spreadsheet = new Spreadsheet(); |
@@ -57,7 +57,7 @@ |
||
57 | 57 | } |
58 | 58 | } |
59 | 59 | |
60 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />'; |
|
60 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />'; |
|
61 | 61 | /* Create a new Reader of the type defined in $inputFileType **/ |
62 | 62 | $reader = IOFactory::createReader($inputFileType); |
63 | 63 |
@@ -31,18 +31,18 @@ |
||
31 | 31 | $inputFileName = './sampleData/example1.xls'; |
32 | 32 | $sheetname = 'Data Sheet #2'; |
33 | 33 | |
34 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />'; |
|
34 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />'; |
|
35 | 35 | $reader = IOFactory::createReader($inputFileType); |
36 | -echo 'Loading Sheet "',$sheetname,'" only<br />'; |
|
36 | +echo 'Loading Sheet "', $sheetname, '" only<br />'; |
|
37 | 37 | $reader->setLoadSheetsOnly($sheetname); |
38 | 38 | $spreadsheet = $reader->load($inputFileName); |
39 | 39 | |
40 | 40 | echo '<hr />'; |
41 | 41 | |
42 | -echo $spreadsheet->getSheetCount(),' worksheet',(($spreadsheet->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />'; |
|
42 | +echo $spreadsheet->getSheetCount(), ' worksheet', (($spreadsheet->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />'; |
|
43 | 43 | $loadedSheetNames = $spreadsheet->getSheetNames(); |
44 | 44 | foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) { |
45 | - echo $sheetIndex,' -> ',$loadedSheetName,'<br />'; |
|
45 | + echo $sheetIndex, ' -> ', $loadedSheetName, '<br />'; |
|
46 | 46 | } |
47 | 47 | |
48 | 48 | ?> |
@@ -26,9 +26,9 @@ |
||
26 | 26 | $inputFileName = './sampleData/example1.xls'; |
27 | 27 | |
28 | 28 | $inputFileType = IOFactory::identify($inputFileName); |
29 | -echo 'File ',pathinfo($inputFileName, PATHINFO_BASENAME),' has been identified as an ',$inputFileType,' file<br />'; |
|
29 | +echo 'File ', pathinfo($inputFileName, PATHINFO_BASENAME), ' has been identified as an ', $inputFileType, ' file<br />'; |
|
30 | 30 | |
31 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with the identified reader type<br />'; |
|
31 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with the identified reader type<br />'; |
|
32 | 32 | $reader = IOFactory::createReader($inputFileType); |
33 | 33 | $spreadsheet = $reader->load($inputFileName); |
34 | 34 |
@@ -28,11 +28,11 @@ |
||
28 | 28 | |
29 | 29 | $reader = IOFactory::createReader($inputFileType); |
30 | 30 | $inputFileName = array_shift($inputFileNames); |
31 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' into WorkSheet #1 using IOFactory with a defined reader type of ',$inputFileType,'<br />'; |
|
31 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' into WorkSheet #1 using IOFactory with a defined reader type of ', $inputFileType, '<br />'; |
|
32 | 32 | $spreadsheet = $reader->load($inputFileName); |
33 | 33 | $spreadsheet->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME)); |
34 | 34 | foreach ($inputFileNames as $sheet => $inputFileName) { |
35 | - echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' into WorkSheet #',($sheet + 2),' using IOFactory with a defined reader type of ',$inputFileType,'<br />'; |
|
35 | + echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' into WorkSheet #', ($sheet + 2), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />'; |
|
36 | 36 | $reader->setSheetIndex($sheet + 1); |
37 | 37 | $reader->loadIntoExisting($inputFileName, $spreadsheet); |
38 | 38 | $spreadsheet->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME)); |