在这之前我们先回顾以前用PHP导出excel,我直接写成方法在这里: public static function phpExcelList($field, $list, $title='文件',$file_time){ $s
在这之前我们先回顾以前用PHP导出excel,我直接写成方法在这里:
public static function phpExcelList($field, $list, $title='文件',$file_time){ $spreadsheet = new Spreadsheet(); $sheet = $spreadsheet->getActiveSheet(); foreach ($list as $key => $value) { foreach ($field as $k => $v) { if ($key == 0) { $sheet->setCellValue($k . '1', $v[1]); } $i = $key + 2; //表格是从2开始的 $sheet->setCellValue($k . $i, $value[$v[0]]); } } ob_clean(); header("Content-type:application/vnd.ms-excel;charset=UTF-8"); header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="'.$title.'.csv"'); header('Cache-Control: max-age=0'); $writer = new Csv($spr
来源地址:https://blog.csdn.net/TiaoZhanJi_Xian/article/details/128850738
--结束END--
本文标题: 【黄啊码】PHP结合vue导出excel乱码
本文链接: https://www.lsjlt.com/news/410799.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
2024-02-29
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0