View GitHub Repository PhpSpreadsheet

Schedule Inspection
Subscribe

Code Duplication    Length = 6-6 lines in 5 locations

samples/Reader/13_Simple_file_reader_for_multiple_CSV_files.php 1 location

@@ 24-29 (lines=6) @@
21 

                                

                                                            

                                    22
                                    
                                    
$helper->log($spreadsheet->getSheetCount() . ' worksheet' . (($spreadsheet->getSheetCount() == 1) ? '' : 's') . ' loaded');

                                

                                                            

                                    23
                                    
                                    
$loadedSheetNames = $spreadsheet->getSheetNames();

                                

                                                            

                                    24
                                    
                                    
foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {

                                

                                                            

                                    25
                                    
                                    
    $helper->log('<b>Worksheet #' . $sheetIndex . ' -> ' . $loadedSheetName . '</b>');

                                

                                                            

                                    26
                                    
                                    
    $spreadsheet->setActiveSheetIndexByName($loadedSheetName);

                                

                                                            

                                    27
                                    
                                    
    $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);

                                

                                                            

                                    28
                                    
                                    
    var_dump($sheetData);

                                

                                                            

                                    29
                                    
                                    
}

                                

                                                            

                                    30
                                    
                                    

                                

                                                                        

                

                                                            

                    
samples/Reader/14_Reading_a_large_CSV_file_in_chunks_to_split_across_multiple_worksheets.php 1 location

                

                

                    

                                                
                                                    

                                
                                
                                    @@ 80-85 (lines=6) @@
                                
                            


                                                            

                                    77
                                    
                                    

                                

                                                            

                                    78
                                    
                                    
$helper->log($spreadsheet->getSheetCount() . ' worksheet' . (($spreadsheet->getSheetCount() == 1) ? '' : 's') . ' loaded');

                                

                                                            

                                    79
                                    
                                    
$loadedSheetNames = $spreadsheet->getSheetNames();

                                

                                                            

                                    80
                                    
                                    
foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {

                                

                                                            

                                    81
                                    
                                    
    $helper->log('<b>Worksheet #' . $sheetIndex . ' -> ' . $loadedSheetName . '</b>');

                                

                                                            

                                    82
                                    
                                    
    $spreadsheet->setActiveSheetIndexByName($loadedSheetName);

                                

                                                            

                                    83
                                    
                                    
    $sheetData = $spreadsheet->getActiveSheet()->toArray(null, false, false, true);

                                

                                                            

                                    84
                                    
                                    
    var_dump($sheetData);

                                

                                                            

                                    85
                                    
                                    
}

                                

                                                            

                                    86
                                    
                                    

                                

                                                                        

                

                                                            

                    
samples/Reader/15_Simple_file_reader_for_tab_separated_value_file_using_the_Advanced_Value_Binder.php 3 locations

                

                

                    

                                                
                                                    

                                
                                
                                    @@ 21-26 (lines=6) @@
                                
                            


                                                            

                                    18
                                    
                                    

                                

                                                            

                                    19
                                    
                                    
$helper->log($spreadsheet->getSheetCount() . ' worksheet' . (($spreadsheet->getSheetCount() == 1) ? '' : 's') . ' loaded');

                                

                                                            

                                    20
                                    
                                    
$loadedSheetNames = $spreadsheet->getSheetNames();

                                

                                                            

                                    21
                                    
                                    
foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {

                                

                                                            

                                    22
                                    
                                    
    $helper->log('<b>Worksheet #' . $sheetIndex . ' -> ' . $loadedSheetName . ' (Formatted)</b>');

                                

                                                            

                                    23
                                    
                                    
    $spreadsheet->setActiveSheetIndexByName($loadedSheetName);

                                

                                                            

                                    24
                                    
                                    
    $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);

                                

                                                            

                                    25
                                    
                                    
    var_dump($sheetData);

                                

                                                            

                                    26
                                    
                                    
}

                                

                                                            

                                    27
                                    
                                    

                                

                                                            

                                    28
                                    
                                    
foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {

                                

                                                            

                                    29
                                    
                                    
    $helper->log('<b>Worksheet #' . $sheetIndex . ' -> ' . $loadedSheetName . ' (Unformatted)</b>');

                                

                                                                                

                                
                                
                                    @@ 28-33 (lines=6) @@
                                
                            


                                                            

                                    25
                                    
                                    
    var_dump($sheetData);

                                

                                                            

                                    26
                                    
                                    
}

                                

                                                            

                                    27
                                    
                                    

                                

                                                            

                                    28
                                    
                                    
foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {

                                

                                                            

                                    29
                                    
                                    
    $helper->log('<b>Worksheet #' . $sheetIndex . ' -> ' . $loadedSheetName . ' (Unformatted)</b>');

                                

                                                            

                                    30
                                    
                                    
    $spreadsheet->setActiveSheetIndexByName($loadedSheetName);

                                

                                                            

                                    31
                                    
                                    
    $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, false, true);

                                

                                                            

                                    32
                                    
                                    
    var_dump($sheetData);

                                

                                                            

                                    33
                                    
                                    
}

                                

                                                            

                                    34
                                    
                                    

                                

                                                            

                                    35
                                    
                                    
foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {

                                

                                                            

                                    36
                                    
                                    
    $helper->log('<b>Worksheet #' . $sheetIndex . ' -> ' . $loadedSheetName . ' (Raw)</b>');

                                

                                                                                

                                
                                
                                    @@ 35-40 (lines=6) @@
                                
                            


                                                            

                                    32
                                    
                                    
    var_dump($sheetData);

                                

                                                            

                                    33
                                    
                                    
}

                                

                                                            

                                    34
                                    
                                    

                                

                                                            

                                    35
                                    
                                    
foreach ($loadedSheetNames as $sheetIndex => $loadedSheetName) {

                                

                                                            

                                    36
                                    
                                    
    $helper->log('<b>Worksheet #' . $sheetIndex . ' -> ' . $loadedSheetName . ' (Raw)</b>');

                                

                                                            

                                    37
                                    
                                    
    $spreadsheet->setActiveSheetIndexByName($loadedSheetName);

                                

                                                            

                                    38
                                    
                                    
    $sheetData = $spreadsheet->getActiveSheet()->toArray(null, false, false, true);

                                

                                                            

                                    39
                                    
                                    
    var_dump($sheetData);

                                

                                                            

                                    40
                                    
                                    
}

                                

                                                            

                                    41