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是题目行 $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列的超链接字体颜色变为蓝色 $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的具体内容,更多请存眷资源魔其它相干文章!
标签: php php开发教程 php开发资料 php开发自学 PHPExcel
版权声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。
抱歉,评论功能暂时关闭!