GridView 导出 Excel时，某几列不要显示出来。有什么好办法（在不修改gridview里面的数据情况下）

霜寒月冷 2009-11-18 04:14:58

GridView 导出 Excel时，某几列不要显示出来。有什么好办法（在不修改gridview里面的数据情况下）
因为Gridview 里面有些图片。删掉又不好看。导出来的excel又有××，故不想让那列显示。

...全文

614 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

耗子1988 2011-11-10

打赏
举报

用第三方得导出怎样设置像这样的隐藏啊

霜寒月冷 2009-11-20

打赏
举报

[Quote=引用 5 楼 chenjianyong94 的回复:]
在点击导出按钮的时候把不需要导出的那几列隐藏掉即可。。
C# code//导出Excel,此为导出按钮protectedvoid Button1_Click(object sender, EventArgs e)
{
Export("application/ms-excel","学生成绩报表.xls");
}//导出Excel函数privatevoid Export(string FileType,string FileName)
{//在这里将你不想要的列隐藏掉即可。比如隐藏 6，7行 gridview1.Rows[5].visable=false;
gridview1.Rows[6].visable=false;
Response.Charset="GB2312";
Response.ContentEncoding= System.Text.Encoding.UTF7;
Response.AppendHeader("Content-Disposition","attachment;filename="+ HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
Response.ContentType= FileType;this.EnableViewState=false;
StringWriter tw=new StringWriter();
HtmlTextWriter hw=new HtmlTextWriter(tw);
GridView1.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
}//导出方法，必须有！！！！！！！！publicoverridevoid VerifyRenderingInServerForm(Control control)
{
}
[/Quote]
不错不错的！！

love_cloud 2009-11-19

打赏
举报

5楼已经解决

ivws_19 2009-11-19

打赏
举报

同意楼上，隐藏列即可

chenjianyong94 2009-11-19

打赏
举报

在点击导出按钮的时候把不需要导出的那几列隐藏掉即可。。

//导出Excel,此为导出按钮 

    protected void Button1_Click(object sender, EventArgs e)

    {

        Export("application/ms-excel", "学生成绩报表.xls");

    }

    //导出Excel函数

    private void Export(string FileType, string FileName)

    {

      //在这里将你不想要的列隐藏掉即可。比如隐藏 6，7行 

        gridview1.Rows[5].visable=false;

         gridview1.Rows[6].visable=false;

        Response.Charset = "GB2312";

        Response.ContentEncoding = System.Text.Encoding.UTF7;

        Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());

        Response.ContentType = FileType;

        this.EnableViewState = false;

        StringWriter tw = new StringWriter();

        HtmlTextWriter hw = new HtmlTextWriter(tw);

        GridView1.RenderControl(hw);

        Response.Write(tw.ToString());

        Response.End();

    }

    //导出方法，必须有！！！！！！！！

    public override void VerifyRenderingInServerForm(Control control)

    {

    }

霜寒月冷 2009-11-19

打赏
举报

[Quote=引用 3 楼 yupengcheng_net 的回复:]
我前几天也遇见过这个情况，我后来想了2个办法，一个就是在查询的时候不查询那个字段
第二个就是用水晶报表弄的，里面有自带的导入导出，格式很多
[/Quote]
自己再up下！！

孤芳-自赏 2009-11-18

打赏
举报

我前几天也遇见过这个情况，我后来想了2个办法，一个就是在查询的时候不查询那个字段
第二个就是用水晶报表弄的，里面有自带的导入导出，格式很多

霜寒月冷 2009-11-18

打赏
举报

[Quote=引用 1 楼 jieyi1106 的回复:]
自己构建格式呗
拿去用吧
自己看的改
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
Page.EnableViewState = false;
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.AppendHeader("Content-Disposition", "attachment;filename=Order.xls");
int total = 0;
#region 取商品分类
IDictionary kind = QueryUtil.GetConfigItems(ConfigType.CommodityKind);
SortedList sl = new SortedList();
foreach (DictionaryEntry entry in kind)
{
sl.Add(entry.Value, entry.Key);
}
#endregion
DataTable dt = QueryUtil.GetDataResult(QueryEnum.MerchantPosjsmx, 1, (int)ViewState["CalTotal"], (Hashtable)ViewState["Query"], false, out total);
IDictionary colDic = GetColumn();
StringBuilder sb = new StringBuilder();
sb.Append(" <html> <head> <meta http-equiv=Content-Type content=\"text/html; charset=GB2312\"> </head> <body> <center>");
sb.Append(" <table>");
sb.Append(" <tr>");
foreach (DataColumn col in dt.Columns)
{
if (colDic.Contains(col.ColumnName.ToUpper()))
sb.AppendFormat(" <td>{0} </td>", colDic[col.ColumnName.ToUpper()].ToString());
}
sb.Append(" </tr>");
foreach (DataRow row in dt.Rows)
{
sb.Append(" <tr>");
foreach (DataColumn col in dt.Columns)
{
if (colDic.Contains(col.ColumnName.ToUpper()))
{
if (col.ColumnName.Equals("CUST_TYPE", StringComparison.InvariantCultureIgnoreCase))
sb.AppendFormat(" <td>{0} </td>", CustType(row[col.ColumnName].ToString()));
else if (col.ColumnName.Equals("CUST_CLASS", StringComparison.InvariantCultureIgnoreCase))
sb.AppendFormat(" <td>{0} </td>", CardClass(row[col.ColumnName].ToString()));
else if (col.ColumnName.Equals("MERCHANT_PROVINCE", StringComparison.InvariantCultureIgnoreCase))
sb.AppendFormat(" <td>{0} </td>", QueryUtil.ConvertProvince(row[col.ColumnName].ToString()));
else if (col.ColumnName.Equals("MERCHANT_CITY", StringComparison.InvariantCultureIgnoreCase))
sb.AppendFormat(" <td>{0} </td>", QueryUtil.ConvertCity(row[col.ColumnName].ToString(), QueryUtil.ConvertProvince(row["MERCHANT_PROVINCE"].ToString())));

else if (col.ColumnName.Equals("CUST_PROVINCE", StringComparison.InvariantCultureIgnoreCase))
sb.AppendFormat(" <td>{0} </td>", QueryUtil.ConvertProvince(row[col.ColumnName].ToString()));
else if (col.ColumnName.Equals("CUST_CITY", StringComparison.InvariantCultureIgnoreCase))
sb.AppendFormat(" <td>{0} </td>", QueryUtil.ConvertCity(row[col.ColumnName].ToString(), QueryUtil.ConvertProvince(row["CUST_PROVINCE"].ToString())));

else
sb.AppendFormat(" <td>{0} </td>", row[col.ColumnName].ToString());
}
}
sb.Append(" </tr>");
}
sb.Append(" </table>");
sb.Append(" </center> </body> </html>");
Response.Write(sb.ToString());
Response.End();

[/Quote]
感觉好复杂的哦！有简便点的么

jieyi1106 2009-11-18

打赏
举报

自己构建格式呗
拿去用吧
自己看的改
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
Page.EnableViewState = false;
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.AppendHeader("Content-Disposition", "attachment;filename=Order.xls");
int total = 0;
#region 取商品分类
IDictionary kind = QueryUtil.GetConfigItems(ConfigType.CommodityKind);
SortedList sl = new SortedList();
foreach (DictionaryEntry entry in kind)
{
sl.Add(entry.Value, entry.Key);
}
#endregion
DataTable dt = QueryUtil.GetDataResult(QueryEnum.MerchantPosjsmx, 1, (int)ViewState["CalTotal"], (Hashtable)ViewState["Query"], false, out total);
IDictionary colDic = GetColumn();
StringBuilder sb = new StringBuilder();
sb.Append("<html><head><meta http-equiv=Content-Type content=\"text/html; charset=GB2312\"></head><body><center>");
sb.Append("<table>");
sb.Append("<tr>");
foreach (DataColumn col in dt.Columns)
{
if (colDic.Contains(col.ColumnName.ToUpper()))
sb.AppendFormat("<td>{0}</td>", colDic[col.ColumnName.ToUpper()].ToString());
}
sb.Append("</tr>");
foreach (DataRow row in dt.Rows)
{
sb.Append("<tr>");
foreach (DataColumn col in dt.Columns)
{
if (colDic.Contains(col.ColumnName.ToUpper()))
{
if (col.ColumnName.Equals("CUST_TYPE", StringComparison.InvariantCultureIgnoreCase))
sb.AppendFormat("<td>{0}</td>", CustType(row[col.ColumnName].ToString()));
else if (col.ColumnName.Equals("CUST_CLASS", StringComparison.InvariantCultureIgnoreCase))
sb.AppendFormat("<td>{0}</td>", CardClass(row[col.ColumnName].ToString()));
else if (col.ColumnName.Equals("MERCHANT_PROVINCE", StringComparison.InvariantCultureIgnoreCase))
sb.AppendFormat("<td>{0}</td>", QueryUtil.ConvertProvince(row[col.ColumnName].ToString()));
else if (col.ColumnName.Equals("MERCHANT_CITY", StringComparison.InvariantCultureIgnoreCase))
sb.AppendFormat("<td>{0}</td>", QueryUtil.ConvertCity(row[col.ColumnName].ToString(), QueryUtil.ConvertProvince(row["MERCHANT_PROVINCE"].ToString())));

else if (col.ColumnName.Equals("CUST_PROVINCE", StringComparison.InvariantCultureIgnoreCase))
sb.AppendFormat("<td>{0}</td>", QueryUtil.ConvertProvince(row[col.ColumnName].ToString()));
else if (col.ColumnName.Equals("CUST_CITY", StringComparison.InvariantCultureIgnoreCase))
sb.AppendFormat("<td>{0}</td>", QueryUtil.ConvertCity(row[col.ColumnName].ToString(), QueryUtil.ConvertProvince(row["CUST_PROVINCE"].ToString())));

else
sb.AppendFormat("<td>{0}</td>", row[col.ColumnName].ToString());
}
}
sb.Append("</tr>");
}
sb.Append("</table>");
sb.Append("</center></body></html>");
Response.Write(sb.ToString());
Response.End();