private void excelexport() { Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.csv"); Response.Charset = ""; Response.ContentType = "application/text"; gridviewsta.AllowPaging = false; gridviewsta.DataBind(); StringBuilder sb = new StringBuilder(); for (int k = 0; k < gridviewsta.Columns.Count; k++) { //add separator sb.Append(gridviewsta.Columns[k].HeaderText + ','); } //append new line sb.Append("\r\n"); for (int i = 0; i < gridviewsta.Rows.Count; i++) { for (int k = 0; k < gridviewsta.Columns.Count; k++) { //add separator sb.Append(gridviewsta.Rows[i].Cells[k].Text + ','); } //append new line sb.Append("\r\n"); } Response.Output.Write(sb.ToString()); Response.Flush(); Response.End(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)