<%
Response.AddHeader "Content-Disposition", "filename=abc.xsl")
Response.ContentType="application/octet-stream"
Response.BinaryWrite streamReadExcel '用ado.stream 把excel文件读成二进制保存在这个变量里
%>
Response.AddHeader "Content-Disposition", "filename=abc.xsl")
Response.ContentType="application/octet-stream"
Response.BinaryWrite streamReadExcel '用ado.stream 把excel文件读成二进制保存在这个变量里
%>
没有用,提示如下:
--------------------
错误类型:
Response 对象, ASP 0106 (0x80020005)
遇到未处理的数据类型。
----------------------------------
请问这个怎么来实现呢?
我不懂啊!还请指点!
Set objAdoStream = Server.CreateObject("ADODB.Stream")
objAdoStream.Open ' Set as binary
objAdoStream.Type = 1 ' load in the file
objAdoStream.LoadFromFile(sFilePath) 'xsl物理路径 streamReadExcel = objAdoStream.Read objAdoStream.Close
Set objAdoStream = Nothing
<%
call WriteToTextFile(文件url,文件内容,"UTF-8")
Response.Redirect 文件url
%>
Sub WriteToTextFile (FileUrl,byval Str,CharSet)
set stm=server.CreateObject("adodb.stream")
stm.Type=2 '以本模式读取
stm.mode=3
stm.charset=CharSet
stm.open
stm.WriteText str
stm.SaveToFile server.MapPath(FileUrl),2
stm.flush
stm.Close
set stm=nothing
end Sub