How to Skip Header from Excel Spreadsheet While Uploading to MySQL

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

yes agreed. Skip the first row as you iterate over the spreadsheet.

<?php
require_once('../../php-excel-reader/excel_reader2.php');
require_once('../../SpreadsheetReader.php');

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

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

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

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

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

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

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

                $year_of_adm = "";
                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 = "INSERT INTO ... (...,...,..) VALUES('".$student_id."','".$roll_no."','".$student_name."','".$class_name."','".$dob."','".$gender."','".$state."','".$year_of_adm."','".$password."')";
                    $result = mysqli_query($conn, $query);
                
                    if (! empty($result)) {
                        $type = "success";
                        $message = "Students' Data Imported into the Database";
                    } else {
                        $type = "error";
                        $message = $conn->error;
                    }
                }
             }
        
         }
  }
  else
  { 
        $type = "error";
        $message = "Invalid File Type. Choose Excel File.";
  }
}
?>

Select allOpen in new window

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:
   $message = "Select Excel file to continue"

If wrong file is selected:
   $message = "Invalid File Type. Choose Excel File Only"

Thank you so much

Thank you so much sir