php如何在不用插件和开启配置的情况下导出Excel?(代码)
程序员文章站
2022-04-02 18:37:15
...
本篇文章给大家带来的内容是关于php如何在不用插件和开启配置的情况下导出Excel?(代码),有一定的参考价值,有需要的朋友可以参考一下,希望对你有所帮助。
function export_csv($filename, $data) { header("Content-type:text/csv"); header("Content-Disposition:attachment;filename=" . $filename); header('Cache-Control:must-revalidate,post-check=0,pre-check=0'); header('Expires:0'); header('Pragma:public'); echo $data; } //csv导出 /* * 导出Excel */ public function output() { $org = Db::name('organization')->select(); $list['one'] = Db::name('transfer_flow')->order('add_time desc')->select(); foreach ($list['one'] as $k => $v) { foreach ($org as $kk => $vv) { if ($v['org_id'] == $vv['id']) { $list['one'][$k]['org_id'] = $vv['name']; } } if ($v['pay_type'] === 'WX') { $list['one'][$k]['pay_type'] = '微信'; } else if ($v['pay_type'] === 'A') { $list['one'][$k]['pay_type'] = '支付宝'; } else { $list['one'][$k]['pay_type'] = '银行转账'; } } $str = "订单号,加盟商,金额,支付方式,添加时间\n"; $str = iconv('utf-8','gb2312',$str); foreach($list['one'] as $k => $v){ $order_no = iconv('utf-8','gb2312',$v['order_no']); $org_id = iconv('utf-8','gb2312',$v['org_id']); $pay_type = iconv('utf-8','gb2312',$v['pay_type']); $str .= $order_no . ',' . $org_id . ',' . $v['money'] . ',' . $pay_type . ',' . $v['add_time'] . "\n"; } $filename = '财务管理_'.date('Ymd').'.csv'; //设置文件名 $this->export_csv($filename,$str); //导出 } 导出csv
相关推荐:
以上就是php如何在不用插件和开启配置的情况下导出Excel?(代码)的详细内容,更多请关注其它相关文章!