Thinkphp使用PHPExcel导出Excel表格

来源：互联网发布：ubuntu如何下载anzqvim 编辑：程序博客网时间：2024/05/17 08:17
<?phpclass IndexAction extends Action {      public function imorder()      {               $M=M('模型');       $list = $M->select();       $num=count($list);        error_reporting(E_ALL);        ini_set('display_errors', TRUE);        ini_set('display_startup_errors', TRUE);        /*        *这里也可以导入文件        *        */        require_once './ThinkPHP/Extend/Library/ORG/Net/PHPExcel.class.php';        require_once './ThinkPHP/Extend/Library/ORG/Net/PHPExcel/IOFactory.php';        require_once './ThinkPHP/Extend/Library/ORG/Net/PHPExcel/Reader/Excel5.php';        $objPHPExcel = new PHPExcel();        $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")                                     ->setLastModifiedBy("Maarten Balliauw")                                     ->setTitle("Office 2007 XLSX Test Document")                                     ->setSubject("Office 2007 XLSX Test Document")                                     ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")                                     ->setKeywords("office 2007 openxml php")                                     ->setCategory("Test result file");           $objPHPExcel->setActiveSheetIndex(0)                    ->setCellValue('A1', '会员ID')                    ->setCellValue('B1', '会员ID')                    ->setCellValue('C1', '会员ID')                    ->setCellValue('D1', '会员ID')                    ->setCellValue('E1', '会员ID')                    ->setCellValue('F1', '会员ID')                    ->setCellValue('G1', '会员ID')                    ->setCellValue('H1', '会员ID')                    ->setCellValue('I1', '会员ID')                    ->setCellValue('J1', '会员ID')                    ->setCellValue('K1', '会员ID')                    ->setCellValue('L1', '会员ID')                    ->setCellValue('M1', '会员ID');              for ($i=0; $i < $num; $i++) {                  $n=$i+2;        $objPHPExcel->setActiveSheetIndex(0)                    ->setCellValue('A'.$n, $list[$i]['id'])                    ->setCellValue('B'.$n, $list[$i]['id'])                    ->setCellValue('C'.$n, $list[$i]['id'])                    ->setCellValue('D'.$n, '')                    ->setCellValue('E'.$n, $list[$i]['id'])                    ->setCellValue('F'.$n, $list[$i]['id'])                    ->setCellValue('G'.$n, $list[$i]['id'])                    ->setCellValue('H'.$n, $list[$i]['id'])                    ->setCellValue('I'.$n, $list[$i]['id'])                    ->setCellValue('J'.$n, $list[$i]['id'])                    ->setCellValue('K'.$n, $list[$i]['id'])                    ->setCellValue('L'.$n, '')                    ->setCellValue('M'.$n, '');                    }        $objPHPExcel->getActiveSheet()->setTitle('title');        $objPHPExcel->setActiveSheetIndex(0);        spl_autoload_register(array('Think','autoload'));         header('Content-Type: application/vnd.ms-excel');        header('Content-Disposition: attachment;filename="文件名.xls"');        header('Cache-Control: max-age=0');        $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');        $objWriter->save('php://output');        exit;      }}
0 0