EasyXLS
http://forum.easyxls.com/

response object
http://forum.easyxls.com/viewtopic.php?f=5&t=165
Page 1 of 1

Author:  knugen99 [ Fri Apr 11, 2008 5:53 am ]
Post subject:  response object

Is it posible to open the open/save dialog instead of writing the file to the harddrive in ASP using easy_WriteExcelFile() ?

Author:  daniela [ Mon Apr 14, 2008 6:31 am ]
Post subject: 

If you are using ASP.NET, yes it is possible, see this post:
http://forum.easyxls.com/viewtopic.php?t=14

If you are using ASP (VBScript), you must fist save the file on the harddrive and later to open the file using this code:
--------------------------------------------------------
Dim strXlsFileName

strXlsFileName = Server.MapPath("<yourFileAndAppRelative>")
Dim objFileSystem
Set objFileSystem = Server.CreateObject("Scripting.FileSystemObject")

If objFileSystem.FileExists(strXlsFileName) Then
Dim objStream
Set objStream = Server.CreateObject("ADODB.Stream")
objStream.Open
objStream.Type = 1 'Binary Type
objStream.LoadFromFile strXlsFileName

Response.Clear
Response.ContentType = "application/octet-stream"
Response.AddHeader "Content-Disposition", "attachment; filename=" & strXlsFileName & ""

Response.BinaryWrite objStream.Read
objStream.close
Set objStream = Nothing

Response.End
End If
--------------------------------------------------------

Page 1 of 1 All times are UTC - 4 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/