个人总结thinkphp中导出数据到excel表格

先在网上下载一个classes文件  里面包含 PHPExcel文件夹PHPExcel.php  

将classes放在library/vendor/下面

然后在写一个控制器 里面修改一下就可以了

<?php

namespace Home\Controller;

use Think\Controller;

class ExeclController extends Controller{

function pushExcel(){

  $user=D("Orders");

  $list=$user->select();

  Vendor("Classes.PHPExcel");

  Vendor("Classes.PHPExcel.IOFactory");

  Vendor("Classes.PHPExcel.Reader.Excel5");

  //创建处理对象实例

  $objPhpExcel=new \PHPExcel();

  $objPhpExcel->getActiveSheet()->getDefaultColumnDimension()->setAutoSize(true);//设置单元格宽度

  //设置表格的宽度  手动

  $objPhpExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20);

  $objPhpExcel->getActiveSheet()->getColumnDimension('H')->setWidth(15);

  $objPhpExcel->getActiveSheet()->getColumnDimension('I')->setWidth(15);

  $objPhpExcel->getActiveSheet()->getColumnDimension('J')->setWidth(20);

  //设置标题

  $rowVal = array(0=>'编号',1=>'姓名', 2=>'性别', 3=>'年龄', 4=>'所属部门',

  5=>'职位', 6=>'邮箱', 7=>'办公电话', 8=>'移动电话',

  9=>'住址');

  foreach ($rowVal as $k=>$r){

   $objPhpExcel->getActiveSheet()->getStyleByColumnAndRow($k,1)

   ->getFont()->setBold(true);//字体加粗

   $objPhpExcel->getActiveSheet()->getStyleByColumnAndRow($k,1)->

   getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//文字居中

   $objPhpExcel->getActiveSheet()->setCellValueByColumnAndRow($k,1,$r);

  }

  //设置当前的sheet索引 用于后续内容操作

  $objPhpExcel->setActiveSheetIndex(0);

  $objActSheet=$objPhpExcel->getActiveSheet();

  //设置当前活动的sheet的名称

  $title="公司通讯录";

  $objActSheet->setTitle($title);

  //设置单元格内容

  foreach($list as $k => $v)

  {

   $num=$k+2;

   $objPhpExcel->setActiveSheetIndex(0)

   //Excel的第A列，uid是你查出数组的键值，下面以此类推

   ->setCellValue('A'.$num, $v['orderId'])

   ->setCellValue('B'.$num, $v['numorder'])

   ->setCellValue('C'.$num, $v['userId'])

   ->setCellValue('D'.$num, $v['prodId'])

   ->setCellValue('E'.$num, $v['receiver'])

   ->setCellValue('F'.$num, $v['tel'])

   ->setCellValue('G'.$num, $v['orderTime'])

   ->setCellValue('H'.$num, $v['orderState'])

   ->setCellValue('I'.$num, $v['email'])

   ->setCellValue('J'.$num, $v['addressbie']);

  }

  $name=date('Y-m-d');//设置文件名

  header("Content-Type: application/force-download");

  header("Content-Type: application/octet-stream");

  header("Content-Type: application/download");

  header("Content-Transfer-Encoding:utf-8");

  header("Pragma: no-cache");

  header('Content-Type: application/vnd.ms-excel');

  header('Content-Disposition: attachment;filename="'.$title.'_'.urlencode($name).'.xls"');

  header('Cache-Control: max-age=0');

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

  $objWriter->save('php://output');

}

}