开发环境:linux
框架:thinkphp3.2
在之前遇到一个场景,是把excel表格中的数据解析出来,接触到了phpexcel,
先给个链接 http://blog.csdn.net/fei003/article/details/72897685
这个需要把商品信息导出表格,并且表格中还包含图片,所以这次又查了下,写下这次使用
PHPexcel的经历以及遇到的坑
首先把完整版代码贴出来,类库还是放在了vendor中
public function getExcel(){
$ids = I('post.ids');
$goods = $this->goods_model->select(); //查找自己所需要的数据
// 实例化excel
// 引入文件
Vendor("PHPExcel.PHPExcel");
vendor('PHPExcel/PHPExcel/Writer/Excel2007.php');
$phpExcel = new \PHPExcel();
$objDrawing = new \PHPExcel_Worksheet_Drawing();
$phpExcel->getProperties()->setTitle("商品价格表");
$phpExcel->getProperties()->setSubject("趣买呗商品价格表");
// 对单元格设置居中效果
$phpExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$phpExcel->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$phpExcel->getActiveSheet()->getStyle('C')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$phpExcel->getActiveSheet()->getStyle('D')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$phpExcel->getActiveSheet()->getStyle('E')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$phpExcel->getActiveSheet()->getStyle('