phpexcel简单示例

最新推荐文章于 2024-06-29 09:51:21 发布

找到快乐的根源

最新推荐文章于 2024-06-29 09:51:21 发布

阅读量1.2k

点赞数

分类专栏： php+mysql系列文摘文章标签： header mysql 数据库 query include excel

本文链接：https://blog.csdn.net/k8080880/article/details/7692328

版权

php+mysql系列文摘专栏收录该内容

143 篇文章 1 订阅

订阅专栏

以下是phpexcel1.7.7的示例

<?php

include "tool/phpexcel/PHPExcel/Writer/IWriter.php";
include "tool/phpexcel/PHPExcel/Writer/Excel5.php";
require_once 'tool/phpexcel/PHPExcel.php';
include 'tool/phpexcel/PHPExcel/IOFactory.php';
//上面的四句代码是引入所需要的库，
$objPHPExcel = new PHPExcel();
$a1 = '分类ID'; //这是两个标头就是列名，最上面的那个
$a2 = '分类名称';
$a1=iconv("gb2312","utf-8",$a1); //如果是乱码的话，则需要转换下
$a2=iconv("gb2312","utf-8",$a2);
$objPHPExcel->getActiveSheet()->setCellValue('A1', "$a1");//设置列的值
$objPHPExcel->getActiveSheet()->setCellValue('B1', "$a2");

$con = mysql_connect('localhost','root','123456') or die('数据库连接失败');
mysql_select_db('bozong_dijie');
mysql_query('set NAMES gbk');
$result = mysql_query('select * from bz_plan');//连接数据库的就不用多解释了
$i = 2; //自增变量，用来控制行，因为标头占的第一行，所以这里从第二行开始
while($arr = mysql_fetch_array($result)){
$id = $arr['plan_id'];
$cname = $arr['lcard'];
$id=iconv("gb2312","utf-8",$id);
$cname = iconv("gb2312","utf-8",$cname);
$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, "$id");
$objPHPExcel->getActiveSheet()->setCellValue('B'.$i, "$cname");//这些跟上面的一样，开始一行一行的赋值。
$i++;

}
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(30);//设置宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(12);

//直接在浏览器输出
$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
header("Pragma: public");
header("Expires: 0");
header("Cache-Control:must-revalidate,post-check=0,pre-check=0");
header("Content-Type:application/force-download");
header("Content-Type:application/vnd.ms-execl");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");
header('Content-Disposition:attachment;filename="resume.xls" ');
header("Content-Transfer-Encoding:binary");
$objWriter->save("php://output");