How to Create Excel Files that do not reside on Web Server??

[Enya]

I have already generated an Excel file from an ASP page. But this file resides on the web server. I dont want this file to reside on the web server. Can anyone help me with any suggestions??

Thanks in advance.

 

[vasah20]

you could do two things. You could

A: attach the excel file to an email and then email it to whomever is requesting it.

example using CDONTS. You might have to modify depending on what email component you have access to:

dim emObj, xlFileLoc
xlFileLoc = server.mappath("someworksheet.xls")
set emObj = server.createobject("cdonts.newmail")
emObj.From = "you@yourdomain.com"
emObj.To = "towhom@thatdomain.com"
emObj.Subject = "Your Excel file"
emObj.Body = "Here is the excel file that you created!"
emObj.AttachFile xlFileLoc, "someworksheet.xls"
emObj.Send
set emObj = nothing

or

B: (I'm not sure if this will work though)
Do a response.redirect to the actual Excel spreadsheet. Since the Response.Redirect makes the user's browser redirect to the file you specify, there's a chance that the User will be given a prompt to download the Excel file. Again, I'm not sure if this will work or not, but if my understanding of the Response object is correct, theoretically it should.

good luck

 

[hblackorby]

You can totally create the Excel file as a text string via ASP and then BinaryWrite it to a browser. This way the Excel document isn't really a file at all. You have to create them using XML though or using Response.ContentType (an easier solution) to send the document out in an Excel ContentType. Note that the examples are in Word, but you should be able to translate them to work in Excel too.

For more info try these:

ASP to create Word files and sent them to the client

http://www.asptoday.com/articles/19990825.htm

ASP and XML to create Word Files

http://www.asptoday.com/articles/20001215.htm

ASP using MIME Types to sent files out as MS Word or other

http://www.asptoday.com/articles/20000222.htm

Common MIME Types (reference)

http://www.asptoday.com/articles/images/20000222_1.htm

Harold Blackorby
hblackorby@scoreinteractive.com
St. Louis, MO

 

[Enya]

Thanks for all the suggestions.