帝国使用phpexcel导出数据库数据到excel

include ‘…/extend/PHPExcel-1.8/Classes/PHPExcel.php’;
include ‘…/extend/PHPExcel-1.8/Classes/PHPExcel/Writer/Excel2007.php’;
require("…/class/connect.php");
require("…/class/db_sql.php");
$link=db_connect();
$empire=new mysqlquery();
$sql=‘select * from phome_enewsfeedback where bid=1 order by id desc’;
$result=$empire->query($sql);

//数据
$data=[];
$key=0;while($r=$empire->fetch($result)) {
$data[$key][‘id’]=$r[‘id’];
$data[$key][‘title’]=$r[‘title’];
$data[$key][‘sex’]=$r[‘sex’];
$data[$key][‘idnum’]=$r[‘idnum’];
$data[$key][‘mycall’]=$r[‘mycall’];
$data[$key][‘email’]=$r[‘email’];
$data[$key][‘company’]=$r[‘company’];
$data[$key][‘address’]=$r[‘address’];
$data[$key][‘name’]=$r[‘name’];
$data[$key][‘leixing’]=$r[‘leixing’];
$data[$key][‘cptime’]=$r[‘cptime’];
$data[$key][‘shichang’]=$r[‘shichang’];
$data[$key][‘sbtime’]=$r[‘sbtime’];
$data[$key][‘pingtai’]=$r[‘pingtai’];
$data[$key][‘daoyan’]=$r[‘daoyan’];
$data[$key][‘bianju’]=$r[‘bianju’];
$data[$key][‘zhipian’]=$r[‘zhipian’];
$data[$key][‘zhujue’]=$r[‘zhujue’];
$data[$key][‘hjqingkuang’]=$r[‘hjqingkuang’];
$data[$key][‘yunpan’]=$r[‘yunpan’];
$data[$key][‘yunpanm’]=$r[‘yunpanm’];
$data[$key][‘saytext’]=$r[‘saytext’];
KaTeX parse error: Expected 'EOF', got '}' at position 8: key++; }̲ // //print_r(data);

//设置表头：
$headArr = [‘编号’,‘申报人’,‘性别’,‘证件号码’,‘电话’,‘邮箱’,‘申报单位’,‘通讯地址’,‘作品名称’,‘作品类型’,‘成片时间’,‘时长’,‘首播时间’,‘播出平台’,‘导演’,‘编剧’,‘制片人’,‘主演’,‘获奖情况’,‘云盘链接’,‘云盘密码’,‘作品简介’];

//excel表名
$name=‘报名信息’;
$filename=‘报名信息.xlsx’;

//$headArr=[‘AAA’,‘BBB’,‘CCCC’,‘DDD’];
// $data=[
// 0=>[‘aaa’,‘bb’,‘cc’,‘dd’],
// 1=>[‘aaa1’,‘bb1’,‘cc1’,‘dd1’],
// 2=>[‘aaa2’,‘bb2’,‘cc2’,‘dd2’],
// 3=>[‘aaa3’,‘bb3’,‘cc3’,‘dd3’],
// ];

$count=count($data);
set_time_limit(0);
ini_set(‘memory_limit’,‘10240M’);
// 数据量大时，导出失败， 压缩一下，减少内存使用
include ‘…/extend/PHPExcel-1.8/Classes/PHPExcel/Settings.php’;
if (!\PHPExcel_Settings::setCacheStorageMethod(‘MemoryGZip’)) {
die(‘MemoryGZip’ . " 缓存方法不可用" );
}

$callStartTime = microtime ( true);
$objPHPExcel=new PHPExcel();
$objPHPExcel->getProperties()->setCreator(‘test’)
->setLastModifiedBy(‘test’)
->setTitle(‘test’)
->setSubject(‘test’)->setDescription(‘test.’)->setKeywords(‘test’)->setCategory(‘test’);

//print_r($headArr);

//设置表头
$key=ord("A");foreach($headArr as $v)
{
$colum=chr($key);
$v = iconv(“gb2312”, “utf-8”, $v);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colum . ‘1’, $v);
$key += 1;
}

//设置数据
$column = 2;
$objActSheet = $objPHPExcel->getActiveSheet();foreach($data as $key => $rows)
{
//行写入
$span=ord("A");foreach($rows as $keyName => $value)
{
// 列写入
$j=chr($span);
$objActSheet->setCellValue($j . KaTeX parse error: Double superscript at position 11: column, ' '̲.value);
$span++;
}
$column++;
}

//设置宽度
//$objPHPExcel->getActiveSheet()->getColumnDimension(‘D’)->setWidth(‘300’);
$objPHPExcel->getActiveSheet()->getColumnDimension(‘e’)->setWidth(‘40’);

$objPHPExcel->getActiveSheet()->setTitle($name);
$objPHPExcel->setActiveSheetIndex(0);
$callEndTime=microtime( true);
$callTime= $callEndTime - $callStartTime;

// echo $callTime;

ob_end_clean();
ob_start();
header('Content-type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename="' . $filename . '"');
header('Cache-Control: max-age=0');
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: cache, must-revalidate');
header('Pragma: public');
$objWriter=\PHPExcel_IOFactory::createWriter($objPHPExcel,  'Excel2007');
$objWriter->save('php://output');

db_close(); //关闭MYSQL链接
$empire=null; //注消操作类变量