php Excel导出文件

php Excel导出文件

   	/***
     * 导出xls文件
     * @param array $header     表格第一行 array('SKU', '主SKU', '商品名称', '成本价', '批量生产价格', '销售状态', '销售类型', '供应商', '采购人', '维护人');
     * @param array $index      $data 下标 顺序导出
     * @param array $data       导出所需数据
     * @param string $title     文件名
     */
    public function ouputExclePlus($header, $index, $data, $title='')
    {
        if ( !$data ){
            echo "NO DATA"; die;
        }

        $fileName = date("YmdHis");
        header("Content-type:application/octet-stream");
        header("Accept-Ranges:bytes");
        header("Content-type:application/vnd.ms-excel");
        header("Content-Disposition:attachment;filename=$title$fileName.xls");
        header("Pragma: no-cache");
        echo "<table>";
        echo "<tr>";
        foreach ($header as $h) {
            echo "<td style='border:1px solid;'>$h</td>";
        }
        echo "</tr>";

        foreach($data as $d){
            echo "<tr>";
            foreach ($index as $i) {
                echo "<td style='border:1px solid;'>$d[$i]</td>";
            }
            echo "</tr>";
        }
        echo "</table>";
        exit;
    }

调用

ini_set("memory_limit", -1);
$field = "goods_sku, goods_parent_sku, goods_name, g_costprice, bulkprice, g_sale_status, g_sale_cate, name, g_buyer, g_checkman ";
$db = "	db_goods g LEFT JOIN db_factory f ON g_supplier = f.id ";
$res = $this->fun->getdatabaseslist($db, $where, $field);

$title = array('SKU', '主SKU', '商品名称', '成本价', '批量生产价格', '销售状态', '销售类型', '供应商', '采购人', '维护人');
$index = array('goods_sku', 'goods_parent_sku', 'goods_name', 'g_costprice', 'bulkprice', 'g_sale_status', 'g_sale_cate', 'name', 'g_buyer', 'g_checkman');

$this->fun->ouputexclePlus($title, $index, $res, '商品导出');
die;