Vreau import Excel dar doar pe foaie index[0], dar când am folosi toCollection sau toArray metoda rânduri înfășurat pe foaie index array:
Vreau elimina înfășurat părinte matrice, cum să faci asta?
Aici este codul meu:
Import.php
<?php
namespace App\Imports;
use Maatwebsite\Excel\Concerns\Importable;
use Maatwebsite\Excel\Concerns\SkipsEmptyRows;
use Maatwebsite\Excel\Concerns\WithCalculatedFormulas;
use Maatwebsite\Excel\Concerns\WithMultipleSheets;
class Import implements SkipsEmptyRows,
WithCalculatedFormulas,
WithMultipleSheets
{
use Importable;
/**
* Select sheet by index and how they are
* mapped to specific import object.
*
* @return array
*/
public function sheets(): array
{
return [
0 => new static(),
];
}
}
Controller:
$filePath = 'import-excel.xlsx';
$import = new Import();
$rows = $import->toCollection($filePath);
dd($rows->toArray());
Rezultat Așteptat:
[0] => Array(
[0] => *Contact Name
[1] => *Contact Email
[2] => *Contact Address
)
[1] => Array (
[0] => Talia Oktaviani S.Psi
[1] => [email protected]
[2] => Ds. Abdul No. 618 Tarakan 11408 KalU
)
Rezultatul Real:
Array( <== ***I want remove this.***
[0] => Array( <== ***I want remove this.***
[0] => Array(
[0] => *Contact Name
[1] => *Contact Email
[2] => *Contact Address
)
[1] => Array (
[0] => Talia Oktaviani S.Psi
[1] => [email protected]
[2] => Ds. Abdul No. 618 Tarakan 11408 KalU
)
) <== ***I want remove this.***
) <== ***I want remove this.***