求ASP.net 根据介面查询条件,查询出数据,动态导出Excel的方法 题头动...

发布网友 发布时间：2024-10-24 18:19

我来回答

共1个回答

热心网友 时间：2024-11-05 05:21

以前写过一个导出不规则表格的方法

public static void ExportIrregularTable2Excel(DataTable dt1,DataTable dt2)
        {
            System.Web.HttpContext.Current.Response.Clear();
            System.Web.HttpContext.Current.Response.Buffer = true;
            //设置Http的头信息,编码格式
            System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=result.xls");
            System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel";
            //设置编码
            System.Web.HttpContext.Current.Response.Charset = "GB2312";
            System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            //写表
            System.Web.HttpContext.Current.Response.Write("<table border='1'  cellspacing='0' cellpadding='0'>"+
            "<tr>"+
                "<td style='text-align:center;font-size:large;font-weight:bold;' colspan='4'>"+
                    "技术部项目申请表</td>"+
            "</tr>"+
            "<tr>"+
                "<td style='text-align:center;'>"+
                    "项目名称：</td>"+               
                "<td style='text-align:left;' colspan='3'>"+
                    dt1.Rows[0][1].ToString()+"</td>"+
            "</tr>"+
            "<tr>"+
                "<td style='text-align:center;'>"+
                    "提出时间：</td>"+
                    "<td >"+
                    dt1.Rows[0][2].ToString() + "</td>" +
                "<td style='text-align:center;'>"+
                    "提出人：</td>"+
                "<td style='text-align:center;' >"+
                     dt1.Rows[0][3].ToString() + "</td>" +
            "</tr>"+
            "<tr>"+
                "<td colspan='4' style='text-align:center;'>"+
                    "项目要达到的要求</td>"+
            "</tr>"+
            "<tr>"+
                "<td colspan='4'>"+
                     dt1.Rows[0][4].ToString() + "</td>" +
            "</tr>"+
            "<tr>"+
                "<td colspan='4' style='text-align:center;'>"+
                    "项目管理委员会审批</td>"+
            "</tr>"+
            "<tr>"+
                "<td style='text-align:center;'>"+
                    "项目经理：</td>"+
                "<td style='text-align:center;'>" +
                     dt1.Rows[0][5].ToString() + "</td>" +
                "<td style='text-align:center;'>"+
                    "项目类别：</td>"+
                "<td style='text-align:center;'>"+
                     proj_type + "</td>" +
            "</tr>"+
            "<tr>"+
                "<td style='text-align:center;'>"+
                    "实施时间：</td>"+
                "<td style='text-align:center;'>" +
                     dt1.Rows[0][7].ToString() + "</td>" +
                "<td style='text-align:center;'>"+
                    "项目总计划工时：</td>"+
                "<td style='text-align:center;'>" +
                    Allhour+"</td>"+
            "</tr>"+
            "<tr>"+
                "<td style='text-align:center;' rowspan='" + (CountR + 1) + "'>" +
                    "参与人员：</td>"+
                "<td style='text-align:center;'>"+
                    "姓名</td>"+
                "<td style='text-align:center;'>"+
                    "项目职务</td>"+
                "<td style='text-align:center;'>"+
                    "工时</td>"+
            "</tr>"+            
                "</table>");
            System.Web.HttpContext.Current.Response.End();
 
        }