В $lists будут данные из документа в форме массива . Пробегаемя по нему и кладем куда надо
<?php
require_once dirname(__FILE__) . '/../PHPExcel/Classes/PHPExcel.php';
require_once dirname(__FILE__) . '/../PHPExcel/Classes/PHPExcel/IOFactory.php';
$m = new MongoClient();
$f = $_SERVER["DOCUMENT_ROOT"] ."/1/all33.xlsx" ;
$objPHPExcel = PHPExcel_IOFactory::load($dir . "$f");
$lists =null;
echo $k++ . " ". $dir .iconv("windows-1251", "UTF-8", $f) . " <br>" ;
Foreach($objPHPExcel ->getWorksheetIterator() as $worksheet) {
$lists[] = $worksheet->toArray();
}
$mysqli = new mysqli('localhost', 'root', '', 'acc');
for($i = 1; $i < count ( $lists [0] ); $i ++) {
$fam = trim( $lists [0][$i][1]) ;
$s = explode(" ", trim($lists [0][$i][2]) );
$name = trim($s[0]) ;
$otc = trim($s[1]) ;
$email = trim($lists [0][$i][3]) ;
$login = trim($lists [0][$i][9]) ;
$pass = trim($lists [0][$i][8]) ;
$sql = "INSERT INTO `users` (`id`, `fam`, `name`, `otc`, `email` , `login`, `pass` , `status`)
VALUES (NULL, '$fam' , '$name', '$otc', '$email' , '$login' , '$pass', '0') ; ";
$mysqli->query($sql);
}