Download excel_reader2.php <?php ini_set("display_errors",0); require_once 'excel_reader2.php'; define('DB_SERVER', 'localhost'); define('DB_USERNAME', 'root'); define('DB_PASSWORD', ''); define('DB_DATABASE', 'simpeg'); $connection = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE); $data = new Spreadsheet_Excel_Reader("sks20161.XLS"); echo "Total Sheets in this xls file: ".count($data->sheets)."<br /><br />"; $html="<table border='0'>"; for($i=0;$i<count($data->sheets);$i++) // Loop to get all sheets in a file. { if(count($data->sheets[$i][cells])>0) // checking sheet not empty { echo "Sheet $i:<br /><br />Total rows in sheet $i ".count($data->sheets[$i][cells])."<br />"; for($j=1;$j<=count($data->sheets[$i][cells]);$j++) // loop ...