datagrid显示的数据导入到excel，该如何做
小妹刚学c#做应用程序，现在遇到一个问题，是把datagrid显示的数据导入到excel，该如何做，急

[解决办法]
技术贴呀
用dataset 导入 excel的方法导
就是调用excel这个库 来做 网上有不少例子 你搜下
[解决办法]
protected void ExportExcel(DataGrid dtgList, string strFileName){DataTable dt = (DataTable)this.Session[ "GridToExcel "];if (dt==null) return;Response.Clear(); Response.Buffer = true; Response.Charset = "gb2312 ";Response.AppendHeader( "Content-Disposition ", "online; filename= " + this.GetFileName(strFileName) + ".xls ");Response.ContentEncoding = System.Text.Encoding.GetEncoding( "gb2312 ");Response.ContentType = "application/ms-excel ";EnableViewState = false;System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo( "zh-CN ",true);System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);dtgList.AllowPaging = false;//dtgList.DataSource = dt;//dtgList.DataBind();dtgList.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString());Response.Buffer = false; Response.End();}
[解决办法]
http://dotnet.aspx.cc/article/8a4cbf47-b888-4832-3389-ed3a3a3c8aab/read.aspx

[解决办法]
介绍你一个组件：Aspose.Excel.dll，可以完成导入Excel，挺方便的。没几行代码！
[解决办法]
http://blog.csdn.net/ChengKing/archive/2006/08/27/1128385.aspx
http://blog.csdn.net/ChengKing/archive/2006/08/10/1045853.aspx
http://blog.csdn.net/ChengKing/archive/2005/11/29/539514.aspx