PHPExcel toArray skip first header row

php phpexcel phpexcelreader
Sohan Patel picture Sohan Patel · Apr 5, 2015 · Viewed 14.9k times · Source

I'm uploading an excel file to website and process it for database use.

I'm using toArray() function to get all rows in a php array.

But I want to skip the first row ( header title row). The rest of rows will be stored in array.

How can I skip the first row.

Note : I can't use rangeToArray() function since there is not fixed range to get rows into array. It is dynamic. All i want is get all rows except first.

Answer

Mark Baker picture Mark Baker · Apr 5, 2015

Eko answers half the problem, you can use rangeToArray(); but you don't need to use a loop at all:

$highestRow = $sheet->getHighestRow(); 
$highestColumn = $sheet->getHighestColumn();

$sheetData = $sheet->rangeToArray(
    'A2:' . $highestColumn . $highestRow,
    NULL,TRUE,FALSE
);

Alternatively, use toArray() and then just unset the first element from the returned array

Related questions

Adding Image to the Excel in phpexcel in php

I am taking the example from phpexcel I just tried with passing value in GET Method, I am done with that. Now i am trying to add image in the a3 coloumn. Reference Code : <?php $value = $_GET['value']; error_…

Read More
How do I use PHPExcel to read data from an Excel file?

I want to read data from an Excel file in PHP so that I can process the data and insert it into a DB. Looking around SO, it looks like PHPExcel is the premier library for this task. I went …

Read More
Convert HTML file to Excel using PHPExcel

I have required to convert html file (test.html) to excel in PHPExcel myhtml file text.html it is save test.php but containt of html please idea how to implement in this

Read More