coffee_cn

博客园 首页 新随笔 联系 订阅 管理
<?php
$objPHPExcel = new PHPExcel();
$objSheet = $objPHPExcel->getActiveSheet();
$array = array(
    array("规格型号", "产品编号", "描述", "入库数量", "出库数量", "当前库存"),
    array($spec, $no)
);
$objSheet->fromArray($array);
$filename = '在库数据20190508.xls';
$this->startDownload($filename);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');



/**
 * 生产文件下载需要的响应头信息。
 * @param string $name 文件名称,可为中文。
 */
function startDownload($name) {
    $ua = $_SERVER["HTTP_USER_AGENT"];
    if (strpos($ua, "MSIE"))
        $name = "=\"".str_replace("+", "%20", urlencode($name))."\"";
    elseif (strpos($ua, "Firefox"))
        $name = "*=\"utf8''".$name."\"";
    else
        $name = "=\"".$name."\"";
    header("Expires: Mon, 26 Jul 1997 05:00:00 GMT\n");
    header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
    header("Cache-Control: no-cache");
    header("Pragma: no-cache");
    header("Content-Disposition: attachment; filename".$name);
    header("Content-type: application/octet-stream");
}
?>

 

posted on 2019-05-08 15:35  coffee  阅读(1503)  评论(0编辑  收藏  举报