怎样一键导出excel

public function input() {

ob_end_clean(); //清除缓冲区，避免乱码

header("Content-Typ:text/html;charset=utf-8");

vendor('Excel.PHPExcel.Writer.IWriter');

vendor('Excel.PHPExcel.Writer.Excel5');

vendor('Excel.PHPExcel');

vendor('Excel.PHPExcel.IOFactory');

$objPHPExcel = new PHPExcel();

$objPHPExcel->getActiveSheet()->setCellValue('A1',"ID"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('B1',"Studentname"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('C1',"IDcard"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('D1',"StudentID"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('E1',"ClassID"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('F1',"Sex"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('G1',"Nation"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('H1',"Birth"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('I1',"Imagepath"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('J1',"Huji"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('K1',"Phone"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('L1',"QQ"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('M1',"Email"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('N1',"Addressnow"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('O1',"Local"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('P1',"Position"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('Q1',"Macrosoft"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('R1',"CoachID"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('S1',"CarID"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('T1',"CartypeID"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('U1',"Introducer"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('V1',"Signdate"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('W1',"Signplace"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('X1',"Signgtype"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('Y1',"Lubiao"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('Z1',"Lubiaodate"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('AA1',"Zhika"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('AB1',"Zhikadate"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('AC1',"Subtabdate"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('AD1',"Begindate"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('AE1',"Bigtabdate"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('AF1', "Weier");//设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('AG1',"Lixiao"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('AH1',"Fingerprint"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('AI1',"Inform"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('AJ1',"SchoolID"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('AK1',"Setting"); //设置列的值

$objPHPExcel->getActiveSheet()->setCellValue('AL1',"Remarks"); //设置列的值

$sql['Lixiao'] = '否';

$sql['SchoolID'] = "$_SESSION[SchoolID]";