@@ -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); |
@@ -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); |
@@ -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); |
@@ -32,16 +32,16 @@ |
||
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 | |
38 | 38 | /* Read the list of Worksheet Names from the Workbook file **/ |
39 | 39 | echo 'Read the list of Worksheets in the WorkBook<br />'; |
40 | 40 | $worksheetNames = $objReader->listWorksheetNames($inputFileName); |
41 | 41 | |
42 | -echo 'There are ',count($worksheetNames),' worksheet',((count($worksheetNames) == 1) ? '' : 's'),' in the workbook<br /><br />'; |
|
42 | +echo 'There are ', count($worksheetNames), ' worksheet', ((count($worksheetNames) == 1) ? '' : 's'), ' in the workbook<br /><br />'; |
|
43 | 43 | foreach ($worksheetNames as $worksheetName) { |
44 | - echo $worksheetName,'<br />'; |
|
44 | + echo $worksheetName, '<br />'; |
|
45 | 45 | } |
46 | 46 | |
47 | 47 | ?> |
@@ -34,10 +34,10 @@ |
||
34 | 34 | $h1Text = $out[1]; |
35 | 35 | $h2Text = (preg_match($h2Pattern, $fileData, $out)) ? $out[1] : ''; |
36 | 36 | |
37 | - echo '<a href="',$exampleFile,'">',$h1Text,'</a><br />'; |
|
37 | + echo '<a href="', $exampleFile, '">', $h1Text, '</a><br />'; |
|
38 | 38 | if (($h2Text > '') && |
39 | 39 | (pathinfo($exampleType, PATHINFO_BASENAME) != 'Calculations')) { |
40 | - echo $h2Text,'<br />'; |
|
40 | + echo $h2Text, '<br />'; |
|
41 | 41 | } |
42 | 42 | } |
43 | 43 | } |