出口网格视图创先争优和保存Excel文件到文件夹 [英] Export Grid view to excel and save excel file to folder

问题描述

我要保存Excel电网view.I的出口数据已经写了其中code出口gridview的数据excel文件，但我不知道，如何保存导出的文件。

I want to save excel file which export data of grid view.I have written code to export gridview data to excel but i dont know, how to save exported file.

以下是我的code到GridView控件导出到Excel：

Following is my code to export gridview into excel :

 Response.Clear();
    Response.Buffer = true;
    Response.ContentType = "application/vnd.ms-excel";
    Response.AddHeader("content-disposition", "attachment;filename=MyFiles.xls");
    Response.Charset = "";
    this.EnableViewState = false;
    System.IO.StringWriter sw = new System.IO.StringWriter();
    System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
    gvFiles.RenderControl(htw);
    Response.Write(sw.ToString());
    Response.End();

请帮忙
并在此先感谢。

Please help and thanks in advance.

推荐答案

您可以这样做：

private void ExportGridView()
{
    System.IO.StringWriter sw = new System.IO.StringWriter();
    System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);

    // Render grid view control.
    gvFiles.RenderControl(htw);

    // Write the rendered content to a file.
    string renderedGridView = sw.ToString();
    System.IO.File.WriteAllText(@"C:\Path\On\Server\ExportedFile.xlsx", renderedGridView);
}

这篇关于出口网格视图创先争优和保存Excel文件到文件夹的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！