$objSheet=$objPHPExcel->getActiveSheet();//獲取當前活動sheet

$objSheet->setTitle($i."用戶表");//給當前活動sheet起個名稱

$data=$db->getDataByuid($i);//查詢每個年級的學生數據

$objSheet->setCellValue("A1","用戶名")->setCellValue("B1","性別")->setCellValue("C1","郵箱")->setCellValue("D1","資料室地址")->setCellValue("E1","角色")->setCellValue("F1","學/工號")->setCellValue("G1","電話")->setCellValue("H1","注冊時間")->setCellValue("I1","學生與否")->setCellValue("J1","狀態")->setCellValue("K1","頭像");//填充數據

$j=2;

foreach($data as $key=>$val){

$objSheet->setCellValue("A".$j,$val['uname'])->setCellValue("B".$j,$val['usex'])->setCellValue("C".$j,$val['email'])->setCellValue("D".$j,$val['mid'])->setCellValue("E".$j,$val['role'])->setCellValue("F".$j,$val['number'])->setCellValue("G".$j,$val['phone'])->setCellValue("H".$j,$val['utime'])->setCellValue("I".$j,$val['student'])->setCellValue("J".$j,$val['status'])->setCellValue("K".$j,$val['portrait']);

$j++;

}

}