{"id":4521,"date":"2015-07-24T04:35:52","date_gmt":"2015-07-24T04:35:52","guid":{"rendered":"http:\/\/ngenioussolutions.com\/blog\/?p=60"},"modified":"2023-08-10T11:12:19","modified_gmt":"2023-08-10T11:12:19","slug":"export-data-table-to-excel-sheetcsv-on-button-click","status":"publish","type":"post","link":"https:\/\/ngenioussolutions.com\/blog\/export-data-table-to-excel-sheetcsv-on-button-click\/","title":{"rendered":"Export data table to Excel Sheet(CSV) on Button Click"},"content":{"rendered":"

First You have to Create a grid view that will show details which you want to Export<\/strong><\/h2>\n
\n
<asp:GridView ID=”GridView1″ CssClass=”footable” runat=”server” AutoGenerateColumns=”false”<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 Style=”max-width: 500px” ><\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 <Columns><\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <asp:BoundField DataField=”Id” HeaderText=”Id” \/><\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <asp:BoundField DataField=”Name” HeaderText=”Name” \/><\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <asp:BoundField DataField=”Company” HeaderText=”Company” \/><\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <asp:BoundField DataField=”Age” HeaderText=”Age” \/><\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 <\/Columns><\/div>\n
\u00a0 \u00a0 <\/asp:GridView><\/div>\n<\/div>\n
<\/div>\n

Bind you details to GridView<\/b>
\nC# Code Behind:-<\/b>
\npublic static DataTable dt; \/\/Declare your dt globle to paas it in another function<\/u>
\nprotected void Page_Load(object sender, EventArgs e)
\n{
\nif (!this.IsPostBack)
\n{
\ndt = new DataTable();
\ndt.Columns.AddRange(new DataColumn[4] { new DataColumn(“Id”), new DataColumn(“Name”), new DataColumn(“Company”), new DataColumn(“Age”) });
\ndt.Rows.Add(1, “Savan”, “MSOSL”, 23);
\ndt.Rows.Add(2, “Rupesh”, “KLOSJ”, 25);
\ndt.Rows.Add(3, “Rahul”, “JSKL”, 26);
\nGridView1.DataSource = dt;
\nGridView1.DataBind();
\n}<\/p>\n

}<\/p>\n

Create a button that will export you details to Excel<\/b><\/p>\n

<asp:Button ID=”Button1″ runat=”server” Text=”Export” OnClick=”Button1_Click” \u00a0\/>
\n
\n<\/b>Call the function on click event<\/b>
\nC# Code Behind:-<\/b>
\n<\/b>
\n<\/b>protected void Button1_Click(object sender, EventArgs e)
\n{
\nExportDataTableToCSV(dt);<\/p>\n

}<\/p>\n

protected void ExportDataTableToCSV(DataTable dt)
\n{<\/p>\n

Response.Clear();
\nResponse.ContentType = “text\/csv”;
\nResponse.AddHeader(“content-disposition”, “attachment;filename=Customers.csv”);<\/p>\n

StringBuilder sb = new StringBuilder();<\/p>\n

for (int i = 0; i < dt.Columns.Count; i++)
\n{
\nsb.Append(dt.Columns[i].ColumnName + ‘,’);
\n}
\nsb.Append(Environment.NewLine);<\/p>\n

for (int j = 0; j < dt.Rows.Count; j++)
\n{
\nfor (int k = 0; k < dt.Columns.Count; k++)
\n{
\nsb.Append(dt.Rows[j][k].ToString() + ‘,’);
\n}
\nsb.Append(Environment.NewLine);
\n}
\nResponse.Write(sb.ToString());
\nResponse.End();
\n}<\/p>\n

Screenshot<\/b><\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

First You have to Create a grid view that will show details which you want to Export <asp:GridView ID=”GridView1″ CssClass=”footable” runat=”server” AutoGenerateColumns=”false” \u00a0 \u00a0 \u00a0…<\/p>\n","protected":false},"author":1,"featured_media":8610,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4521","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-others"],"menu_order":0,"_links":{"self":[{"href":"https:\/\/ngenioussolutions.com\/blog\/wp-json\/wp\/v2\/posts\/4521","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ngenioussolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ngenioussolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ngenioussolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ngenioussolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=4521"}],"version-history":[{"count":4,"href":"https:\/\/ngenioussolutions.com\/blog\/wp-json\/wp\/v2\/posts\/4521\/revisions"}],"predecessor-version":[{"id":9454,"href":"https:\/\/ngenioussolutions.com\/blog\/wp-json\/wp\/v2\/posts\/4521\/revisions\/9454"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ngenioussolutions.com\/blog\/wp-json\/wp\/v2\/media\/8610"}],"wp:attachment":[{"href":"https:\/\/ngenioussolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=4521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ngenioussolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=4521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ngenioussolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=4521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}