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

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

$data=$db->getDataByuid($i);//查詢每個(gè)年級的學(xué)生數(shù)據(jù)

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

$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++;

}

}