@@ -38,13 +38,13 @@ |
||
38 | 38 | echo 'Reading the number of Worksheets in the WorkBook<br />'; |
39 | 39 | /* Use the PHPExcel object's getSheetCount() method to get a count of the number of WorkSheets in the WorkBook */ |
40 | 40 | $sheetCount = $objPHPExcel->getSheetCount(); |
41 | -echo 'There ',(($sheetCount == 1) ? 'is' : 'are'),' ',$sheetCount,' WorkSheet',(($sheetCount == 1) ? '' : 's'),' in the WorkBook<br /><br />'; |
|
41 | +echo 'There ', (($sheetCount == 1) ? 'is' : 'are'), ' ', $sheetCount, ' WorkSheet', (($sheetCount == 1) ? '' : 's'), ' in the WorkBook<br /><br />'; |
|
42 | 42 | |
43 | 43 | echo 'Reading the names of Worksheets in the WorkBook<br />'; |
44 | 44 | /* Use the PHPExcel object's getSheetNames() method to get an array listing the names/titles of the WorkSheets in the WorkBook */ |
45 | 45 | $sheetNames = $objPHPExcel->getSheetNames(); |
46 | 46 | foreach ($sheetNames as $sheetIndex => $sheetName) { |
47 | - echo 'WorkSheet #',$sheetIndex,' is named "',$sheetName,'"<br />'; |
|
47 | + echo 'WorkSheet #', $sheetIndex, ' is named "', $sheetName, '"<br />'; |
|
48 | 48 | } |
49 | 49 | |
50 | 50 | ?> |
@@ -28,9 +28,9 @@ |
||
28 | 28 | $inputFileName = './sampleData/example1.xls'; |
29 | 29 | |
30 | 30 | $inputFileType = PHPExcel_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 | $objReader = PHPExcel_IOFactory::createReader($inputFileType); |
35 | 35 | $objPHPExcel = $objReader->load($inputFileName); |
36 | 36 |
@@ -26,7 +26,7 @@ |
||
26 | 26 | include 'PHPExcel/IOFactory.php'; |
27 | 27 | |
28 | 28 | $inputFileName = './sampleData/example_1.xls'; |
29 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory to identify the format<br />'; |
|
29 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory to identify the format<br />'; |
|
30 | 30 | try { |
31 | 31 | $objPHPExcel = PHPExcel_IOFactory::load($inputFileName); |
32 | 32 | } catch (\PHPExcel\Reader\Exception $e) { |
@@ -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); |
@@ -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 | $objReader = PHPExcel_IOFactory::createReader($inputFileType); |
67 | -echo 'Loading Sheet "',$sheetname,'" only<br />'; |
|
67 | +echo 'Loading Sheet "', $sheetname, '" only<br />'; |
|
68 | 68 | $objReader->setLoadSheetsOnly($sheetname); |
69 | 69 | echo 'Loading Sheet using configurable filter<br />'; |
70 | 70 | $objReader->setReadFilter($filterSubset); |
@@ -26,7 +26,7 @@ |
||
26 | 26 | include 'PHPExcel/IOFactory.php'; |
27 | 27 | |
28 | 28 | $inputFileName = './sampleData/example_1.xls'; |
29 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using IOFactory to identify the format<br />'; |
|
29 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using IOFactory to identify the format<br />'; |
|
30 | 30 | try { |
31 | 31 | $objPHPExcel = PHPExcel_IOFactory::load($inputFileName); |
32 | 32 | } catch (\PHPExcel\Reader\Exception $e) { |
@@ -62,7 +62,7 @@ |
||
62 | 62 | /* Tell the Reader that we want to use the Read Filter that we've Instantiated **/ |
63 | 63 | /* and that we want to store it in contiguous rows/columns **/ |
64 | 64 | $objReader->setReadFilter($chunkFilter) |
65 | - ->setContiguous(true); |
|
65 | + ->setContiguous(true); |
|
66 | 66 | |
67 | 67 | /* Instantiate a new PHPExcel object manually **/ |
68 | 68 | $objPHPExcel = new PHPExcel(); |
@@ -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); |
@@ -57,7 +57,7 @@ discard block |
||
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 | $objReader = PHPExcel_IOFactory::createReader($inputFileType); |
63 | 63 | |
@@ -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 | /* Tell the Read Filter, the limits on which rows we want to read this iteration **/ |
78 | 78 | $chunkFilter->setRows($startRow, $chunkSize); |
79 | 79 | /* Load only the rows that match our filter from $inputFileName to a PHPExcel Object **/ |
@@ -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 | $objReader = PHPExcel_IOFactory::createReader($inputFileType); |
38 | 38 | $worksheetData = $objReader->listWorksheetInfo($inputFileName); |