导出Excel -----选择想要导出的列

最新推荐文章于 2024-05-11 17:17:15 发布

hxm_admin

最新推荐文章于 2024-05-11 17:17:15 发布

阅读量2.2k

点赞数

分类专栏： Excel 文章标签：导出Excel

本文链接：https://blog.csdn.net/hxm_admin/article/details/47130215

版权

Excel 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

<body>

<div id="light" class="black_content" style="height:440px;width:1150px;display:none;">

             <div id="light" class="black_content" style="height:440px;width:1150px;display:none;">
          <table>
          <tr><td class="tdhead_search" colspan="5">自定义导出Excel</td></tr>
          <tr>
          <td class="tdhead_search" colspan="3" class="tdhead_search">
         <asp:CheckBox ID="CheckAll" runat="server" Text="全选" οnclick="javascript: SelectAllCheckboxes(this);" />
          </td>
          <td class="tdhead_search" style="text-align:center;" class="tdhead_search">
              <asp:Button ID="Button1" runat="server" class="inp150" Text="确定/导出Excel" οnclick="btnToExcel_Click"/>
          </td>
          <td class="tdhead_search" style="text-align:center;" class="tdhead_search"><asp:Button ID="uduf" class="inp" runat="server" Text="关闭" /></td>

          </tr> <tr><td class="tdhead_search" colspan="5" class="tdhead_search"></td></tr>
              <tr>
                  <td class="tdhead_search"><asp:CheckBox ID="ChkTask1" runat="server" />Region/大区</td>
                  <td class="tdhead_search"><asp:CheckBox ID="ChkTask2" runat="server" />Area/区域</td>
                  <td class="tdhead_search"><asp:CheckBox ID="ChkTask3" runat="server" />City/城市</td>
                  <td class="tdhead_search"><asp:CheckBox ID="ChkTask4" runat="server" />Applicant/申请人</td>
                  <td class="tdhead_search"><asp:CheckBox ID="ChkTask5" runat="server" />Submit Date/申请日期</td>
              </tr>
              <tr>
                  <td class="tdhead_search"><asp:CheckBox ID="ChkTask6" runat="server" />Budget Owner</td>
                  <td class="tdhead_search"><asp:CheckBox ID="ChkTask7" runat="server" />ANP approval end date/ANP审批结束日期</td>
                  <td class="tdhead_search"><asp:CheckBox ID="ChkTask8" runat="server" />SAP approval end date/SAP审批结束日期</td>
                  <td class="tdhead_search"><asp:CheckBox ID="ChkTask9" runat="server" />ANP Closing date/ANP关闭日期</td>
                  <td class="tdhead_search"><asp:CheckBox ID="ChkTask10" runat="server" />Spending Type/费用类型</td>
              </tr>
          </table>
          </div>
          </div>
    </form>
</body>

--------------------------------------------------------------------

</script>

------------------------后台----------------------------------

protected void btnToExcel_Click(object sender, EventArgs e)
{
string strSql = "select ";

if (this.ChkTask1.Checked==true)
        { strSql += " FDSMRegionCode as 'Region/大区' "; }
        if (this.ChkTask2.Checked == true)
        { strSql += ", FDSMClusterCode as 'Area/区域' "; }
        if (this.ChkTask3.Checked == true)
        { strSql += ", FCity as 'City/城市' "; }
        if (this.ChkTask4.Checked == true)
        { strSql += ", FRequestName as 'Applicant/申请人' "; }
        if (this.ChkTask5.Checked == true)
        { strSql += ", Convert(varchar(10),FFirstAppTime,23) as 'Submit Date/申请日期' "; }
        if (this.ChkTask6.Checked == true)
        { strSql += ", FBudgetOwner as 'Budget Owner' "; }
        if (this.ChkTask7.Checked == true)
        { strSql += ", Convert(varchar(10),FANPEndDate,23) as 'ANP approval end date/ANP审批结束日期' "; }
        if (this.ChkTask8.Checked == true)
        { strSql += ", Convert(varchar(10),FApproveEndTime,23) as 'SAP approval end date/SAP审批结束日期'"; }
        if (this.ChkTask9.Checked == true)
        { strSql += ", Convert(varchar(10),FCloseDate,23) as 'ANP Closing date/ANP关闭日期' "; }
        if (this.ChkTask10.Checked == true)
        { strSql += ", FSpendingType as 'Spending Type/费用类型'"; }

if ( strSql == "select ")
        { Response.Write("<Script Language=JavaScript>alert('请选择列名！');</Script>"); }
        else
        {
        strSql += "From VW_FM_ANP_ActivityTracking WHERE 1=1";
        strSql += "order by taskid desc, FActivityCode desc";
        ExportToExcel.ExportExcelFromDs(DbHelperSQL.Query(strSql).Tables[0], "Full report", new double[] { 150, 100, 100, 80, 80, 80, 80, 80, 80, 80 });
    }
    }

-------------------------------------------------------------

public static void ExportExcelFromDs(DataTable dt, string titleName, double[] titleWidths)
    {
        StringBuilder builder = new StringBuilder();
        try
        {
            for (int i = 0; i < dt.Columns.Count; i++)
            {
                if (i > 0)
                {
                    builder.Append("\t");
                }
                builder.Append(dt.Columns[i].ColumnName.Trim());
            }
            builder.Append("\n");
            for (int j = 0; j < dt.Rows.Count; j++)
            {
                for (int k = 0; k < dt.Columns.Count; k++)
                {
                    if (k > 0)
                    {
                        builder.Append("\t");
                    }
                    builder.Append(dt.Rows[j][k].ToString());
                }
                builder.Append("\n");
            }
        }
        catch (Exception)
        {
        }
        string str = DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
        HttpContext current = HttpContext.Current;
        current.Response.ContentType = "application/vnd.ms-excel";
        current.Response.ContentEncoding = Encoding.GetEncoding("GB2312");
        current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + str);
        current.Response.Write(builder.ToString());
        current.Response.Flush();
        current.Response.End();
    }