Hi Friends,
Today i will tell you how to export data to excel from gridview in asp.net. For this firstly create a project in asp.net.Add a gridview control in aspx page from toolbox as shown below:
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.TextAlign {
text-align:center;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" Height="220px" Width="440px">
<RowStyle CssClass="TextAlign" />
</asp:GridView>
</div>
<div>
</div>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Export To Excel" Width="163px" />
</form>
</body>
</html><html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.TextAlign {
text-align:center;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" Height="220px" Width="440px">
<RowStyle CssClass="TextAlign" />
</asp:GridView>
</div>
<div>
</div>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Export To Excel" Width="163px" />
</form>
</body>
</html>
Now add the code from code behind as follows :-
public void BindGridView()
{
try
{
List<Student> objStudentList = GetStudentStaticData();
GridView1.DataSource = objStudentList;
GridView1.DataBind();
}
catch (Exception ex)
{
//Log Exception
}
}
/// <summary>
/// Static Data Function
/// You can get the dynamic data from database using SQL,LINQ etc.
/// </summary>
/// <returns></returns>
private List<Student> GetStudentStaticData()
{
List<Student> objStudent = new List<Student>();
objStudent.Add(new Student { StudentID = 1, StudentName = "John", CIty = "LA" });
objStudent.Add(new Student { StudentID = 2, StudentName = "Sam", CIty = "WD" });
objStudent.Add(new Student { StudentID = 3, StudentName = "Shane", CIty = "MH" });
objStudent.Add(new Student { StudentID = 4, StudentName = "Kurt", CIty = "NY" });
objStudent.Add(new Student { StudentID = 5, StudentName = "RVD", CIty = "NJ" });
objStudent.Add(new Student { StudentID = 6, StudentName = "Booker", CIty = "LA" });
objStudent.Add(new Student { StudentID = 7, StudentName = "Hilery", CIty = "MH" });
objStudent.Add(new Student { StudentID = 8, StudentName = "Jorge", CIty = "FL" });
objStudent.Add(new Student { StudentID = 9, StudentName = "Bill", CIty = "SL" });
objStudent.Add(new Student { StudentID = 10, StudentName = "Angel", CIty = "PD" });
return objStudent;
}
//This event will be fired for export to excel button
protected void Button1_Click(object sender, EventArgs e)
{
ExportToExcel();
}
protected void ExportToExcel()
{
try
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
#region RenderGridView Under Form Tag
//We need to write this code because if you directly render control then
//it will throw a exception of render the control under form tag.
Control parent = GridView1.Parent;
int GridIndex = 0;
if (parent != null)
{
GridIndex = parent.Controls.IndexOf(GridView1);
parent.Controls.Remove(GridView1);
}
if (parent != null)
{
parent.Controls.AddAt(GridIndex, GridView1);
}
GridView1.RenderControl(hw);
#endregion
//To Export all pages
GridView1.AllowPaging = false;
BindGridView();
//style to format numbers to string
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
}
catch (Exception ex)
{
//Log Exception
}
}
Here i have created the Button1_Click event for the button i have used to Export data to excel.
ExportToExcel() is the main function to export grid to excel.
This will create the GridViewExport.xls file with all grid data in it.
Thank you for reading.
Happy Coding!!
0 Comment(s)