GridView 导出到 Word/Excel/PDF/CSV

最新推荐文章于 2024-10-16 10:59:03 发布
转载 最新推荐文章于 2024-10-16 10:59:03 发布 · 148 阅读 · 0
文章标签：

#数据库 #runtime #ui

本文介绍如何使用ASP.NET将数据从GridView导出为Excel和Word文档，并提供了完整的示例代码，包括设置响应头、使用HtmlTextWriter渲染内容等关键步骤。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

using System.Drawing;
using System.IO;
using System.Text;

protected void Button3_Click(object sender, EventArgs e)
    {
        Response.Clear();
        Response.Buffer = false;
        Response.Charset = "GB2312";
        Response.AppendHeader("Content-Disposition", "attachment;filename=pkmv_de.xls");
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
        Response.ContentType = "application/ms-excel";
        Response.Write("<meta http-equiv=Content-Type content=\"text/html; charset=GB2312\">");
        this.EnableViewState = false;
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
        GridView2.RenderControl(oHtmlTextWriter);
        Response.Write(oStringWriter.ToString());
        Response.End();
    }
public override void VerifyRenderingInServerForm(Control control)
    {
      
    }
  

或者


 
    /// 定义导出 Excel  Word  的函数
    private void Export(string FileType, string FileName)
    {
        Response.Charset = "GB2312";
        Response.ContentEncoding = System.Text.Encoding.UTF8;
        Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
        Response.ContentType = FileType;
        this.EnableViewState = false;
        StringWriter tw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(tw);
        GridView1.RenderControl(hw);
        Response.Write(tw.ToString());
        Response.End();
    }

    /// 此方法必重写，否则会出错
    public override void VerifyRenderingInServerForm(Control control)
    {
    }

     protected void Button1_Click(object sender, EventArgs e)   // Excel
    {
        Export("application/ms-excel", "Employee information.xls");
    }

    protected void Button2_Click(object sender, EventArgs e)  //Word
    {
        //Export("application/ms-excel", "Employee.doc");
        Export("application/ms-word", "员工信息.doc");//都可以
    }




点击 下载 按钮

protected  void  ButtonDownloadFile( string  fileUrlPath)
    {
         // 用戶端的物件
        System.Net.WebClient wc  =  new  System.Net.WebClient();
         byte [] file  =  null ;
         try
        {
             // 用戶端下載檔案到byte陣列
            file  =  wc.DownloadData(fileUrlPath);
        }
         catch  (Exception ex)
        {
            HttpContext.Current.Response.Write( " ASP.net禁止下載此敏感檔案(通常為：.cs、.vb、微軟資料庫mdb、mdf和config組態檔等)。<br/>檔案路徑： "  +  fileUrlPath  +  " <br/>錯誤訊息： "  +  ex.ToString());
             return ;
        }
        HttpContext.Current.Response.Clear();
         string  fileName  =  System.IO.Path.GetFileName(fileUrlPath);
         // 跳出視窗，讓用戶端選擇要儲存的地方                          // 使用Server.UrlEncode()編碼中文字才不會下載時，檔名為亂碼
        HttpContext.Current.Response.AddHeader( " content-disposition " ,  " attachment;filename= "  +  HttpContext.Current.Server.UrlEncode(fileName));
         // 設定MIME類型為二進位檔案
        HttpContext.Current.Response.ContentType  =  " application/octet-stream " ;

         try
        {
             // 檔案有各式各樣，所以用BinaryWrite
            HttpContext.Current.Response.BinaryWrite(file);

        }
         catch  (Exception ex)
        {
            HttpContext.Current.Response.Write( " 檔案輸出有誤，您可以在瀏覽器的URL網址貼上以下路徑嘗試看看。<br/>檔案路徑： "  +  fileUrlPath  +  " <br/>錯誤訊息： "  +  ex.ToString());
             return ;
        }

         // 這是專門寫文字的
         // HttpContext.Current.Response.Write();
        HttpContext.Current.Response.End();
    }

 



1.上傳Excel檔。2. ASP.net讀Excel資料，然後Insert into Table。3.把上傳的Excel檔宰掉，避免硬碟空間不夠。

using  System;
 using  System.Collections.Generic;
 using  System.Web;
 /* **Copy Start** */

// 引用Microsoft Excel相關參考
using  Microsoft.Office.Interop;
 using  Microsoft.Office.Interop.Excel;
 // 移機時記得Bin底下的Microsoft.Office.Interop.Excel.dll和office.dll等，Excel相關dll也要Copy過去
/* **Copy End** */

public   class  ExcelImport :System.Web.UI.Page
{
     /* **Copy Start** */
     // 畫面上要先擺一個FileUpload控制項

     /* ** Excel Interop reference ** */
    Microsoft.Office.Interop.Excel.Application xlApp  =   null ;
    Workbook wb  =   null ;
    Worksheet ws  =   null ;
    Range aRange  =   null ;
     // *******************************/

     // 要上傳Excel檔的Server端 檔案總管目錄
     string  upload_excel_Dir  =   @" D:\web\myWeb\ " ;


     #region  匯入EXCEL
     // 按鈕Click事件
     protected   void  lbtOK_Click( object  sender, EventArgs e)
    {
         string  excel_filePath  =   "" ;
         try
        {
            excel_filePath  =  SaveFileAndReturnPath(); // 先上傳EXCEL檔案給Server

             if  ( this .xlApp  ==   null )
            {
                 this .xlApp  =   new  Microsoft.Office.Interop.Excel.Application();
            }
             // 打開Server上的Excel檔案
             this .xlApp.Workbooks.Open(excel_filePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
             this .wb  =  xlApp.Workbooks[ 1 ]; // 第一個Workbook
             this .wb.Save();

             // 從第一個Worksheet讀資料
            SaveOrInsertSheet(excel_filePath, (Worksheet)xlApp.Worksheets[ 1 ]);           
            ClientScript.RegisterClientScriptBlock( typeof (Page),  " 匯入完成 " ,  " alert('匯入完成'); " ,  true );           
        }
         catch  (Exception ex)
        {
             throw  ex;
        }
         finally
        {
            xlApp.Workbooks.Close();
            xlApp.Quit();
             try
            {
                 // 刪除 Windows工作管理員中的Excel.exe 處理緒.
                System.Runtime.InteropServices.Marshal.ReleaseComObject( this .xlApp);
                System.Runtime.InteropServices.Marshal.ReleaseComObject( this .ws);
                System.Runtime.InteropServices.Marshal.ReleaseComObject( this .aRange);
            }
             catch  { }
             this .xlApp  =   null ;
             this .wb  =   null ;
             this .ws  =   null ;
             this .aRange  =   null ;


             // 是否刪除Server上的Excel檔
             bool  isDeleteFileFromServer  =   true ;
             if  (isDeleteFileFromServer)
            {
                System.IO.File.Delete(excel_filePath);
            }
            GC.Collect();
        }
    }
     #endregion

     #region  儲存EXCEL檔案給Server
     private   string  SaveFileAndReturnPath()
    {
         string  return_file_path  =   "" ; // 上傳的Excel檔在Server上的位置
         if  (FileUpload1.FileName  !=   "" )
        {
            return_file_path  =  System.IO.Path.Combine( this .upload_excel_Dir, Guid.NewGuid().ToString()  +   " .xls " );

            FileUpload1.SaveAs(return_file_path);
        }
         return  return_file_path;
    }
     #endregion

     #region  把Excel資料Insert into Table
     private   void  SaveOrInsertSheet( string  excel_filename,Worksheet ws)
    {

         // 要開始讀取的起始列(微軟Worksheet是從1開始算)
         int  rowIndex  =   1 ;

         // 取得一列的範圍
         this .aRange  =  ws.get_Range( " A "   +  rowIndex.ToString(),  " C "   +  rowIndex.ToString());

         // 判斷Row範圍裡第1格有值的話，迴圈就往下跑
         while  ((( object [,]) this .aRange.Value2)[ 1 ,  1 ]  !=   null )
        {
             // 範圍裡第1格的值
             string  cell1  =  (( object [,]) this .aRange.Value2)[ 1 ,  1 ]  !=   null   ?  (( object [,]) this .aRange.Value2)[ 1 ,  1 ].ToString() :  "" ;

             // 範圍裡第2格的值
             string  cell2  =  (( object [,]) this .aRange.Value2)[ 1 ,  2 ]  !=   null   ?  (( object [,]) this .aRange.Value2)[ 1 ,  2 ].ToString() :  "" ;

             // 範圍裡第3格的值
             string  cell3  =  (( object [,]) this .aRange.Value2)[ 1 ,  3 ]  !=   null   ?  (( object [,]) this .aRange.Value2)[ 1 ,  3 ].ToString() :  "" ;
            
             // 抓出來後Insert into Table...(略
             // 往下抓一列Excel範圍
            rowIndex ++ ;
             this .aRange  =  ws.get_Range( " A "   +  rowIndex.ToString(),  " C "   +  rowIndex.ToString());
        }
    }
     #endregion

     /* **Copy End** */
}





打开word

using System.IO;
using System.Text;

protected void open()
    {
        string fileName = "temp.doc";
        if (fileName != null)
        {
            string filePath = @"images/";
            FileStream MyFileStream = new FileStream(filePath + fileName, FileMode.Open);
            long FileSize = MyFileStream.Length;
            byte[] Buffer = new byte[(int)FileSize];
            MyFileStream.Read(Buffer, 0, (int)FileSize);
            MyFileStream.Close();
            Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(fileName, Encoding.UTF8).ToString());
            Response.ContentType = "application/ms-word";
            Response.BinaryWrite(Buffer);
            Response.End();
        }
        else
        {
            Response.Write("文件不存在！");
        }
    }







protected void btnExportWord_Click(object sender, EventArgs e)

{
    Response.Clear();
    Response.Buffer = true;
    Response.AddHeader("content-disposition",     "attachment;filename=GridViewExport.doc");
    Response.Charset = "";
    Response.ContentType = "application/vnd.ms-word ";
    StringWriter sw= new StringWriter();
    HtmlTextWriter hw = new HtmlTextWriter(sw);
    GridView1.AllowPaging = false;
    GridView1.DataBind();
    GridView1.RenderControl(hw);
    Response.Output.Write(sw.ToString());
    Response.Flush();
    Response.End();
}







protected void btnExportExcel_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
GridView1.AllowPaging = false;
GridView1.DataBind();
//Change the Header Row back to white color
GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF");  

//Apply style to Individual Cells
GridView1.HeaderRow.Cells[0].Style.Add("background-color", "green");
GridView1.HeaderRow.Cells[1].Style.Add("background-color", "green");
GridView1.HeaderRow.Cells[2].Style.Add("background-color", "green");
GridView1.HeaderRow.Cells[3].Style.Add("background-color", "green");  

for (int i = 0; i < GridView1.Rows.Count;i++ )
{
    GridViewRow row = GridView1.Rows[i];
    //Change Color back to white
    row.BackColor = System.Drawing.Color.White;
    //Apply text style to each Row
    row.Attributes.Add("class", "textmode");
    //Apply style to Individual Cells of Alternating Row
    if (i % 2 != 0)
    {
        row.Cells[0].Style.Add("background-color", "#C2D69B");
        row.Cells[1].Style.Add("background-color", "#C2D69B");
        row.Cells[2].Style.Add("background-color", "#C2D69B");
        row.Cells[3].Style.Add("background-color", "#C2D69B"); 
    }
}

GridView1.RenderControl(hw);  

//style to format numbers to string
string style = @"<style> .textmode { } </style>";
Response.Write(style);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}





using iTextSharp.text;
using iTextSharp.text.pdf;
using iTextSharp.text.html;
using iTextSharp.text.html.simpleparser;

protected void btnExportPDF_Click(object sender, EventArgs e)
{
    Response.ContentType = "application/pdf";
    Response.AddHeader("content-disposition",      "attachment;filename=GridViewExport.pdf");
    Response.Cache.SetCacheability(HttpCacheability.NoCache);
    StringWriter sw = new StringWriter();
    HtmlTextWriter hw = new HtmlTextWriter(sw);
    GridView1.AllowPaging = false;
    GridView1.DataBind();
    GridView1.RenderControl(hw);
    StringReader sr = new StringReader(sw.ToString());
    Document pdfDoc = new Document(PageSize.A4, 10f,10f,10f,0f);
    HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
    PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
    pdfDoc.Open();
    htmlparser.Parse(sr);
    pdfDoc.Close();
    Response.Write(pdfDoc);
    Response.End();
}



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();
}

public override void VerifyRenderingInServerForm(Control control)

{
    /* Verifies that the control is rendered */
}




Excel 与 Access 互导入 with ASP.NET

string Access = Server.MapPath("App_Data/contacts.mdb");
string Excel = Server.MapPath("App_Data/Book1.xls");
string connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Excel +";Extended Properties=Excel 8.0;";
using (OleDbConnection conn = new OleDbConnection(connect))
{
  using (OleDbCommand cmd = new OleDbCommand())
  {
    cmd.Connection = conn;
    cmd.CommandText = "INSERT INTO [MS Access;Database=" + Access + "].[Persons] SELECT * FROM [Sheet1$]";
    conn.Open();
    cmd.ExecuteNonQuery();
  }
}




string Access = Server.MapPath("App_Data/contacts.mdb");
string Excel = Server.MapPath("App_Data/Book1.xls");
string connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Excel +";Extended Properties=Excel 8.0;";
using (OleDbConnection conn = new OleDbConnection(connect))
{
  using (OleDbCommand cmd = new OleDbCommand())
  {
    cmd.Connection = conn;
    cmd.CommandText = "SELECT * INTO [MS Access;Database=" + Access + "].[New Table] FROM [Sheet1$]";
    conn.Open();
    cmd.ExecuteNonQuery();
  }
}




import data from excel sheet to griedview directly.

string Access = Server.MapPath("App_Data/contacts.mdb");
string Excel = Server.MapPath("App_Data/Book1.xls");
string connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Excel + ";Extended Properties=Excel 8.0;";
using (OleDbConnection conn = new OleDbConnection(connect))
{
using (OleDbCommand cmd = new OleDbCommand())
{
cmd.Connection = conn;
cmd.CommandText = "SELECT * FROM [Sheet1$]";
conn.Open();
OleDbDataReader dr = cmd.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
conn.Close();

}
}



Reading Text files into Access with ASP.NET


/*
FirstName, SecondName
Joe,Bloggs
Fred,Bassett
Archie,Falls
Doris,Knight
Gladys,Day
*/

string connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Contacts.mdb";
OleDbConnection conn = new OleDbConnection(connect);
string path = Server.MapPath("App_Data");
string query = "INSERT INTO Persons (FirstName, SecondName) SELECT FirstName, SecondName FROM
[Text;DATABASE=" + path + ";].[test.txt]";
OleDbCommand cmd = new OleDbCommand(query, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

 

 

Export GridView with Images from database to Word, Excel and PDF Formats

http://www.aspsnippets.com/post/2009/04/22/Export-GridView-with-Images-from-database-to-Word-Excel-and-PDF-Formats.aspx

 

Read and Import Excel Sheet into ASP.Net GridView Control

http://www.aspsnippets.com/post/2009/06/04/Read-and-Import-Excel-Sheet-into-ASPNet-GridView-Control.aspx

asp.net Gridview Export PDF,Word,Excel,Csv等等(GridView导出为Excel,word,pdf,csv)源代码
09-11
asp.net Gridview Export PDF,Word,Excel,Csv等等(GridView导出为Excel,word,pdf,csv)源代码 C#,VB.NET
GridView导出到Word
leejin_521的专栏
04-12 466
//override掉这个方法     public override void VerifyRenderingInServerForm(Control control)     {         //注释掉下面的代码，否则在asp.net2.0下会报错（注：GridView是asp.net 2.0下的控件，1.1下一些控件也可以导出成Excel或者Word）         //bas
DateGridView导出到csv格式的Excel
霜叶红于二月花
09-26 1368
#region DateGridView导出到csv格式的Excel         ///             /// 常用方法，列之间加\t，一行一行输出，此文件其实是csv文件，不过默认可以当成Excel打开。            ///
如何将GridView数据导出到CSV
IT与开发人员的地盘
05-27 638
语言：ASP.net 平台：带有ASP.net的Visual Studio 2008 技术：用于ASP.net 级别：初学者 介绍 1.将gridview添加到aspx文件中 2.在aspx文件中添加一个按钮，并将名称命名为“ btnExportToCSV” 3.在aspx.cs文件中编写代码 usingSystem; usingSystem.Collections.Gener...
GridView生成.csv文件
11-26 636
string filename=DateTime.Now.ToString()+".csv";int rowCount = gridViewDL.Rows.Count + 1;int colCount = gridViewDL.Columns.Count;string[] arr = new string[colCount];StringWriter fileWriter = new StringWriter();//标题设置arr[0]="";arr[1]="";arr[2]="";fileWriter.
实现GridView导出PDF、Word、Excel及CSV功能的源代码
将GridView导出为PDF格式的常见方法包括： - 利用iTextSharp等库将HTML内容转换为PDF。 - 使用第三方服务如PDFCreator等，通过服务器端生成PDF文件然后提供下载。 - 利用报表工具或类似工具导出GridView为PDF。 ###...
C#与VB.NET实现的GridView导出工具源代码
标题中的“asp.net Gridview Export PDF, Word, Excel, Csv等等(GridView导出为Excel, word, pdf, csv)源代码”指出了本文档将讨论的内容是关于如何将ASP.NET中的GridView控件导出为常见的文件格式，包括PDF、Word、...
GirdView实现导出word，pdf，XML,XLS,cvs
06-20
在实际应用中，我们有时需要将GridView中的数据导出为不同的文件格式，例如Word、PDF、XML、XLS（Excel）以及CSV。下面将详细介绍如何实现这些功能。 首先，导出到Word格式。ASP.NET可以通过使用第三方库如NPOI或...
DevExpress报表的数据绑定及打印
热门推荐
TMajier的博客
09-23 2万+
Devexpress的报表功能十分强大！支持自动分页，可以导出为PDF,WORD,RTF等众多格式，支持打印预览！ 声明：此项目使用前需安装devexpress控件。 近来项目需求，需要做出来一个班级的二维码打印。以下示例将展示devreport 如何实现类似于Datalist的数据绑定及样式布局。效果图如下： 新建 >DXperience v12.2 Report Class，命名
深入掌握GridView控件的操作技巧
最新发布
weixin_32673065的博客
10-16 1452
本文还有配套的精品资源，点击获取 简介：GridView是*** Web Forms中展示数据的重要控件，本DEMO将深入讲解其核心操作，包括设置主键索引、分页排序、实现增删改操作、多层嵌套显示、导入导出功能以及如何与其他控件结合增强用户体验。掌握这些技巧将帮助开发者在实际应用中构建高效的数据管理界面。 1. GridView核心功能概述 1.1 界面展示与...
C# | 导出DataGridView中的数据到Excel、CSV、TXT
猿长大人
04-11 6989
导出中的数据到是开发中经常遇到的需求。而将DataGridView中的数据先转换为DataTable格式，再进行导出，是一种常见的实现方式。本文将介绍如何将DataGridView中的数据转换为DataTable格式，并提供将DataTable转换为Excel、CSV、TXT三种格式的例子。将DataGridView中的数据转换为DataTable格式，有助于我们更方便地对数据进行处理和操作。
Export GridView with Images to Word Excel and PDF Formats in ASP.Net
apple443322的博客
04-01 192
In one of my previous articles I explained Export GridView with Images from database to Word, Excel and PDF Formats In this article I am explaining how to Export GridView to Microsoft Word, Mi...
GridView Export to Excel
weixin_30338481的博客
04-22 134
/// <summary> /// GridView Export to Excel /// </summary> /// <param name="gv">GridView</param> public void GridViewToExcel(System.Web.UI...
Export GridView to Excel
weixin_30748995的博客
07-17 142
Original link:http://mattberseth.com/blog/2007/04/export_gridview_to_excel_1.html usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.IO;usingSystem.Web;usingSystem.Web.Security;...
将数据从DataGridView中导出成CSV格式文件
程序猿GG
09-29 3586
将数据从DataGridView中导出成CSV格式文件, 完整代码如下:using System;using System.Collections.Generic;using System.Text;using System.Windows.Forms;using System.IO;namespace Statistic.BaseClass{    class DataExport   
GridView如何实现PDF/Word/Excel导出功能
从给定的文件信息中，我们可以提取出三个重要的知识点，分别涉及-gridview、PDF、WORD和EXCEL的导出操作。下面我将对这三个知识点进行详细阐述。 ### 知识点一：GridView控件 #### GridView控件概述 GridView是一...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值