@@ -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 | $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType); |
37 | 37 | echo 'Turning Formatting off for Load<br />'; |
38 | 38 | $reader->setReadDataOnly(true); |
@@ -33,18 +33,18 @@ |
||
33 | 33 | $inputFileName = './sampleData/example1.xls'; |
34 | 34 | $sheetnames = ['Data Sheet #1', 'Data Sheet #3']; |
35 | 35 | |
36 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />'; |
|
36 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />'; |
|
37 | 37 | $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType); |
38 | -echo 'Loading Sheet',((count($sheetnames) == 1) ? '' : 's'),' "',implode('" and "', $sheetnames),'" only<br />'; |
|
38 | +echo 'Loading Sheet', ((count($sheetnames) == 1) ? '' : 's'), ' "', implode('" and "', $sheetnames), '" only<br />'; |
|
39 | 39 | $reader->setLoadSheetsOnly($sheetnames); |
40 | 40 | $spreadsheet = $reader->load($inputFileName); |
41 | 41 | |
42 | 42 | echo '<hr />'; |
43 | 43 | |
44 | -echo $spreadsheet->getSheetCount(),' worksheet',(($spreadsheet->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />'; |
|
44 | +echo $spreadsheet->getSheetCount(), ' worksheet', (($spreadsheet->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />'; |
|
45 | 45 | $loadedSheetNames = $spreadsheet->getSheetNames(); |
46 | 46 | foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) { |
47 | - echo $sheetIndex,' -> ',$loadedSheetName,'<br />'; |
|
47 | + echo $sheetIndex, ' -> ', $loadedSheetName, '<br />'; |
|
48 | 48 | } |
49 | 49 | |
50 | 50 | ?> |
@@ -62,9 +62,9 @@ |
||
62 | 62 | |
63 | 63 | $filterSubset = new MyReadFilter(9, 15, range('G', 'K')); |
64 | 64 | |
65 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />'; |
|
65 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />'; |
|
66 | 66 | $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType); |
67 | -echo 'Loading Sheet "',$sheetname,'" only<br />'; |
|
67 | +echo 'Loading Sheet "', $sheetname, '" only<br />'; |
|
68 | 68 | $reader->setLoadSheetsOnly($sheetname); |
69 | 69 | echo 'Loading Sheet using configurable filter<br />'; |
70 | 70 | $reader->setReadFilter($filterSubset); |
@@ -62,7 +62,7 @@ discard block |
||
62 | 62 | } |
63 | 63 | } |
64 | 64 | |
65 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />'; |
|
65 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />'; |
|
66 | 66 | /* Create a new Reader of the type defined in $inputFileType **/ |
67 | 67 | $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType); |
68 | 68 | |
@@ -73,7 +73,7 @@ discard block |
||
73 | 73 | |
74 | 74 | /* Loop to read our worksheet in "chunk size" blocks **/ |
75 | 75 | for ($startRow = 2; $startRow <= 240; $startRow += $chunkSize) { |
76 | - echo 'Loading WorkSheet using configurable filter for headings row 1 and for rows ',$startRow,' to ',($startRow + $chunkSize - 1),'<br />'; |
|
76 | + echo 'Loading WorkSheet using configurable filter for headings row 1 and for rows ', $startRow, ' to ', ($startRow + $chunkSize - 1), '<br />'; |
|
77 | 77 | /* Create a new Instance of our Read Filter, passing in the limits on which rows we want to read **/ |
78 | 78 | $chunkFilter = new chunkReadFilter($startRow, $chunkSize); |
79 | 79 | /* Tell the Reader that we want to use the new Read Filter that we've just Instantiated **/ |
@@ -33,18 +33,18 @@ |
||
33 | 33 | $inputFileName = './sampleData/example1.xls'; |
34 | 34 | $sheetname = 'Data Sheet #2'; |
35 | 35 | |
36 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />'; |
|
36 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />'; |
|
37 | 37 | $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType); |
38 | -echo 'Loading Sheet "',$sheetname,'" only<br />'; |
|
38 | +echo 'Loading Sheet "', $sheetname, '" only<br />'; |
|
39 | 39 | $reader->setLoadSheetsOnly($sheetname); |
40 | 40 | $spreadsheet = $reader->load($inputFileName); |
41 | 41 | |
42 | 42 | echo '<hr />'; |
43 | 43 | |
44 | -echo $spreadsheet->getSheetCount(),' worksheet',(($spreadsheet->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />'; |
|
44 | +echo $spreadsheet->getSheetCount(), ' worksheet', (($spreadsheet->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />'; |
|
45 | 45 | $loadedSheetNames = $spreadsheet->getSheetNames(); |
46 | 46 | foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) { |
47 | - echo $sheetIndex,' -> ',$loadedSheetName,'<br />'; |
|
47 | + echo $sheetIndex, ' -> ', $loadedSheetName, '<br />'; |
|
48 | 48 | } |
49 | 49 | |
50 | 50 | ?> |
@@ -32,7 +32,7 @@ |
||
32 | 32 | // $inputFileType = 'Gnumeric'; |
33 | 33 | $inputFileName = './sampleData/example1.xls'; |
34 | 34 | |
35 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' information using IOFactory with a defined reader type of ',$inputFileType,'<br />'; |
|
35 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' information using IOFactory with a defined reader type of ', $inputFileType, '<br />'; |
|
36 | 36 | |
37 | 37 | $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType); |
38 | 38 | $worksheetData = $reader->listWorksheetInfo($inputFileName); |
@@ -27,7 +27,7 @@ |
||
27 | 27 | |
28 | 28 | $inputFileName = './sampleData/example1.xls'; |
29 | 29 | |
30 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using \PhpOffice\PhpSpreadsheet\Reader\Xls<br />'; |
|
30 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using \PhpOffice\PhpSpreadsheet\Reader\Xls<br />'; |
|
31 | 31 | $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xls(); |
32 | 32 | // $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx(); |
33 | 33 | // $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xml(); |
@@ -50,9 +50,9 @@ |
||
50 | 50 | |
51 | 51 | $filterSubset = new MyReadFilter(); |
52 | 52 | |
53 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory with a defined reader type of ',$inputFileType,'<br />'; |
|
53 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />'; |
|
54 | 54 | $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType); |
55 | -echo 'Loading Sheet "',$sheetname,'" only<br />'; |
|
55 | +echo 'Loading Sheet "', $sheetname, '" only<br />'; |
|
56 | 56 | $reader->setLoadSheetsOnly($sheetname); |
57 | 57 | echo 'Loading Sheet using filter<br />'; |
58 | 58 | $reader->setReadFilter($filterSubset); |
@@ -32,7 +32,7 @@ |
||
32 | 32 | // $inputFileType = 'Gnumeric'; |
33 | 33 | $inputFileName = './sampleData/example1.xls'; |
34 | 34 | |
35 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' information using IOFactory with a defined reader type of ',$inputFileType,'<br />'; |
|
35 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' information using IOFactory with a defined reader type of ', $inputFileType, '<br />'; |
|
36 | 36 | |
37 | 37 | $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($inputFileType); |
38 | 38 | $worksheetNames = $reader->listWorksheetNames($inputFileName); |