首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > .NET > VB Dotnet >

VB.NET 怎样导入Execl表!该怎么处理

2012-02-26 
VB.NET 怎样导入Execl表!!!怎样将数据库中的数据导入到Execl中我的程序中有Datagrid我想将Datagrid中的数

VB.NET 怎样导入Execl表!!!
怎样将数据库中的数据导入到Execl中
我的程序中有Datagrid   我想将Datagrid中的数据导入到Execl中
这该怎么编!!!!!!!



[解决办法]
Response.Clear()
Response.Buffer = True
Response.Charset = "GB2312 "
Response.AppendHeader( "Content-Disposition ", "attachment;filename=FileName.xls ")
Response.ContentEncoding = System.Text.Encoding.GetEncoding( "GB2312 ") '设置输出流为简体中文
Response.ContentType = "application/ms-excel "
Dim myCItrad As System.Globalization.CultureInfo = New System.Globalization.CultureInfo( "ZH-CN ", True)
Dim oStringWriter As System.IO.StringWriter = New System.IO.StringWriter(myCItrad)
Dim oHtmlTextWriter As System.Web.UI.HtmlTextWriter = New System.Web.UI.HtmlTextWriter(oStringWriter)
DataGrid1.RenderControl(oHtmlTextWriter)
Response.Write(oStringWriter.ToString())
Response.End()

热点排行