I need to to export excel with password from Grid view . I am using following Code for same
public ActionResult DataExportExcel(GridView GridView1, string FileName, int FontSize)
{
GridView1.Font.Size = FontSize;
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView dataGridView1 = new GridView();
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=" + FileName.Trim() + ".xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
int RowCount= GridView1.Rows.Count;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
// GridView1.Rows[i].Attributes.Add("class", "textmode");
GridView1.Rows[i].Height = 33;
GridView1.Rows[i].Cells[5].Wrap = false;
GridView1.Rows[i].Cells[5].Style.Add("mso-number-format", TestFormat(GridView1.Rows[i].Cells[5].Text.Length));
}
GridView1.Rows[RowCount-1].Cells[3].Font.Bold = true;
GridView1.Rows[RowCount - 1].Cells[4].Font.Bold = true;
GridView1.RenderControl(hw);
GridView1.HeaderStyle.Height = 33;
GridView1.FooterStyle.Height = 33;
dataGridView1 = GridView1;
Response.Output.Write(Convert.ToString(sw));
Response.Flush();
Response.End();
return View();
}
So pls Help me