@@ -32,7 +32,7 @@ |
||
32 | 32 | // $inputFileType = 'Gnumeric'; |
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 | $objReader = PHPExcel_IOFactory::createReader($inputFileType); |
37 | 37 | echo 'Turning Formatting off for Load<br />'; |
38 | 38 | $objReader->setReadDataOnly(true); |
@@ -26,17 +26,17 @@ |
||
26 | 26 | $inputFileName = './sampleData/example1.tsv'; |
27 | 27 | |
28 | 28 | $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType); |
29 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' into WorkSheet #1 using IOFactory with a defined reader type of ',$inputFileType,'<br />'; |
|
29 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' into WorkSheet #1 using IOFactory with a defined reader type of ', $inputFileType, '<br />'; |
|
30 | 30 | $reader->setDelimiter("\t"); |
31 | 31 | $spreadsheet = $reader->load($inputFileName); |
32 | 32 | $spreadsheet->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME)); |
33 | 33 | |
34 | 34 | echo '<hr />'; |
35 | 35 | |
36 | -echo $spreadsheet->getSheetCount(),' worksheet',(($spreadsheet->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />'; |
|
36 | +echo $spreadsheet->getSheetCount(), ' worksheet', (($spreadsheet->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />'; |
|
37 | 37 | $loadedSheetNames = $spreadsheet->getSheetNames(); |
38 | 38 | foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) { |
39 | - echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,' (Formatted)</b><br />'; |
|
39 | + echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, ' (Formatted)</b><br />'; |
|
40 | 40 | $spreadsheet->setActiveSheetIndexByName($loadedSheetName); |
41 | 41 | $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true); |
42 | 42 | var_dump($sheetData); |
@@ -294,6 +294,11 @@ discard block |
||
294 | 294 | return isset($c->v) ? (string) $c->v : null; |
295 | 295 | } |
296 | 296 | |
297 | + /** |
|
298 | + * @param string $r |
|
299 | + * @param string $cellDataType |
|
300 | + * @param string $castBaseType |
|
301 | + */ |
|
297 | 302 | private function castToFormula($c, $r, &$cellDataType, &$value, &$calculatedValue, &$sharedFormulas, $castBaseType) |
298 | 303 | { |
299 | 304 | $cellDataType = 'f'; |
@@ -2159,6 +2164,9 @@ discard block |
||
2159 | 2164 | return preg_replace('~[^/]+/\.\./~', '', dirname($base) . "/$add"); |
2160 | 2165 | } |
2161 | 2166 | |
2167 | + /** |
|
2168 | + * @param string $style |
|
2169 | + */ |
|
2162 | 2170 | private static function toCSSArray($style) |
2163 | 2171 | { |
2164 | 2172 | $style = str_replace(["\r", "\n"], '', $style); |
@@ -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 = null, $xmlData = null) |
224 | 224 | { |
@@ -234,7 +234,7 @@ discard block |
||
234 | 234 | * |
235 | 235 | * return string|null|array |
236 | 236 | * |
237 | - * @param mixed $what |
|
237 | + * @param string $what |
|
238 | 238 | * |
239 | 239 | * @return string |
240 | 240 | */ |
@@ -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 | { |
@@ -168,16 +168,25 @@ discard block |
||
168 | 168 | return fread($this->fileHandle, $blockSize); |
169 | 169 | } |
170 | 170 | |
171 | + /** |
|
172 | + * @param string $data |
|
173 | + */ |
|
171 | 174 | private static function startsWithTag($data) |
172 | 175 | { |
173 | 176 | return '<' === substr(trim($data), 0, 1); |
174 | 177 | } |
175 | 178 | |
179 | + /** |
|
180 | + * @param string $data |
|
181 | + */ |
|
176 | 182 | private static function endsWithTag($data) |
177 | 183 | { |
178 | 184 | return '>' === substr(trim($data), -1, 1); |
179 | 185 | } |
180 | 186 | |
187 | + /** |
|
188 | + * @param string $data |
|
189 | + */ |
|
181 | 190 | private static function containsTags($data) |
182 | 191 | { |
183 | 192 | return strlen($data) !== strlen(strip_tags($data)); |
@@ -249,6 +258,10 @@ discard block |
||
249 | 258 | return array_pop($this->nestedColumn); |
250 | 259 | } |
251 | 260 | |
261 | + /** |
|
262 | + * @param \PhpOffice\PhpSpreadsheet\Worksheet $sheet |
|
263 | + * @param integer $row |
|
264 | + */ |
|
252 | 265 | protected function flushCell($sheet, $column, $row, &$cellContent) |
253 | 266 | { |
254 | 267 | if (is_string($cellContent)) { |
@@ -472,7 +472,7 @@ |
||
472 | 472 | * |
473 | 473 | * @param int $pValue Sheet index |
474 | 474 | * |
475 | - * @return SYLK |
|
475 | + * @return Slk |
|
476 | 476 | */ |
477 | 477 | public function setSheetIndex($pValue = 0) |
478 | 478 | { |
@@ -231,6 +231,9 @@ discard block |
||
231 | 231 | return $this->loadIntoExisting($pFilename, $objPHPExcel); |
232 | 232 | } |
233 | 233 | |
234 | + /** |
|
235 | + * @param string $styleAttributeValue |
|
236 | + */ |
|
234 | 237 | protected static function identifyFixedStyleValue($styleList, &$styleAttributeValue) |
235 | 238 | { |
236 | 239 | $styleAttributeValue = strtolower($styleAttributeValue); |
@@ -786,6 +789,9 @@ discard block |
||
786 | 789 | } |
787 | 790 | |
788 | 791 | |
792 | + /** |
|
793 | + * @param string $charset |
|
794 | + */ |
|
789 | 795 | protected static function convertStringEncoding($string, $charset) |
790 | 796 | { |
791 | 797 | if ($charset != 'UTF-8') { |
@@ -1165,7 +1165,7 @@ |
||
1165 | 1165 | * @param \PhpOffice\PhpSpreadsheet\Worksheet $pSheet \PhpOffice\PhpSpreadsheet\Worksheet |
1166 | 1166 | * @param array $pValues Array containing cells in a row |
1167 | 1167 | * @param int $pRow Row number (0-based) |
1168 | - * @param mixed $cellType |
|
1168 | + * @param string $cellType |
|
1169 | 1169 | * |
1170 | 1170 | * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception |
1171 | 1171 | * |