SimpleXLSX dimension returns 0 cols and 0 rows

hi,

I have an Excel file with 5 lines and 40 columns. I want to my user insert column name and lines values in a database table.

In my code I did this :

if ( $xlsx = SimpleXLSX::parse( $_FILES['file']['tmp_name'] ) )
{
list( $num_cols, $num_rows) = $xlsx->dimension();
foreach ( $xlsx->rows() as $k => $r ) {
for ( $i = 0; $i < $num_cols; $i ++ ) {
echo $r[$i];
}
}
}

Never give the echo command because not passed into for loop

Can you help me, please ?

Thks

don't trust ->dimension

extract your cells

foreach( $xlsx->rows as $r ) {
foreach( $r as $cell ) ...

Hi, Sergey

Thks for your help. If I need to read rowsEx to get cell format, I do the same way ?

Regards,

André