PHPÓ¦ÓÃPHPExcelÊä³öÊý¾Ýµ½Excel
PHP ÀûÓÃPHPExcel¸÷´¦Êý¾Ýµ½Excel£»»¹ÓÐÊä³öÊý¾ÝÂÒÂëµÄ½â¾ö·½°¸¡£
Ïà¹ØÒý¼ö£º¡¶PHPExcel-1.8Àà¿â£¨ÖµµÃÕä²Ø£¡£©¡·
Ö±½ÓÌù´úÂë°É£¡
¡ñ PHP°æ±¾5.6.38
¡ñ mysql°æ±¾5.0
//Á¬½ÓÊý¾Ý¿â $mysql_server_name = "*.*.*.*"; $mysql_username="user"; $mysql_password="dbpasswd"; $mysql_database="test"; $conn = mysqli_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database); // ¼ì²âÁ¬½Ó if ($conn->connect_error) { die("Á¬½Óʧ°Ü: " . $conn->connect_error); } //É趨×Ö·û¼¯£¬¼ÙÈç²»É趨µÄ»°ÖÐÎÄ´ó¸Å»áÂÒÂë $conn->query("set names utf8"); //²éѯÊý¾Ý $sql = "SELECT * FROM testdata WHERE inserttime > '2019-09-13' AND inserttime <'2019-0916'"; $result = $conn->query($sql); //±éÀú½«Êý¾Ý·ÅÈëÊý×éÖÐ $data =array(); while ($row = $result->fetch_assoc()) { $data[] = $row; } //½«²éѯ³öÀ´µÄÊý¾Ýµ¼ÈëExcelÖÐ require_once('./PHPExcel/PHPExcel.php'); // ´´Á¢ExcelÎļþ¶ÔÏó $objPHPExcel = new PHPExcel(); // É趨ÎĵµÐÅÏ¢£¬Õâ¸öÎĵµÐÅÏ¢windowsϵͳ¿ÉÒÔÓÒ¼üÎļþÊôÐԲ鿴 $objPHPExcel->getProperties()->setCreator("wnn") ->setLastModifiedBy("wnn") ->setTitle("Ô´´ÎÄÕÂÁ´½Ó"); $objPHPExcel->setActiveSheetIndex(0) ->setCellValue('A1','ÎÄÕÂID') ->setCellValue('B1','±êÌâ') ->setCellValue('C1','Á´½Ó') ->setCellValue('D1','×÷Õß') ->setCellValue('E1','¹«²¼Ê±¼ä'); //É趨excel±íµ¥°´ÕÕÄÚÈÝ´óСת±ä $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true); $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true); //$i=1ÊDZêÌâÐÐ $i=2; foreach ($data as $k=>$v){ $objPHPExcel->setActiveSheetIndex(0) ->setCellValue('A'.$i,$v['id']) ->setCellValue('B'.$i,$v['title']) ->setCellValue('C'.$i,$v['arcurl']) ->setCellValue('D'.$i,$v['writer']) ->setCellValue('E'.$i,$v['senddate']); ¡¡¡¡¡¡//¸øCÁеÄÎÄ×Ö¼ÓÉÏÁ´½Ó $objPHPExcel->getActiveSheet()->getCell('C'.$i)->getHyperlink()->setUrl($v['arcurl']); $i++; } //¸øCÁеij¬Á´½Ó×ÖÌåÉ«²Ê±ä³ÉÀ¶É« $length = count($data)+1; $objPHPExcel->getActiveSheet()->getStyle( 'C2:C'.$length)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_BLUE); //ÎļþÃû³Æ $filename=urlencode('Ô´´×÷Æ·').'_'.date('YmdHis'); //Éú³ÉxlsÎļþ ob_end_clean();//Çå³ý»º³åÇø,ÐÒÃâÂÒÂë header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="'.$filename.'.xls"'); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output');
¼ÙÈçÊä³öÀ´µÄExcelÎÄ×Ö¶¼ÊÇÂÒÂëµÄ»°£¬±ØȻҪÔÚheader()Ç°Ãæ¼ÓÉÏob_end_clean()£¡
¸ü¶àphpÏà¹Ø֪ʶ£¬Çë°Ý·Ãphp½Ì³Ì£¡
ÒÔÉϾÍÊÇPHPÀûÓÃPHPExcelÊä³öÊý¾Ýµ½ExcelµÄ¾ßÌåÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢°Ù·Ö°ÙÔ´ÂëÍøÆäËüÏà¹ØÎÄÕ£¡
¸ÐлÄúµÄÖ§³Ö£¬ÎÒ»á¼ÌÐøŬÁ¦µÄ!
´ò¿ªÖ§¸¶±¦É¨Ò»É¨£¬¼´¿É½øÐÐɨÂë´òÉÍŶ
°Ù·Ö°ÙÔ´ÂëÍø ½¨Òé´òÉÍ1¡«10Ôª£¬ÍÁºÀËæÒ⣬¸ÐлÄúµÄÔĶÁ£¡