How can i parse and read the excel file in CakePHP 4?

Question

I want to read my excel file which is xlsx formate. There are some error coming. What can I do? This is cakephp 4. And there I use SimpleXLSX class. There is my index PHP file. index.php

<h2>Upload form</h2>
<form method="post" enctype="multipart/form-data">
    <input type="file" name="file"  />
    <input type="submit" value="Parse" />
</form>

<?php

//https://github.com/shuchkin/simplexlsx/blob/master/src/SimpleXLSX.php THIS CLASS I USE THERE

ini_set('error_reporting', E_ALL);
ini_set('display_errors', true);

echo '<h1>XLSX to HTML</h1>';

if (isset($_FILES['file'])) {
    
    if ( $xlsx = SimpleXLSX::parse( $_FILES['file']['tmp_name'] ) ) {

        echo '<h2>Parsing Result</h2>';
        echo '<table border="1" cellpadding="3" style="border-collapse: collapse">';

        $dim = $xlsx->dimension();
        $cols = $dim[0];

        foreach ( $xlsx->rows() as $k => $r ) {
            echo '<tr>';
            for ( $i = 0; $i < $cols; $i ++ ) {
                echo '<td>' . ( isset( $r[ $i ] ) ? $r[ $i ] : '&nbsp;' ) . '</td>';
            }
            echo '</tr>';
        }
        echo '</table>';
    } else {
        echo SimpleXLSX::parseError();
    }
}

Nothing to write in controller.

excelController.php

<?php
    
    namespace App\Controller;
    
    class excelController extends AppController
    {
        /**
         * Index method
         *
         * @return \Cake\Http\Response|null|void Renders view
         */
        public function index()
        {
            
        }
    }

Answer 1

'''<?php

echo '

Parsing Excel Data

'; echo '';

$i = 0;

foreach ($xlsx->rows() as $elt) {
 
if ($i == 0) {
    echo "<tr><th scope='col'>" . $elt[0] . "</th><th scope='col'>" . $elt[1] . "</th><th scope='col'>" . $elt[2] . "</th><th scope='col'>" . $elt[3] . "</th><th scope='col'>" . $elt[4] . "</th><th scope='col'>" . 'Remark' . "</th></tr>";
} 
else 
{
    echo "<tbody>";

    if(gettype($elt[0]) == 'integer' && gettype($elt[1]) == 'integer' && gettype($elt[2]) == 'integer' && gettype($elt[3]) == 'integer' && gettype($elt[4]) == 'integer'){
        echo "<tr><td>" . $elt[0] . "</td><td>" . $elt[1] . "</td><td>" . $elt[2] . "</td><td>" . $elt[3] . "</td><td>" . $elt[4] . "</td><td>" . '<button type="button" class="btn btn-primary">Candidate List</button><button type="button" class="btn btn-light">Candidate List(Examiner)</button>' . "</td></tr>";
    }
    else{
        if(gettype($elt[0]) == 'string'){
            echo "<tr class='danger'><td style='color: red;'>" . '<h4><del>'.$elt[0].'</del></h4>' . "</td><td>" . $elt[1] . "</td><td>" . $elt[2] . "</td><td>" . $elt[3] . "</td><td>" . $elt[4] . "</td><td>" . '<h6 class="text-center">Please Input the Correct Data.</h5>' . "</td></tr>";
        }
        else if(gettype($elt[1]) == 'string'){
            echo "<tr class='danger'><td>" . $elt[0] . "</td><td style='color: red;'>" . '<h4><del>'.$elt[1].'</del></h4>' . "</td><td>" . $elt[2] . "</td><td>" . $elt[3] . "</td><td>" . $elt[4] . "</td><td>" . '<h6 class="text-center">Please Input the Correct Data.</h5>' . "</td></tr>";
        }
        else if(gettype($elt[2]) == 'string'){
            echo "<tr class='danger'><td>" . $elt[0] . "</td><td>" . $elt[1] . "</td><td style='color: red;'>" . '<h4><del>'.$elt[2].'</del></h4>' . "</td><td>" . $elt[3] . "</td><td>" . $elt[4] . "</td><td>" . '<h6 class="text-center">Please Input the Correct Data.</h5>' . "</td></tr>";
        }
        else if(gettype($elt[3]) == 'string'){
            echo "<tr class='danger'><td>" . $elt[0] . "</td><td>" . $elt[1] . "</td><td>" . $elt[2] . "</td><td style='color: red;'>" . '<h4><del>'.$elt[3].'</del></h4>' . "</td><td>" . $elt[4] . "</td><td>" . '<h6 class="text-center">Please Input the Correct Data.</h5>' . "</td></tr>";
        }
        else if(gettype($elt[4]) == 'string'){
            echo "<tr class='danger'><td>" . $elt[0] . "</td><td>" . $elt[1] . "</td><td>" . $elt[2] . "</td><td>".$elt[3]."</td><td style='color: red;'>" . '<h4><del>'.$elt[4].'</del></h4>' . "</td><td>" . '<h6 class="text-center">Please Input the Correct Data.</h5>' . "</td></tr>";
        }
        
    }

    
}      

$i++;

}

echo "";

?>'''

Use this code in View and for controller '''$data = $this->request->data; if ($data['file']) {

        if ( $xlsx = SimpleXLSX::parse( $data['file']['tmp_name'] ) ) {
            $dim = $xlsx->dimension();
            $cols = $dim[0];

            $this->set(compact('xlsx', 'dim', 'cols'));
        } else {
            echo SimpleXLSX::parseError();
        }
    }'''