ASP.NET

<input type="button" value="Export to Excel" onclick="ExportToExcel()"/>

<script type="text/javascript">
      function ExportToExcel()
      {
          var txt = window.open("pageListForExportExcel.aspx");
      }
</script>

<%@ Page Language="C#" AutoEventWireup="true" EnableSessionState="ReadOnly" EnableViewState="false" CodeBehind="BukuInduk_exportToExcel.aspx.cs" Inherits="LimSys.Web.Laporan.BukuInduk_exportToExcel" %>
		<asp:Repeater ID="rep1" runat="server">
			<HeaderTemplate>
				<table border=1>
					<tr>
						<td>NAME</td>
						<td>ADDRESS</td>
						<td>TELP</td>
						<td>GENDER</td>
					</tr>
			</HeaderTemplate>
			<ItemTemplate>
					<tr>
						<td><%# Eval("name")%></td>
						<td><%# Eval("address")%></td>
						<td><%# Eval("telp")%></td>
						<td><%# Eval("gender")%></td>
					</tr>
			</ItemTemplate>
			<FooterTemplate>
				</table>
			</FooterTemplate>
		</asp:Repeater>

 protected void Page_Load(object sender, EventArgs e)
{
    Response.Clear();// this for clear any response
    Response.Buffer = true; // and then set to Buffer is true
    Response.ContentType = "application/vnd.ms-excel";// and this is for call type what you want to set File extention for save....you can export to pdf ,if you change value Response.ContentType

    var process = new DataLayersCollections();//set here by name your BusinesLogic
    var list = process.GetListFromDataTable(); //set here by name your functions
    rep1.DataSource = list;
    rep1.DataBind();
}

Jassim Rahma wrote:

object reference not set to an instance of an object