DataGrid导出excel和word的例子.docx

DataGrid导出excel和word的例子导出Word：private void Button13_Click(object sender, System.EventArgs e){this.Datagrid4.Visible=true;Response.Clear(); Response.Buffer= true; Response.Charset=GB2312;Response.AppendHeader(Content-Disposition,attachment;filename=File1.doc);Response.ContentEncoding=System.Text.Encoding.GetEncoding(GB2312);????????? Response.ContentType = application/ms-word;????????? this.Datagrid4.EnableViewState = false;????????? System.IO.StringWriteroStringWriter = new System.IO.StringWriter(); ????????? System.Web.UI.HtmlTextWriteroHtmlTextWriter = new System.Web.UI.HtmlTextWriter? (oStringWriter);this.Datagrid4.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString());Response.End();}导出Excel：private void OutExcel(DataGrid dg ,string name,string type){?? dg.Visible=true;Response.Clear(); Response.Buffer= true; Response.Charset=GB2312;Response.AppendHeader(Content-Disposition,name);Response.ContentEncoding=System.Text.Encoding.GetEncoding(GB2312);Response.ContentType = type;dg.EnableViewState = false;System.IO.StringWriteroStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriteroHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);dg.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString());Response.End();}C#.net中如何将DataGrid的数据保存在Excel 中啊.? 这是我写的一个类，可以直接把一个Dataset对象放到Excel的指定位置，需要引用Interop.Excel.dllusing System;using System.Data;using System.Xml;using Microsoft.VisualBasic;using Excel;using System.Reflection;using System.IO;namespace Soft1000.Libs.EXCEL{public class ExcelEditor{private Application app;private string mFilename;private Workbook wb;private Workbooks wbs;//private Worksheet ws;/// summary/// 打开Excel文件对象/// /summary/// param name=FileName文件名,包含磁盘路径/parampublic void Open(string FileName){app = new Excel.ApplicationClass();wbs = this.app.Workbooks;wb = this.wbs.Open(FileName, Missing.value, Missing.value, Missing.value, Missing.value, Missing.value, Missing.value, Missing.value, Missing.value,