Php实现csv写入下载

$title1 = '年月\明细,月贷款额,月利润额,月理论回款额,月实际回款额,月未还款额,月客户总量'."\n";
        header("Cache-Control: public");
        header("Pragma: public");
        header("Content-type:application/vnd.ms-excel");
        $filename = $title;
        header("Content-Disposition:attachment;filename=$filename.csv");
        header('Content-Type:APPLICATION/OCTET-STREAM');
        ob_start();

                //linux系统编码转换
        //$header_str = mb_convert_encoding ($title1,"gbk","utf-8");

        //$csv_line_data = mb_convert_encoding ($csv_line_data,"gbk","utf-8");

//windwos编码转换

                        //由于gb2312支持的字比较少,导致有些无法识别的字直接去掉了,换成支持更多字的gbk

                        //$data = iconv("utf-8","gb2312//IGNORE",$data);

                        $header_str = iconv("utf-8","gbk//IGNORE",$title1);

$csv_line_data = iconv("utf-8","gbk//IGNORE",$csv_line_data);
        //$header_str = iconv("utf-8", 'gbk', $title);
        //$csv_line_data = iconv("utf-8", 'gbk//IGNORE', $csv_line_data);

        ob_end_clean();

                //写出

        echo $header_str;
        echo $csv_line_data;
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值