Downloading excel file issue in ASP.Net using VB.Net

Question

5.00/5 (1 vote)

See more:

Hi,

I am writing a code to download an excel file from a location. The code is as follows:

SQL

Select Case strFileType
            Case "txt" : Response.ContentType = "text/plain"
            Case "xls", "csv" : Response.ContentType = "application/x-msexcel"
            Case Else
                Response.ContentType = "application/octet-stream"
        End Select
Response.AddHeader("content-disposition", "inline; filename=" & ReportFileName) Response.TransmitFile(reportPhysPath & ReportFileName)
       Response.End()

I pass the file server location in reportPhysPath and the file-name to be opened is passed in ReportFileName.

The Issue is:
When I download an excel file, it opens the file in excel with a name of "Download.aspx" , i.e. the name of the page where the function for downloading the file is written. The name of the excel file should be have been displayed. Suppose the file name in the file server is "mike1.xls", the file name while opening the page should also be "mike.xls" instead of "Download.aspx"

This causes an error message displayed when I try to download another file(mike2.xls) with the current file(mike1.xls) already open in Microsoft Office Excel 2007. The error message says that a file with name "Download.aspx" is already open.

Please help me solve this. Thanks in Advance :)

Posted 2-Sep-12 20:52pm

MikeRox89

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Devang Vaja · Answer 1 · 2012-09-02T21:00:00

VB

Response.Clear()
            Response.Buffer = True
            Response.AddHeader("content-disposition", "attachment;filename=ClientPayFollowUp " & DrpClient.Text.ToString & ".xls")
            Response.Charset = ""
            Response.Cache.SetCacheability(HttpCacheability.NoCache)
            Response.ContentType = "application/vnd.Excel"

this may help you....

MikeRox89 · Answer 2 · 2012-09-02T21:40:00

Solution 2

Hi Devang Vaja,

I tried to implement this code in my web application. The excel file is opening but the name while opening the code is still "download.aspx".

Can you please tell me whether you implemented this code on the download button code-behind directly or in the code-behind of a seperate web page.

Thanks !!!

Posted 2-Sep-12 21:40pm

MikeRox89

Comments

Devang Vaja 3-Sep-12 4:35am

i have tried it in code behind directly in .aspx.vb
in Protected Sub BtnExport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BtnExport.Click

MikeRox89 4-Sep-12 8:20am

Hi Devang,I got the solution to my problem. I was using
Response.AddHeader("content-disposition", "inline; filename=" & ReportFileName)

Modified this line to :
Response.AddHeader("content-disposition", "attachment; filename=" & ReportFileName)

Making this file as attachment solved the issue...

Thanks !!!! :)

Devang Vaja 4-Sep-12 8:22am

Your Welcome