How to download excel file as a prompt in VB.NET?

Question

0.00/5 (No votes)

See more:

.NET2.0

Hello Friends,

I am trying to download an excel file template from my root Directory and the allowing user to edit the same and then upload the data entered into the modified excel sheet. But whenever i am downloading the template excel file, on opening it it give the following error: "Excel cannot open the file 'XYZ.xlsx' bacause the file format or file format or the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.".

Although the file extension (.xlsx) is fine and the file is obviously not corrupted as it is opening manually. Also, I would like to mention here that the same code is running just fine on another code file.

Kindly help me to resolve this issue.

Regards
Varun

What I have tried:

Dim strFilePath As String = Server.MapPath("~/Templates/XYZ.xlsx")
        Response.ContentType = "Application/xlsx"
        Response.AppendHeader("Content-Disposition", "attachment; filename=BankDetailTDS.xlsx")
        Response.TransmitFile(strFilePath)
        Response.[End]()

Posted 19-Apr-20 1:50am

Varun Sareen

Updated 19-Apr-20 2:39am

Add a Solution

Comments

Richard Deeming 21-Apr-20 10:19am

NB: That's not the correct content type. You should be using:
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Common MIME types - HTTP | MDN[^]

Varun Sareen 22-Apr-20 12:37pm

Ok Richard noted.

Thanks
Varun

2 solutions

Solution 1

We can't help you here: the most likely thing is that the file is corrupted, or you are trying to open it before it's fully downloaded, or ... There are a huge number of possible reasons.

Start by doing a binary file compare between the original template file and the downloaded file: if they are different then it's a transmission problem of some form. If they are the same, it's an excel problem of some form.

But we can;t help you with this one: we don't have any access to your systems or their files, so we really have no idea.

Posted 19-Apr-20 2:01am

OriginalGriff

Comments

Varun Sareen 19-Apr-20 8:13am

ok thanks. But i assured that the file is actually not corrupted and the same code is running on different page.

Add a Solution

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

Varun Sareen · Accepted Answer · 2020-04-19T02:40:00

Solution 2

I found the solution to it. The issue was due to another Response.Write() code was written on Page load due to which the issue in excel file was coming.

Response.Write("<script language='javascript'>" & Chr(10))
Response.Write("</script>" & Chr(10))

The moment I commented the same, it worked.

Posted 19-Apr-20 2:40am

Varun Sareen

Comments

Patrice T 19-Apr-20 10:11am

If question is solved, accept the solution to close the question.
Use Accept answer to close the question.

How to download excel file as a prompt in VB.NET?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to download excel file as a prompt in VB.NET?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us