$idcard = I('IDcard');

if ($studentname != '') {

$sql['Studentname'] ="$studentname";

}

if ($idcard != '') {

$sql['IDcard'] ="$idcard";

};

$sql['_logic'] = 'AND';

$arr = M('studentinfo')->where($where)->select();

$count = count($arr); //求出有多少行;

$i = 2; //注意这是2;因为第一行我们已经设置了表头信息

for ($j = 0; $j < $count; $j++) {

$objPHPExcel->setActiveSheetIndex(0)

->setCellValue('A' . $i,$arr[$j]['ID']) //注意这里没有分号结束

->setCellValue('B' . $i,$arr[$j]['Studentname'])

->setCellValue('C' . $i,$arr[$j]['IDcard'])

->setCellValue('D' . $i,$arr[$j]['StudentID'])

->setCellValue('E' . $i,$arr[$j]['ClassID'])

->setCellValue('F' . $i,$arr[$j]['Sex'])

->setCellValue('G' . $i,$arr[$j]['Nation'])

->setCellValue('H' . $i,$arr[$j]['Birth'])

->setCellValue('I' . $i,$arr[$j]['Imagepath'])

->setCellValue('G' . $i,$arr[$j]['Huji'])

->setCellValue('K' . $i,$arr[$j]['Phone'])

->setCellValue('L' . $i,$arr[$j]['QQ'])

->setCellValue('M' . $i,$arr[$j]['Email'])

->setCellValue('N' . $i,$arr[$j]['Addressnow'])

->setCellValue('O' . $i,$arr[$j]['Local'])

->setCellValue('P' . $i,$arr[$j]['Position'])

->setCellValue('Q' . $i,$arr[$j]['Macrosoft'])

->setCellValue('R' . $i,$arr[$j]['CoachID'])

->setCellValue('S' . $i,$arr[$j]['CarID'])

->setCellValue('T' . $i,$arr[$j]['CartypeID'])

->setCellValue('U' . $i,$arr[$j]['Introducer'])

->setCellValue('V' . $i,$arr[$j]['Signdate'])

->setCellValue('W' . $i,$arr[$j]['Signpalce'])

->setCellValue('X' . $i,$arr[$j]['Signgtype'])

->setCellValue('Y' . $i,$arr[$j]['Lubiao'])

->setCellValue('Z' . $i,$arr[$j]['Lubiaodate'])

->setCellValue('AA' .$i, $arr[$j]['Zhika'])

->setCellValue('AB' .$i, $arr[$j]['Zhikadate'])

->setCellValue('AC' .$i, $arr[$j]['Subtabdate'])

->setCellValue('AD' .$i, $arr[$j]['Begindate'])

->setCellValue('AE' .$i, $arr[$j]['Bigtabdate'])

->setCellValue('AF' .$i, $arr[$j]['Weier'])

->setCellValue('AG' .$i, $arr[$j]['Lixiao'])

->setCellValue('AH' . $i,$arr[$j]['Fingerprint'])

->setCellValue('AI' .$i, $arr[$j]['Inform'])

->setCellValue('AJ' .$i, $arr[$j]['SchoolID'])

->setCellValue('AK' .$i, $arr[$j]['Setting'])

->setCellValue('AL' .$i, $arr[$j]['Remarks']);

$i++;

}

$objPHPExcel->getActiveSheet(0)->setTitle('studentinfo');

$objPHPExcel->setActiveSheetIndex(0);

header('Content-Type:application/vnd.ms-excel');

header('Content-Disposition:attachment;filename="studentinfo.xls"');

header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

$objWriter->save('php://output');

}

Html文件中