asp.net DataTable 转换 excel 下载

    private void  dataTable2Excel(DataTable table, string name)
    {
        Response.ContentType = "text/csv";
        Response.ContentEncoding = System.Text.Encoding.UTF8;
        Response.AppendHeader("Content-Disposition", "attachment; filename=" + name + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");
        Response.BinaryWrite(System.Text.Encoding.UTF8.GetPreamble());

        string  ls_item = "";

        Response.Output.Write("采购日期\t采购单据号\t业务类别\t供应商\t商品编号\t商品名称\t规格型号\t单位\t仓库\t数量\t单价\t采购金额\n");
        
        foreach (DataRow dr in table.Rows)
        {
            ls_item += (String.Format("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}\t{8}\t{9}\t{10}\t{11}\n"
                   , dr["purchaseDate"], dr["purchasesNumber"], dr["transType"], dr["supplierName"], dr["number"], dr["name"], dr["spec"], dr["unitName"], dr["storageName"], dr["quantity"], dr["price"], dr["amount"]));
        }
        Response.Output.Write(ls_item);
        Response.End();

    }

演示地址（采购单明细报表）

http://218.95.37.10:8083/login.aspx 

密码:1234