Comments by farogh haider (Top 3 by date)

Thanks, for replying me
Below code is using to generate excel.



public ActionResult ExportToExcelInvoiceInView(int sno)
{

gvUserInfo.DataSource = Datasource; // Binding with GridView
gvUserInfo.ShowFooter = true;

gvUserInfo.DataBind();

GridViewRow footerRow = gvUserInfo.FooterRow;
Label lbl = new Label();
lbl.Text = footer;
footerRow.Cells[lastColumnIndex].Controls.Add(lbl);

System.IO.StringWriter sw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
gvUserInfo.RenderControl(htw);
byte[] buf = DocWriter.GetISOBytes(sw.ToString());
return new BinaryContentResult(buf, "Invoice.xls");

}