首页新闻找找看学习计划

php excel导出完全没反应,之前的一模一样的代码都可以导出,求大神指教(附代码)

0
悬赏园豆:20 [待解决问题]

namespace Home\Controller;

use Think\Controller;

class PointController extends CommonController {

public function daochu(){

$info = M('integral_filllogs as i')->join('jn_member as m on i.mid = m.id')
->join('jn_card as c on c.id = m.card_id')
->field('i.id,i.integral,m.member_name,m.phone,m.member_card_id,m.add_time,c.card_name')
->where($where)->find();

import("Org.Util.PHPExcel");
error_reporting(E_ALL);
date_default_timezone_set('Europe/London');
$objPHPExcel = new \PHPExcel();
import("Org.Util.PHPExcel.Reader.Excel5");
$objPHPExcel->getProperties()->setCreator("Admin")//创建人
->setLastModifiedBy("A")//最后修改人
->setTitle("积分EXCEL导出")//标题
->setSubject("积分EXCEL导出")//题目
->setDescription("产品")//描述
->setKeywords("excel")//关键字
->setCategory("result file"); //种类

$objPHPExcel->setActiveSheetIndex(0)
->setCellValueExplicit('A1', "序号")
->setCellValueExplicit('B1', "姓名")
->setCellValueExplicit('C1', "手机")
->setCellValueExplicit('D1', "卡号")
->setCellValueExplicit('E1', "卡类型")
->setCellValueExplicit('F1', "积分")
->setCellValueExplicit('G1', "办卡日期")
->setCellValueExplicit('H1', "门店");
// ->setCellValueExplicit('I1', "门店");
$objActSheet = $objPHPExcel->getActiveSheet();
foreach ($info as $k => $v) {
$k = $k + 1;
$num = $k + 1;
$objActSheet
->setCellValueExplicit('A' . $num, $v['id'], \PHPExcel_Cell_DataType::TYPE_STRING)
->setCellValueExplicit('B' . $num, $v['member_name'], \PHPExcel_Cell_DataType::TYPE_STRING)
->setCellValueExplicit('C' . $num, $v['phone'], \PHPExcel_Cell_DataType::TYPE_STRING)
->setCellValueExplicit('D' . $num, $v['member_card_id'], \PHPExcel_Cell_DataType::TYPE_STRING)
->setCellValueExplicit('E' . $num, ($v['member_name']), \PHPExcel_Cell_DataType::TYPE_STRING)
->setCellValueExplicit('F'.$num, $v['integral'],\PHPExcel_Cell_DataType::TYPE_STRING)
->setCellValueExplicit('G' . $num, $v['add_time'], \PHPExcel_Cell_DataType::TYPE_STRING)
->setCellValueExplicit('H'.$num,$shopname['shop_name'], \PHPExcel_Cell_DataType::TYPE_STRING);


$objActSheet->getColumnDimension('B')->setWidth(20);
$objActSheet->getColumnDimension('C')->setWidth(20);
$objActSheet->getColumnDimension('D')->setWidth(20);
$objActSheet->getColumnDimension('E')->setWidth(20);
$objActSheet->getColumnDimension('F')->setWidth(20);
$objActSheet->getColumnDimension('G')->setWidth(20);
$objActSheet->getColumnDimension('H')->setWidth(20);
$objActSheet->getColumnDimension('I')->setWidth(20);
$objActSheet->getColumnDimension('J')->setWidth(20);
$objActSheet->getColumnDimension('K')->setWidth(20);
$objActSheet->getColumnDimension('L')->setWidth(20);
$objActSheet->getColumnDimension('M')->setWidth(20);
$objActSheet->getColumnDimension('N')->setWidth(20);
}
$objPHPExcel->setActiveSheetIndex(0);
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="' . time() . '.xls"');
header('Cache-Control: max-age=0');
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;

}

渔夫三拳的主页 渔夫三拳 | 初学一级 | 园豆:184
提问于:2017-05-25 17:34
< >
分享
所有回答(2)
0

//...测试导出图片
public function testDown(){
$M=M('entry');
$data=$M->where(1)->select();

// 导出Exl
import("Org.Util.PHPExcel");
import("Org.Util.PHPExcel.Worksheet.Drawing");
import("Org.Util.PHPExcel.Writer.Excel2007");
$objPHPExcel = new \PHPExcel();
$objWriter = new \PHPExcel_Writer_Excel2007($objPHPExcel);
$objActSheet = $objPHPExcel->getActiveSheet();

// 水平居中(位置很重要,建议在最初始位置)
$objPHPExcel->setActiveSheetIndex(0)->getStyle('A')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->getStyle('B1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->getStyle('C')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->getStyle('D')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->getStyle('E')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->getStyle('F')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

$objActSheet->setCellValue('A1', '姓名');
$objActSheet->setCellValue('B1', '手机号');
$objActSheet->setCellValue('C1', '头像');
$objActSheet->setCellValue('D1', '学校');
$objActSheet->setCellValue('E1', '特长');
$objActSheet->setCellValue('F1', '喜欢明星');
// 设置个表格宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(16);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(16);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(40);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(40);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(40);

// 垂直居中
$objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('D')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('F')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);

foreach($data as $k=>$v){
$k +=2;
$objActSheet->setCellValue('A'.$k, $v['name']);
$objActSheet->setCellValue('B'.$k, $v['mobile']);
// 图片生成
$objDrawing[$k] = new \PHPExcel_Worksheet_Drawing();
$objDrawing[$k]->setPath('./Uploads/Images/2016-05-16/57397d14153f5.jpg');
// 设置宽度高度
$objDrawing[$k]->setHeight(40); //照片高度
$objDrawing[$k]->setWidth(80); //照片宽度
/*设置图片要插入的单元格*/
$objDrawing[$k]->setCoordinates('C'.$k);
// 图片偏移距离
$objDrawing[$k]->setOffsetX(12);
$objDrawing[$k]->setOffsetY(12);
$objDrawing[$k]->setWorksheet($objPHPExcel->getActiveSheet());

// 表格内容
$objActSheet->setCellValue('D'.$k, $v['school']);
$objActSheet->setCellValue('E'.$k, $v['specialty']);
$objActSheet->setCellValue('F'.$k, $v['love_star']);

// 表格高度
$objActSheet->getRowDimension($k)->setRowHeight(80);

}
$fileName = '报名表';
$date = date("Y-m-d",time());
$fileName .= "_{$date}.xls";
$fileName = iconv("utf-8", "gb2312", $fileName);
$objPHPExcel->setActiveSheetIndex(0);
header('Content-Type: application/vnd.ms-excel');
header("Content-Disposition: attachment;filename=\"$fileName\"");
header('Cache-Control: max-age=0');
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output'); 
}

我的代码,既然之前一模一样的代码可以导出,那说明代码是没问题的,是不是导出数据太大,另外,没反应是什么表现,报错没有

YQZC | 园豆:2354 (老鸟四级) | 2017-05-25 18:16

 $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

支持(0) 反对(0) 渔夫三拳 | 园豆:184 (初学一级) | 2017-05-25 18:21

说的是这行有错误

支持(0) 反对(0) 渔夫三拳 | 园豆:184 (初学一级) | 2017-05-25 18:21
0

检查一下phpexcel文件是否存在?
或者加一个
require_once DIR . '/../' . 'simplewind\vendor\PHPExcel\PHPExcel.php';
实际地址填你phpexcel插件的地址。

我其实是因为另一个问题进来的。。。。点击导出后没反应,但是又不报错,但是另一个按钮却可以导出。

后来发现原来是没有return结果。
比如:
$result = ExcelWrite::excelExport('test',$init,$result,true);
return $result;

写成了
ExcelWrite::excelExport('test',$init,$result,true);
return $result;

少写了一个等于...然后那个$result之前有赋值其他值了,所以不会报错,只是提示下载

捂脸,如果有人发生类似错误的话,请不要重蹈我的覆辙。

give-he1s | 园豆:202 (菜鸟二级) | 2019-09-15 10:39
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册