Rimuovere il Foglio di Padre Array di Importazione di insieme o di una Matrice su Laravel Excel Pacchetto

0

Domanda

Voglio importare in Excel, ma solo sul foglio di indice[0], ma quando uso toCollection o metodo toArray le righe avvolto in foglio di indice di array:

Voglio rimuovere il avvolta genitore array, come fare questo?

Ecco il mio codice:

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());

Risultato Previsto:

[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
)

Risultato:

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.***
arrays excel import laravel
2021-11-24 00:35:38
1

Migliore risposta

1

Si può eliminare se uso il collasso della funzione

$filePath = 'import-excel.xlsx';
$import = new Import();
$rows = $import->toCollection($filePath)->collapse();

dd($rows->toArray());
2021-11-25 14:29:13

In altre lingue

Questa pagina è in altre lingue

Русский
..................................................................................................................
Polski
..................................................................................................................
Română
..................................................................................................................
한국어
..................................................................................................................
हिन्दी
..................................................................................................................
Français
..................................................................................................................
Türk
..................................................................................................................
Česk
..................................................................................................................
Português
..................................................................................................................
ไทย
..................................................................................................................
中文
..................................................................................................................
Español
..................................................................................................................
Slovenský
..................................................................................................................