导出gridview数据为CSV文件

本文关键字：CSV 文件 数据 gridview 导出 | 更新日期: 2023-09-27 18:01:50

我在ASP中有一个gridview控件。. Net 2.0和我需要导出这个gridview数据成CSV文件。

我已经绑定这个gridview与数据集。在将数据集绑定到gridview后，我已经在gridview数据中做了一些更改，例如如果我在数据集中得到0，那么我在gridview中显示0为"已启动"，如果我在数据集中得到1，那么我在gridview中显示1为"未启动"。

所以，我不能直接使用dataset进行导出。我需要的是……我想要的代码(在c#中)导出我的gridview数据(不是数据集的数据)到CSV文件

导出gridview数据为CSV文件

试试下面的代码，我已经用过很多次了。它将直接从gridview导出数据到代码中指定的csv文件。

protected void btnExportCSV_Click(object sender, EventArgs e)
{
    Response.Clear();
    Response.Buffer = true;
    Response.AddHeader("content-disposition",
     "attachment;filename=GridViewExport.csv");
    Response.Charset = "";
    Response.ContentType = "application/text";
    GridView1.AllowPaging = false;
    GridView1.DataBind();
    StringBuilder sb = new StringBuilder();
    for (int k = 0; k < GridView1.Columns.Count; k++)
    {
        //add separator
        sb.Append(GridView1.Columns[k].HeaderText + ',');
    }
    //append new line
    sb.Append("'r'n");
    for (int i = 0; i < GridView1.Rows.Count; i++)
    {
        for (int k = 0; k < GridView1.Columns.Count; k++)
        {
            //add separator
            sb.Append(GridView1.Rows[i].Cells[k].Text + ',');
        }
        //append new line
        sb.Append("'r'n");
    }
    Response.Output.Write(sb.ToString());
    Response.Flush();
    Response.End();
}

更多信息请访问这里希望对你有所帮助

首先感谢Devjosh的好答案，我修改了AutoGenerateColumns=true和AllowSorting=true的gridviews。另外，我从数据中剥离了任何返回的逗号，以确保csv文件没有损坏。

private void ExportReport()
{
    // set the resulting file attachment name to the name of the report...
    string fileName = "test";
    Response.Clear();
    Response.Buffer = true;
    Response.AddHeader("content-disposition", "attachment;filename=" + fileName + ".csv");
    Response.Charset = "";
    Response.ContentType = "application/text";
    System.Text.StringBuilder sb = new System.Text.StringBuilder();
    // Get the header row text form the sortable columns
    LinkButton headerLink = new LinkButton();
    string headerText = string.Empty;
    for (int k = 0; k < gvReport.HeaderRow.Cells.Count; k++)
    {
        //add separator
        headerLink = gvReport.HeaderRow.Cells[k].Controls[0] as LinkButton;
        headerText = headerLink.Text;
        sb.Append(headerText + ",");
    }
    //append new line
    sb.Append("'r'n");
    for (int i = 0; i < gvReport.Rows.Count; i++)
    {
        for (int k = 0; k < gvReport.HeaderRow.Cells.Count; k++)
        {
            //add separator and strip "," values from returned content...
            sb.Append(gvReport.Rows[i].Cells[k].Text.Replace(",", "") + ",");
        }
        //append new line
        sb.Append("'r'n");
    }
    Response.Output.Write(sb.ToString());
    Response.Flush();
    Response.End();
}

private void ExportGridToCSV()
        {            
            Response.Clear();
            Response.Buffer = true;
            Response.AddHeader("content-disposition", "attachment;filename=Employee.csv");
            Response.Charset = "";
            Response.ContentType = "application/text";
            GridEmployee.AllowPaging = false;
            GridEmployee.DataBind();
            StringBuilder columnbind = new StringBuilder();
            for (int k = 0; k < GridEmployee.Columns.Count; k++)
            {
                columnbind.Append(GridEmployee.Columns[k].HeaderText + ',');
            }
            columnbind.Append("'r'n");
            for (int i = 0; i < GridEmployee.Rows.Count; i++)
            {
                for (int k = 0; k < GridEmployee.Columns.Count; k++)
                {
                    columnbind.Append(GridEmployee.Rows[i].Cells[k].Text + ',');
                }
                columnbind.Append("'r'n");
            }
            Response.Output.Write(columnbind.ToString());
            Response.Flush();
            Response.End();
        }

在按钮点击事件中调用这个方法。有关更多代码，请单击链接导出gridview数据为CSV文件

我希望这对你有帮助。谢谢。

相关文章：