Creer un fichier Excel

Réponse acceptée !
Bonjour,

Voici un exemple pour envoyer un fichier Excel construit à partir d'un dataset.

DataGrid export = new DataGrid();
export.DataSource = xls;
export.AllowSorting = false;
export.DataBind();
HttpContext.Current.Response.ContentEncoding  = System.Text.Encoding.UTF7;
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer= true;
HttpContext.Current.Response.Cache.SetExpires(DateTime.Now.AddSeconds(1));
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter tw = new System.Web.UI.HtmlTextWriter(sw);
export.RenderControl(tw);
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename="+"nomfichier"+".xls");
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();