PHP直接导出excel

逃离我推掉我的手 2022-08-07 12:47 1阅读 0赞

直接上代码：

public function commentsDown(){
               header('Content-Type: text/html; charset=utf-8');
               header('Content-type:application/vnd.ms-execl');
               header('Content-Disposition:filename=评论记录.xls');
               $ids = $_POST['ids'];
               $list = Model_Usercomment_Usercomment::$model->findInid($ids);
               for ($i=0;$i<count($list);$i++){
                    
                   $res = Model_Product_Product::$model->findProductByname($list[$i]['goodsid']);
                   $list[$i]['goodsname'] = $res[0]['goodsname'];
               }
               
               //1.设置表头
               $title = array("评论人姓名","评论人电话","评论人住址","评论人单位","评论人邮箱","评论人研究方向","评论商品名称","评论内容","评论时间");
               for ($i=0;$i<count($title);$i++){
               
               
                   if($i < (count($title) -1)){
               
                       echo iconv('utf-8', 'gbk', $title[$i]). '	';
                   }
               
                   else{
               
                       echo iconv('utf-8', 'gbk', $title[$i]) . '
    ';
                   }
               
               }
               for ($j=0;$j<count($list);$j++){
               
                   $k=0;
               
                   if($k<count($title) -1){
               
                       echo iconv('utf-8', 'gbk', $list[$j]['name']). '	';
                       echo '\''.$list[$j]['phone']. '	  ';
                       echo iconv('utf-8', 'gbk', $list[$j]['address']). '	';
                       echo iconv('utf-8', 'gbk', $list[$j]['company']). '	 ';
                       echo iconv('utf-8', 'gbk', $list[$j]['email']). '	';
                       echo iconv('utf-8', 'gbk', $list[$j]['search']). '	    ';
                       echo iconv('utf-8', 'gbk', $list[$j]['goodsname']). '	     ';
                       echo iconv('utf-8', 'gbk', $list[$j]['content']). '	     ';
                       echo iconv('utf-8', 'gbk', date('Y-m-d',$list[$j]['createtime'])). '	     ';
                       echo "\t\n";//换行
                   }
                   else{
               
                       echo "\t\n";<span style="font-family: Arial, Helvetica, sans-serif;">//换行</span>
                       echo iconv('utf-8', 'gbk', $list[$j]['name']). '     ';
                       echo '\''.$list[$j]['phone']. '	  ';
                       echo iconv('utf-8', 'gbk', $list[$j]['address']). '	';
                       echo iconv('utf-8', 'gbk', $list[$j]['company']). '	 ';
                       echo iconv('utf-8', 'gbk', $list[$j]['email']). '	';
                       echo iconv('utf-8', 'gbk', $list[$j]['search']). '	    ';
                       echo iconv('utf-8', 'gbk', $list[$j]['goodsname']) . '	    ';
                       echo iconv('utf-8', 'gbk', $list[$j]['content']). '	     ';
                       echo iconv('utf-8', 'gbk', date('Y-m-d',$list[$j]['createtime'])). '	     ';
                   }
                   $k++;
               }
               
           }