require_once 'PHPExcel.php';
require_once 'phpExcel/Writer/Excel5.php';
require_once 'phpExcel/IOFactory.php';
require('mysql_con.php');//数据库连接配置文件
$objExcel = new PHPExcel();
$objExcel->setActiveSheetIndex(0);
$objActSheet = $objExcel->getActiveSheet();
$objActSheet->setTitle('你好');
$objActSheet->mergeCells('A1:E1');
$objActSheet->setCellValue ( 'A1', '员工信息' );
$objActSheet->getStyle ( 'A1' )->getFont ()->setSize ( 20 );
//# 设置单元格字体大小
$objActSheet->getStyle ( 'A1' )->getFont ()->setBold ( true );
//# 设置单元格字体类型
$objActSheet->getStyle ( 'A1' )->getAlignment ()->setHorizontal ( PHPExcel_Style_Alignment::HORIZONTAL_CENTER );
$objActSheet->getStyle ( 'A1' )->getAlignment ()->setVertical ( PHPExcel_Style_Alignment::VERTICAL_CENTER );
//设置表头
$k1="编号";
$k2="姓名";
$k3="住址";
$k4="电话";
$k5="生日";
$objExcel->getActiveSheet()->setCellValue('a2', "$k1");
$objExcel->getActiveSheet()->setCellValue('b2', "$k2");
$objExcel->getActiveSheet()->setCellValue('c2', "$k3");
$objExcel->getActiveSheet()->setCellValue('d2', "$k4");
$objExcel->getActiveSheet()->setCellValue('e2', "$k5");
//读取数据库内容
$sql = "select * from excel";
mysql_set_charset('utf8');//这里要注意,我搞不懂utf8跟utf-8的区别,因此出现乱码,浪费了好多时间
$result = mysql_query($sql);
$ii=3;
$sheet = $objExcel->getActiveSheet();
while($row = mysql_fetch_array($result, MYSQL_NUM)) {
$sheet->setCellValue('a'.$ii, "$row[0]");
$sheet->setCellValue('b'.$ii, "$row[1]");
$sheet->setCellValue('c'.$ii, "$row[2]");
$sheet->setCellValue('d'.$ii, "$row[3]");
$sheet->setCellValue('e'.$ii, "$row[4]");
$ii++;
}
$objExcel->setActiveSheetIndex(0);
$objWriter = PHPExcel_IOFactory::createWriter($objExcel, 'Excel5');
output_excel('你好.xls');
$objWriter->save('php://output');
function output_excel($file_name) {
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/octet-stream" );
header ( "Content-Type: application/download" );
Header('content-Type:application/vnd.ms-excel;charset=utf-8');
header ( "Content-Disposition: attachment;filename=$file_name" );
header ( "Content-Transfer-Encoding: binary " );
}
http://blog.sina.com.cn/s/blog_62cd41130100xrvf.html