Set other rows as header rows

[rognales]

Is it possible to set, for example row 3 as header row?

Because my CSVs have some notes in the first 2 rows and header row is on row 3.

My workaround now, is just noHeaderRow() and skip() few records. But with this i missed the getHeaders() or headers() features.

[pradeepchauhan453]

hi did you get any solution?

[rognales]

Here it is

Note: files generated by https://www.mockaroo.com/
The files:-

COMMENT,,,,,
AUTHOR,,,,,
id,first_name,last_name,email,gender,ip_address
1,Annecorinne,Yesinov,ayesinov0@ycombinator.com,Female,126.138.169.174
2,Mariquilla,Dakin,mdakin1@etsy.com,Female,123.105.28.137
3,Phebe,McGlone,pmcglone2@joomla.org,Female,48.3.14.174
4,Katalin,Greneham,kgreneham3@unesco.org,Female,145.189.13.75
5,Shara,Letson,sletson4@boston.com,Female,28.244.87.159

The code:-

$rows = SimpleExcelReader::create($pathToCsv)
        ->noHeaderRow()
        ->useHeaders(['id', 'first_name', 'last_name', 'email', 'gender', 'ip_address'])
        ->skip(3)
        ->getRows();

The output

[
    0 => [    
        'id' => '1',
        'first_name' => 'Annecorinne',
        'last_name' => 'Yesinov',
        'email' => 'ayesinov0@ycombinator.com',
        'gender' => 'Female',
        'ip_address' => '126.138.169.174',
    ],
    1 => [    
        'id' => '2',
        'first_name' => 'Mariquilla',
        'last_name' => 'Dakin',
        'email' => 'mdakin1@etsy.com',
        'gender' => 'Female',
        'ip_address' => '123.105.28.137',
    ],
    2 => [    
        'id' => '3',
        'first_name' => 'Phebe',
        'last_name' => 'McGlone',
        'email' => 'pmcglone2@joomla.org',
        'gender' => 'Female',
        'ip_address' => '48.3.14.174',
    ],
    3 => [    
        'id' => '4',
        'first_name' => 'Katalin',
        'last_name' => 'Greneham',
        'email' => 'kgreneham3@unesco.org',
        'gender' => 'Female',
        'ip_address' => '145.189.13.75',
    ],
    4 => [    
        'id' => '5',
        'first_name' => 'Shara',
        'last_name' => 'Letson',
        'email' => 'sletson4@boston.com',
        'gender' => 'Female',
        'ip_address' => '28.244.87.159',
    ],
]

[pradeepchauhan453]

Thanks and appreciate your support, may god bless you and your dreams come true bro.

[pradeepchauhan453]

Is it possible to set, for example row 3 as header row?

Because my CSVs have some notes in the first 2 rows and header row is on row 3.

My workaround now, is just noHeaderRow() and skip() few records. But with this i missed the getHeaders() or headers() features.

did you get any solution?