<div>
Hi Opeyemi, 
 
You'll need to show us your code. 
 
I would guess that if you're running a for loop to get the data, then you would start at row 1 instead of row 0
</div>

<div>
yes agreed. Skip the first row as you iterate over the spreadsheet.
</div>

<div>
<pre><code class="code-10 nolinks" id="code-20-42680550-1">&lt;?php
require_once('../../php-excel-reader/excel_reader2.php');
require_once('../../SpreadsheetReader.php');

if (isset($_POST[&quot;import&quot;]))
{
 
 
 $allowedFileType = ['application/vnd.ms-excel','text/xls','text/xlsx','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'];
 
 if(in_array($_FILES[&quot;file&quot;][&quot;type&quot;],$allowedFileType)){

 $targetPath = '../assets/uploads/'.$_FILES['file']['name'];
 move_uploaded_file($_FILES['file']['tmp_name'], $targetPath);
 
 $Reader = new SpreadsheetReader($targetPath);
 
 $sheetCount = count($Reader-&gt;sheets());
 for($i=0;$i&lt;$sheetCount;$i++)
 {
 
 $Reader-&gt;ChangeSheet($i);
 
 foreach ($Reader as $Row)
 {
 
 $student_id = &quot;&quot;;
 if(isset($Row[0])) {
 $student_id = mysqli_real_escape_string($conn,$Row[0]);
 }
 
 $roll_no = &quot;&quot;;
 if(isset($Row[1])) {
 $roll_no = mysqli_real_escape_string($conn,$Row[1]);
 }

 $student_name = &quot;&quot;;
 if(isset($Row[2])) {
 $student_name = mysqli_real_escape_string($conn,$Row[2]);
 }

 $class_name = &quot;&quot;;
 if(isset($Row[3])) {
 $class_name = mysqli_real_escape_string($conn,$Row[3]);
 }

 $date_of_birth = &quot;&quot;;
 if(isset($Row[4])) {
 $date_of_birth = DateTime::createFromFormat(&quot;d/m/Y&quot;, $Row[4]); // create a new datetime object
 $dob = $date_of_birth-&gt;format(&quot;Y-m-d&quot;); // format the datetime object
 }

 $gender = &quot;&quot;;
 if(isset($Row[5])) {
 $gender = mysqli_real_escape_string($conn,$Row[5]);
 }

 $state = &quot;&quot;;
 if(isset($Row[6])) {
 $state = mysqli_real_escape_string($conn,$Row[6]);
 }

 $year_of_adm = &quot;&quot;;
 if(isset($Row[7])) {
 $year_of_adm = mysqli_real_escape_string($conn,$Row[7]);
 }
 
 $password = mt_rand(10000000,99999999);
 
 if (!empty($student_id) || !empty($roll_no) || !empty($student_name) || !empty($class_name) || !empty($date_of_birth) || !empty($gender) || !empty($state) || !empty($year_of_adm) ) {
 $query = &quot;INSERT INTO ... (...,...,..) VALUES('&quot;.$student_id.&quot;','&quot;.$roll_no.&quot;','&quot;.$student_name.&quot;','&quot;.$class_name.&quot;','&quot;.$dob.&quot;','&quot;.$gender.&quot;','&quot;.$state.&quot;','&quot;.$year_of_adm.&quot;','&quot;.$password.&quot;')&quot;;
 $result = mysqli_query($conn, $query);
 
 if (! empty($result)) {
 $type = &quot;success&quot;;
 $message = &quot;Students' Data Imported into the Database&quot;;
 } else {
 $type = &quot;error&quot;;
 $message = $conn-&gt;error;
 }
 }
 }
 
 }
 }
 else
 { 
 $type = &quot;error&quot;;
 $message = &quot;Invalid File Type. Choose Excel File.&quot;;
 }
}
?&gt;
</code></pre>
Please if you think the script could be better, help me out. 
In addition, please help me re-arrange the logic so it goes like this: 
If no file is selected: 
&nbsp; &nbsp;$message = &quot;Select Excel file to continue&quot; 
 
If wrong file is selected: 
&nbsp; &nbsp;$message = &quot;Invalid File Type. Choose Excel File Only&quot; 
 
Thank you so much
</div>

Opeyemi AbdulRasheed

<div>
<div class="content wysiwyg-content">
Hello Experts! 
 
Is it possible by code to skip the Header (Top Row) in Excel Spreadsheet? 
I'm using PHPExcel_Reader to process upload into database. 
See attached. 
<a href="https://filedb.experts-exchange.com/incoming/2018/09_w37/1383509/Screenshot_4.png" target="_blank" title="Screenshot_4.png (12 KB)"><img alt="Screenshot_4.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2018/09_w37/800_1383509/Screenshot_4.png" /></a> 
Thank you.
</div>
</div>

Screenshot_4.png

Hello Experts!

Is it possible by code to skip the Header (Top Row) in Excel Spreadsheet?
I'm using PHPExcel_Reader to process upload into database.
See attached.
 
Thank you.

How to Skip Header from Excel Spreadsheet While Uploading to MySQL

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.