黄啊码PHP结合vue导出excel乱码

在这之前我们先回顾以前用php导出excel，我直接写成方法在这里：

1.  
   public static function phpExcelList($field, $list, $title='文件',$file_time){
2.  
   $spreadsheet = new Spreadsheet();
3.  
   $sheet = $spreadsheet->getActiveSheet();
4.  
   foreach ($list as $key => $value) {
5.  
   foreach ($field as $k => $v) {
6.  
   if ($key == 0) {
7.  
   $sheet->setCellValue($k . '1', $v[1]);
8.  
   }
9.  
   $i = $key 2; //表格是从2开始的
10.  
    $sheet->setCellValue($k . $i, $value[$v[0]]);
11.  
    }
12.  
    }
13.  
     
14.  
    ob_clean();
15.  
    header("Content-type:application/vnd.ms-excel;charset=UTF-8");
16.  
    header('Content-Type: application/vnd.ms-excel');
17.  
    header('Content-Disposition: attachment;filename="'.$title.'.csv"');
18.  
    header('Cache-Control: max-age=0');
19.  
    $writer = new Csv($spr

这篇好文章是转载于：学新通技术网