Using a Stream to Download Excel Files

[Ali]

I need a functionality where my clients download Excel files and after they
do, I do some processing. Downloading is easily achieved using a anchor or
hyperlink tag, but that does not give me the full functionality I am after.
So, I came up with a way to download the files using a stream but after I
download the file and try to open it in Excel I get garbage.

This is the code I use for the download function. Please help if you have
any ideas or suggestions. Thanks in advance.

Ali
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As

System.EventArg s) Handles MyBase.Load

Dim path As String
Dim fs As New FileStream(path , FileMode.Open)
Dim byteRead As Integer

path = Server.MapPath( Request("fileTo Download"))

Response.ClearH eaders()
Response.Clear( )
Response.AddHea der("Content-Disposition", "attachment ; filename=" &
Request("fileTo Download").ToSt ring
Response.Conten tType = "applicatio n/XYZ"

byteRead = fs.ReadByte()

While byteRead <> -1
Response.Write( byteRead)
byteRead = fs.ReadByte()
End While

fs.Close()

End Sub

[Carl Prothman [MVP]]

Ali wrote:

I need a functionality where my clients download Excel files and
after they do, I do some processing. Downloading is easily achieved
using a anchor or hyperlink tag, but that does not give me the full
functionality I am after. So, I came up with a way to download the
files using a stream but after I download the file and try to open it
in Excel I get garbage.

Response.AddHea der("Content-Disposition", "attachment ; filename=" &

Ali,
You are missing the ContentType setting.
Response.Conten tType = "applicatio n/vnd.ms-excel"
http://support.microsoft.com/default...Product=aspnet

Also, please don't cross-post to so many newsgroups.

--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP

[Ali]

Thanks Carl and I am sorry for cross posting. I just did not know any
better.

Your response assumes that I need to create an excel file using ASP.NET.
The problem is that I already have the Excel file on the server. All I want
to do is download it. But not using the anchor nor the hyperlink tags.

Ali
http://support.microsoft.com/default...&Product=aspne
t
"Carl Prothman [MVP]" <ca****@spamcop .net> wrote in message
news:#9******** ******@TK2MSFTN GP11.phx.gbl...

Ali wrote:

I need a functionality where my clients download Excel files and
after they do, I do some processing. Downloading is easily achieved
using a anchor or hyperlink tag, but that does not give me the full
functionality I am after. So, I came up with a way to download the
files using a stream but after I download the file and try to open it
in Excel I get garbage.

Response.AddHea der("Content-Disposition", "attachment ; filename=" &

Ali,
You are missing the ContentType setting.
Response.Conten tType = "applicatio n/vnd.ms-excel"

http://support.microsoft.com/default...&Product=aspne
t
Also, please don't cross-post to so many newsgroups.

--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP

[Steve C. Orr [MVP, MCSD]]

To go along with Carl's answer, you can use the Response.Writef ile method.
Something like this should work:

Response.Clear( );
Response.Conten tType = "applicatio n/vnd.ms-excel"
Response.AddHea der("Content-Disposition","a ttachment;filen ame=myfile.xls" );
Response.WriteF ile("myfile.xls ");

Here's more info:
http://msdn.microsoft.com/library/de...efiletopic.asp
http://www.aspnetpro.com/NewsletterA...200309so_l.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
Hire top-notch developers at http://www.able-consulting.com

"Ali" <el********@hot mail.com> wrote in message
news:Oq******** ******@TK2MSFTN GP09.phx.gbl...

Thanks Carl and I am sorry for cross posting. I just did not know any
better.

Your response assumes that I need to create an excel file using ASP.NET.
The problem is that I already have the Excel file on the server. All I want to do is download it. But not using the anchor nor the hyperlink tags.

Ali
http://support.microsoft.com/default...&Product=aspne t
"Carl Prothman [MVP]" <ca****@spamcop .net> wrote in message
news:#9******** ******@TK2MSFTN GP11.phx.gbl...

Ali wrote:

I need a functionality where my clients download Excel files and
after they do, I do some processing. Downloading is easily achieved
using a anchor or hyperlink tag, but that does not give me the full
functionality I am after. So, I came up with a way to download the
files using a stream but after I download the file and try to open it
in Excel I get garbage.

Response.AddHea der("Content-Disposition", "attachment ; filename=" &

Ali,
You are missing the ContentType setting.
Response.Conten tType = "applicatio n/vnd.ms-excel"

http://support.microsoft.com/default...&Product=aspne t

Also, please don't cross-post to so many newsgroups.

--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP

[Ali]

Exactly what I needed Steve. Thanks Dude.
Ali
"Steve C. Orr [MVP, MCSD]" <St***@Orr.ne t> wrote in message
news:#7******** ******@TK2MSFTN GP12.phx.gbl...

To go along with Carl's answer, you can use the Response.Writef ile method.
Something like this should work:

Response.Clear( );
Response.Conten tType = "applicatio n/vnd.ms-excel"
Response.AddHea der("Content-Disposition","a ttachment;filen ame=myfile.xls" ); Response.WriteF ile("myfile.xls ");

Here's more info:
http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemwebh ttpresponseclas swritefiletopic .asp http://www.aspnetpro.com/NewsletterA..._l/asp200309so
_l.asp
--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
Hire top-notch developers at http://www.able-consulting.com

"Ali" <el********@hot mail.com> wrote in message
news:Oq******** ******@TK2MSFTN GP09.phx.gbl...

Thanks Carl and I am sorry for cross posting. I just did not know any
better.

Your response assumes that I need to create an excel file using ASP.NET.
The problem is that I already have the Excel file on the server. All I

want

to do is download it. But not using the anchor nor the hyperlink tags.

Ali

http://support.microsoft.com/default...&Product=aspne

t
"Carl Prothman [MVP]" <ca****@spamcop .net> wrote in message
news:#9******** ******@TK2MSFTN GP11.phx.gbl...

Ali wrote:
> I need a functionality where my clients download Excel files and
> after they do, I do some processing. Downloading is easily achieved
> using a anchor or hyperlink tag, but that does not give me the full
> functionality I am after. So, I came up with a way to download the
> files using a stream but after I download the file and try to open it > in Excel I get garbage.
>
> Response.AddHea der("Content-Disposition", "attachment ; filename=" &
>

Ali,
You are missing the ContentType setting.
Response.Conten tType = "applicatio n/vnd.ms-excel"

http://support.microsoft.com/default...&Product=aspne

t

Also, please don't cross-post to so many newsgroups.

--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP