@@ -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 | $objReader = PHPExcel_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 | $objReader->setLoadSheetsOnly($sheetnames); |
40 | 40 | $objPHPExcel = $objReader->load($inputFileName); |
41 | 41 | |
42 | 42 | echo '<hr />'; |
43 | 43 | |
44 | -echo $objPHPExcel->getSheetCount(),' worksheet',(($objPHPExcel->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />'; |
|
44 | +echo $objPHPExcel->getSheetCount(), ' worksheet', (($objPHPExcel->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />'; |
|
45 | 45 | $loadedSheetNames = $objPHPExcel->getSheetNames(); |
46 | 46 | foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) { |
47 | - echo $sheetIndex,' -> ',$loadedSheetName,'<br />'; |
|
47 | + echo $sheetIndex, ' -> ', $loadedSheetName, '<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); |
@@ -27,7 +27,7 @@ |
||
27 | 27 | |
28 | 28 | $inputFileName = './sampleData/example1.xls'; |
29 | 29 | |
30 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' using PHPExcel_Reader_Excel5<br />'; |
|
30 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' using PHPExcel_Reader_Excel5<br />'; |
|
31 | 31 | $objReader = new PHPExcel_Reader_Excel5(); |
32 | 32 | // $objReader = new PHPExcel_Reader_Excel2007(); |
33 | 33 | // $objReader = new PHPExcel_Reader_Excel2003XML(); |
@@ -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),' 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 | $worksheetNames = $objReader->listWorksheetNames($inputFileName); |
@@ -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) { |
@@ -30,11 +30,11 @@ discard block |
||
30 | 30 | |
31 | 31 | $objReader = PHPExcel_IOFactory::createReader($inputFileType); |
32 | 32 | $inputFileName = array_shift($inputFileNames); |
33 | -echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' into WorkSheet #1 using IOFactory with a defined reader type of ',$inputFileType,'<br />'; |
|
33 | +echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' into WorkSheet #1 using IOFactory with a defined reader type of ', $inputFileType, '<br />'; |
|
34 | 34 | $objPHPExcel = $objReader->load($inputFileName); |
35 | 35 | $objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME)); |
36 | 36 | foreach ($inputFileNames as $sheet => $inputFileName) { |
37 | - echo 'Loading file ',pathinfo($inputFileName, PATHINFO_BASENAME),' into WorkSheet #',($sheet + 2),' using IOFactory with a defined reader type of ',$inputFileType,'<br />'; |
|
37 | + echo 'Loading file ', pathinfo($inputFileName, PATHINFO_BASENAME), ' into WorkSheet #', ($sheet + 2), ' using IOFactory with a defined reader type of ', $inputFileType, '<br />'; |
|
38 | 38 | $objReader->setSheetIndex($sheet + 1); |
39 | 39 | $objReader->loadIntoExisting($inputFileName, $objPHPExcel); |
40 | 40 | $objPHPExcel->getActiveSheet()->setTitle(pathinfo($inputFileName, PATHINFO_BASENAME)); |
@@ -42,10 +42,10 @@ discard block |
||
42 | 42 | |
43 | 43 | echo '<hr />'; |
44 | 44 | |
45 | -echo $objPHPExcel->getSheetCount(),' worksheet',(($objPHPExcel->getSheetCount() == 1) ? '' : 's'),' loaded<br /><br />'; |
|
45 | +echo $objPHPExcel->getSheetCount(), ' worksheet', (($objPHPExcel->getSheetCount() == 1) ? '' : 's'), ' loaded<br /><br />'; |
|
46 | 46 | $loadedSheetNames = $objPHPExcel->getSheetNames(); |
47 | 47 | foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) { |
48 | - echo '<b>Worksheet #',$sheetIndex,' -> ',$loadedSheetName,'</b><br />'; |
|
48 | + echo '<b>Worksheet #', $sheetIndex, ' -> ', $loadedSheetName, '</b><br />'; |
|
49 | 49 | $objPHPExcel->setActiveSheetIndexByName($loadedSheetName); |
50 | 50 | $sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true); |
51 | 51 | var_dump($sheetData); |