PHP直接导出excel

来源：互联网发布：淘宝联盟提现时间限制编辑：程序博客网时间：2024/04/28 08:14

直接上代码：

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++;           }                  }

0 0