//Export the table to a .xls file
protected void btn_Export_Click(object sender, EventArgs e)
{
//Clear output stream
Response.ClearContent();
//set filename
Response.AppendHeader("content-disposition", "attachment; filename=Ingrediententen.xls");
//setcontenttype
Response.ContentType = "application/excel";
//set stringwriter to htmlwriter
StringWriter sw = new StringWriter();
HtmlTextWriter htmltw = new HtmlTextWriter(sw);
//Write the data to he .xls file
IngredientView.RenderControl(htmltw);
Response.Write(sw.ToString());
//end
Response.End();
}
