One-click excel export and excel Export

One-click excel export and excel Export

How to export an excel file with one click

Public function input (){

Ob_end_clean (); // clear the buffer to avoid garbled characters.

Header ("Content-Typ: text/html; charset = UTF-8 ");

Vendor ('excel. PHPExcel. Writer. iwrite ');

Vendor ('excel. PHPExcel. Writer. excel5 ');

Vendor ('excel. PHPExcel ');

Vendor ('excel. PHPExcel. IOFactory ');

$ ObjPHPExcel = new PHPExcel ();

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('a1', "ID"); // set the column Value

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('b1 ', "Studentname"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('c1', "IDcard"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('d1 ', "StudentID"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('e1 ', "ClassID"); // set the column Value

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('f1 ', "Sex"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('g1', "Nation"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('h1 ', "Birth"); // set the column Value

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('i1', "Imagepath"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('j1', "Huji"); // set the column Value

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('k1 ', "Phone"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('l1', "QQ"); // set the column Value

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('m1 ', "Email"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('n1 ', "Addressnow"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('o1 ', "Local"); // set the column Value

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('p1', "Position"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('q1', "Macrosoft"); // set the column Value

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('r1', "CoachID"); // set the column Value

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('s1', "CarID"); // set the column Value

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('t1', "CartypeID"); // set the column Value

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('u1', "Introducer"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('v1 ', "Signdate"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('w1', "Signplace"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('x1 ', "Signgtype"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('y1 ', "Lubiao"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('z1 ', "Lubiaodate"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('aa1', "Zhika"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('ab1', "Zhikadate"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('ac1', "Subtabdate"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('ad1', "Begindate"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('ae1 ', "Bigtabdate"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('af1', "Weier"); // set the column Value

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('ag1', "Lixiao"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('ah1', "Fingerprint"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('ai1', "Inform"); // set the column Value

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('aj1', "SchoolID"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('ak1', "Setting"); // you can specify the column value.

$ ObjPHPExcel-> getActiveSheet ()-> setCellValue ('al1', "Remarks"); // set the column Value

$ SQL ['lixiao'] = 'no ';

$ SQL ['schoolid'] = "$ _ SESSION [SchoolID]";

$ Studentname = I ('studentname ');

$ 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); // you can find the number of rows;

$ I = 2; // note that this is 2, because the header information has been set in the first line.

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

$ ObjPHPExcel-> setActiveSheetIndex (0)

-> SetCellValue ('A'. $ I, $ arr [$ j] ['id']) // note that there is no semicolon ending here

-> 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] ['address'])

-> 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] ['troducer '])

-> SetCellValue ('V'. $ I, $ arr [$ j] ['signature'])

-> SetCellValue ('W'. $ I, $ arr [$ j] ['signature'])

-> 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] ['remark']);

$ 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 file

<Div style = "float: right"> <formaction = "{: U ('input ')} "> <input type =" submit "value =" one-click EXCEL export "> </form> </div>