<?php
header("content-type:text/html;charset=utf8");
$conn=mysql_connect("localhost","root","root") or die("数据库服务器连接错误".mysql_error());
mysql_select_db("ytwo",$conn) or die("数据库访问错误".mysql_error());
mysql_query("set character set utf8");
mysql_query("set names utf8");
<?php
include("mysql.php");
// 引入phpexcel核心类文件
require_once './PHPExcel-1.8/Classes/PHPExcel.php';
// 实例化excel类
$objPHPExcel = new PHPExcel();
// 操作第一个工作表
$objPHPExcel->setActiveSheetIndex(0);
// 设置sheet名
$objPHPExcel->getActiveSheet()->setTitle('user');
// 设置表格宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15);
// 列名表头文字加粗
$objPHPExcel->getActiveSheet()->getStyle('A1:C1')->getFont()->setBold(true);
// 列表头文字居中
$objPHPExcel->getActiveSheet()->getStyle('A1:C1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
// 列名赋值
$objPHPExcel->getActiveSheet()->setCellValue('A1', '名字');
$objPHPExcel->getActiveSheet()->setCellValue('B1', '年龄');
$objPHPExcel->getActiveSheet()->setCellValue('C1', '性别');
// 数据起始行
$row_num = 2;
$sql = "select * from user";
if(!mysql_query($sql,$conn)){
echo 'excel err';
}
$res = mysql_query($sql,$conn);
while($row = mysql_fetch_assoc($res)) {
$result[] = $row;
}
// var_dump($result);die;
// 向每行单元格插入数据
foreach($result as $value)
{
// 设置所有垂直居中
$objPHPExcel->getActiveSheet()->getStyle('A' . $row_num . ':' . 'C' . $row_num)->getAlignment()
->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
// 设置单元格数值
$objPHPExcel->getActiveSheet()->setCellValue('A' . $row_num, $value['name']);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $row_num, $value['age']);
$objPHPExcel->getActiveSheet()->setCellValue('C' . $row_num, $value['sex']);
$row_num++;
}
$outputFileName = 'user_' . time() . '.csv';
$xlsWriter = new \PHPExcel_Writer_Excel5($objPHPExcel);
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header('Content-Disposition:inline;filename="' . $outputFileName . '"');
header("Content-Transfer-Encoding: binary");
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Pragma: no-cache");
$xlsWriter->save("php://output");
echo file_get_contents($outputFileName);
复制就能用。
转载请注明原文地址: https://ju.6miu.com/read-668938.html
