asp dot net,c#.net,maps,code sample: Excel

Introduction :

In this article I will explain how to export from a GridView data to an Excel file. In the following example we will use RenderControl method outputs server control content (to a provided HtmlTextWriter object and stores tracing information) about the control if tracing is enabled.

This method will confirms that an HtmlForm control is rendered for the specified Asp.Net server control at run time.

c# excel,gridview export,excel spreadsheet,export data from excel,excel documents,aspnet,simple example

Default.cs Code:

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.IO;

public partial class _Default : System.Web.UI.Page

{

DataTable dt = new DataTable();

protected void Page_Load(object sender, EventArgs e)

{

dt.Columns.Add("EmpId", typeof(int));

dt.Columns.Add("Name", typeof(string));

dt.Columns.Add("Address", typeof(string));

dt.Columns.Add("Date", typeof(DateTime));

// Here we add five DataRows.

dt.Rows.Add(25, "Rk", "Gurgaon", DateTime.Now);

dt.Rows.Add(50, "Sachin", "Noida", DateTime.Now);

dt.Rows.Add(10, "Nitin", "Noida", DateTime.Now);

dt.Rows.Add(21, "Aditya", "Meerut", DateTime.Now);

dt.Rows.Add(100, "Mohan", "Banglore", DateTime.Now);

GridView1.DataSource = dt;

GridView1.DataBind();

}

protected void btnexport_Click(object sender, EventArgs e)

{

try

{

Response.Clear();

Response.Buffer = true;

Response.AddHeader("content-disposition", "attachment;filename=gridviewdata.xls");

Response.Charset = "";

Response.ContentType = "application/vnd.ms-excel";

StringWriter sWriter = new StringWriter();

HtmlTextWriter hWriter = new HtmlTextWriter(sWriter);

GridView1.RenderControl(hWriter);

Response.Output.Write(sWriter.ToString());

Response.Flush();

Response.End();

}

catch (Exception ex)

{

Label1.Text = ex.ToString();

}

public override void VerifyRenderingInServerForm(Control control)

{

}

To download example source code click here

Introduction:

Many times we need to export reports in excel format. So here I will explain how to export Dataset or Datatable in Excel file. Follow the below instructions:

1. Add reference to Microsoft.Office.Interop.Excel.dll

2. using System.Runtime.InteropServices;

Source:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Untitled Page</title>

</head>

<body>

<div>

<asp:GridView ID="GridView1" runat="server">

</asp:GridView>

<br />

<asp:Button ID="btnExportExcel" runat="server" Text="Export To Excel"

onclick="btnExportExcel_Click" />

</div>

</form>

</body>

</html>

Code Behind:

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Runtime.InteropServices;

public partial class _Default : System.Web.UI.Page

{

DataTable productsDataTable = new DataTable();

protected void Page_Load(object sender, EventArgs e)

{

// create DataTable object

// auto increment column for productsDataTable

DataColumn dataColumn = new DataColumn("AutoID", System.Type.GetType("System.Int32"));

dataColumn.AutoIncrement = true;

dataColumn.AutoIncrementSeed = 1;

dataColumn.AutoIncrementStep = 1;

dataColumn.Unique = true;