php操作Excel 导入导出表格

转载自:飞机直达
导入，第一步，下载PHPExcel包。

    include_once('PHPExcel/PHPExcel.php'); 

    $file = $_FILES['file'];  //上传
    $hz = substr(strrchr($file["name"], '.'), 1); //文件的后缀 xls/xlxs
    $newName = "test" . '.' . $hz;
    move_uploaded_file($file["tmp_name"], "upload/" . $newName); //保存
    //实例化数据库
    $pass = new pass();
    $mysqli = $pass ->dbtb();
    $PHPExcel=new PHPExcel();
    $filename = $newName;

    $info = substr($filename,(strrpos($filename,".")+1)); //后缀

    $info == "xls" ? $objReader = \PHPExcel_IOFactory::createReader('Excel5') : $objReader = \PHPExcel_IOFactory::createReader('Excel2007');
    $objPHPExcel = $objReader->load('upload/'.$filename,$encode ='utf-8');//加载表格文件
    $sheet = $objPHPExcel->getSheet(0);//获取工作表1的对象
    $highestRow = $sheet->getHighestRow(); // 取得总行数
    $highestColumn = $sheet->getHighestColumn(); // 取得总列数
        for($i=2;$i<=$highestRow;$i++) {     //逐行读取数据写入数据库
                 $num_id = $objPHPExcel->getActiveSheet()->getCell("A" . $i)->getValue(); //num_iid
                 $title = $objPHPExcel->getActiveSheet()->getCell("B" . $i)->getValue(); //标题
                 $thumb = $objPHPExcel->getActiveSheet()->getCell("C" . $i)->getValue(); //主图
                 $sql_insert = "insert into items (num_iid,title,thumb) values ('$num_id','$title','$thumb')";
                 $mysqli->query($sql_insert);

     }