up
解决方案 »
- 本人刚学asp.net,求高手给一个简单的读取数据并分页显示的代码
- ajax给checkbox动态的绑定值
- css高度怎么ie6与ie8中不一样呢
- DataReader 问题!
- 为什么我机器启动时iis的default web site没起来?有人遇到这种情况过吗?
- 简单的自定义控件的例子 但运行错误 大虾帮俺一把
- ASP.NET的高手们来帮帮我啊!急急急急急!
- 各位老大:怎么扑捉浏览器的resize事件在线等?
- 图片显示问题
- 我想要一个时刻在走的时钟程序,谁能提供,80分即送!
- (一)、读出Excel然后用DG显示在网页上(二)、将Excel的数据导入到SQL 2K
- 高分收集 很有家的感觉的网站网址!
Response.ClearHeaders()
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("Content-Disposition", "inline;filename='你的文件名'" )
Response.WriteFile("你的excel文件地址")
Response.Flush()
Response.Close()这样就能写到页面上了
从datagrid中生成excel
'Dim oStringWriter As System.IO.StringWriter
'Dim oHtmlTextWriter As System.Web.UI.HtmlTextWriter
'Response.Clear()
'Response.Buffer = True
'Response.Charset = "GB2312"
'Response.AppendHeader("Content-Disposition", "attachment;filename=abc.xls")
'Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312")
'Response.ContentType = "application/ms-excel"
'Me.EnableViewState = False
'oStringWriter = New System.IO.StringWriter
'oHtmlTextWriter = New System.Web.UI.HtmlTextWriter(oStringWriter)
'DataGrid1.RenderControl(oHtmlTextWriter)
'Response.Write(oStringWriter.ToString())
'Response.End()如果你不想用url的话也可以用文件输出的方式
'Dim fullName As String 'fullName = "c:\\abc.xls"
'Response.ClearHeaders()
'Response.BufferOutput = False
'Response.ContentType = "application/octet-stream"
'Response.AppendHeader("Content-disposition", "attachment;filename=abc.xls")
'Response.WriteFile(fullName)
'Response.Flush()
'Response.End()