selecting gridview columns to download to excel file

[hedgracer]

I have the following code to download a gridview to an excel file:

public static void ExportExcelFile(Control htmlData, string filename)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition",
"attachment;filename=" + filename + ".xls");
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
htmlData.RenderControl(htmlWrite);
HttpContext.Current.Response.Write(stringWrite.ToString());
HttpContext.Current.Response.End();
}

My problem is that I need to delete the last column from the download (there are six columns total including the one I need to delete). Is there any way to do this in ASP.NET 2.0? Thanks for any help in advance

Dave

 

[ca8msm]

Either don't bind the last column (by not including it in the sql statement or removing it from the GridView's column section) or hide each column cell using it's Visible property.


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

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]