unable to export to excell in asp.net

Question

0.00/5 (No votes)

See more:

I have to export the data to excel. When running on localhost, the code is working fine but its not working in the server, the page is getting reloaded without displaying any error message.

Posted 15-Mar-11 2:33am

Sonali Sabnam

Add a Solution

Comments

Albin Abel 15-Mar-11 8:43am

If you are using excel components to export, then server has to installed with excel components. As you are saying no error message, you may need to post relevant code snippets to get answer effectively

raju melveetilpurayil 15-Mar-11 9:18am

did you check the MIME type of excel already set in your IIS??

5 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)

**Dalek Dave** · Answer 1 · 2011-03-15T06:45:00

Solution 3

This[^] may help.

Posted 15-Mar-11 6:45am

Dalek Dave

fjdiewornncalwe · Answer 2 · 2011-03-15T13:08:00

Solution 4

If it works in local, but not in the server then it is clear that there is a configuration issue. Either you are missing dependencies, or your application configuration has errors. A wise way to find out what is going on is to turn on Failed Request Tracing for the given application and read the logs. There is sometimes valuable information in there doesn't appear in the response.

Posted 15-Mar-11 13:08pm

fjdiewornncalwe

Comments

Espen Harlinn 17-Mar-11 18:55pm

Good advice :) I guess he may run into some problems when (probably) using a desktop application from IIS on a server, even if it was installed on the server ...

Espen Harlinn · Answer 3 · 2011-03-15T13:21:00

Solution 5

You need something like EPPlus[^]

Excel is a desktop application - so it will work wonderfully during development, and quite possibly not be available on the server, and even if it is - it's usually not a good idea to use from IIS, as this is a windows service.

Best regards
Espen Harlinn

Posted 15-Mar-11 13:21pm

Espen Harlinn

_Ashish · Answer 4 · 2011-03-15T06:22:00

Solution 2

pl make sure that these lines are present in your code.

MIDL

Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");

or share your code.

Posted 15-Mar-11 6:22am

_Ashish

Raj Bose · Answer 5 · 2011-03-15T03:37:00

Solution 1

Use elmah to get the proper error

Posted 15-Mar-11 3:37am

Raj Bose