Open a Excel file using ASP.NET

Question

5.00/5 (1 vote)

See more:

Hi,
I am working on an ASP.NET application using VS 2008. I have generated an Excel file through code and saved it on the server. I have used the following code.

MIDL

Response.ContentType = "Excel";
      Response.AppendHeader("Content-Disposition", "attachment; filename=Report.xls");
      Response.TransmitFile(Server.MapPath("~//Report.xls"));
      Response.End();

On my end, it works fine but when I publish the site on the server, it doesn't open the file. Instead it gives the message "Page not found".

Please help!

Posted 23-Aug-10 2:44am

Ashwani Dhiman

Updated 23-Aug-10 8:15am

Deeksha Shenoy

v3

Add a Solution

Comments

Dalek Dave 23-Aug-10 9:11am

Minor Edit for Grammar and Spelling.

Dalek Dave 23-Aug-10 9:12am

Reason for my vote of 5
Well phrased and presented question.

1 solution

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)

Sandeep Mewara · Answer 1 · 2010-08-23T02:58:00

Solution 1

The error lies here:

C#

Response.TransmitFile(Server.MapPath("~//Report.xls"));

The URL to access the file is not forming correctly. At times, after hosting, the path of files are a little different than while in development.

Try using this tip[^] for resolving the URLs.

Posted 23-Aug-10 2:58am

Sandeep Mewara

Updated 23-Aug-10 8:16am

v2

Comments

Dalek Dave 23-Aug-10 9:12am

Good Call! Have some points, helped me too!