您的位置 首页 php

ajax+PHPExcel 下载Excel

HTML

 return [ '<a href = "#" onClick = "trk_detail(\'' + q_mth + '\',\'' + q_slic + '\',\'' + q_type + '\')">' + ttlpcs + '</a>'].join("")  

jquery

     function trk_detail(q_mth, q_slic, q_type) {
        var url = 'json/diad_pu_trk_download.php';
        var  params  = {
            q_year: q_mth,
            q_slic: q_slic,
            q_type: q_type
        };
        $.ajax({
            type: 'GET',
            url: url,
            data: params,
            dataType: 'json',
            // beforeSend: function ( request ) {
            //     request.setRequestHeader("Authorization", "token信息,验证身份");
            // },
            success: function (data) {
                console.log(data)
                var $a = $("<a>");
                $a.attr("href", data.file);
                $("body").append($a);
                $a.attr("download", data.filename);
                $a[0].click();
                $a.remove();
            }
        });
    }  

PHP

 $filename="DIAD_".$type."_".$slic.".xlsx";
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, ' Excel2007 ');
ob_start();
$objWriter->save('php://output'); //输出到浏览器
$xlsData = ob_get_contents();
ob_end_clean();
$response =  array(
'filename' => $filename,
'file' => "data:application/vnd.openxmlformats-office document .spreadsheetml.sheet;base64," . base64_encode($xlsData)
);
die(json_encode($response));  

文章来源:智云一二三科技

文章标题:ajax+PHPExcel 下载Excel

文章地址:https://www.zhihuclub.com/152231.shtml

关于作者: 智云科技

热门文章

网站地图