Creating/Saving Excel file gives run time error

Question

0.00/5 (No votes)

See more:

Creating and saving Excel file in server and that file transferring to the client machine is working fine in local machine. But after publishing the website, when we create that excel file gives run time error.

Because of it's working fine in local as well as in server, we can't recognize the specific error.

I just need immediate help...

OP comment:

Thanx for your response....
It works fine in local as well as server but after publishing website when a client vistis that site and try to download that excel file it shows only Runtime Error. Actually my work is i am converting a dataset to excel file and saves in server then i am trasnfering that excel file to client machine. If you are saying I need to install Excel then how can i install Excel.

I am unable to know which type of error also. I may think there is some read write permission setting problem in IIS. I have already gone through those permissions but i am not getting any solution

Posted 20-Aug-12 3:19am

Sunil Kumar Pandab

Updated 20-Aug-12 3:57am

Kenneth Haugland

v2

Add a Solution

Comments

Manas Bhardwaj 20-Aug-12 9:21am

What is the error?

[no name] 20-Aug-12 9:23am

If it gives you a "runtime" error then it can't be "working fine" as you say. What is the runtime error? Where is the stack trace? Is Excel installed on the server computer? "I just need immediate help".... then you might want to call Microsoft if your situation is so immediate.

Kenneth Haugland 20-Aug-12 9:51am

We need more info if we are going to be able to help you. We would needto see the code you are using to read the excel file. And the error code would also be nice.

Sunil Kumar Pandab 20-Aug-12 9:52am

Thanx for your response....
It works fine in local as well as server but after publishing website when a client vistis that site and try to download that excel file it shows only Runtime Error. Actually my work is i am converting a dataset to excel file and saves in server then i am trasnfering that excel file to client machine. If you are saying I need to install Excel then how can i install Excel.

4 solutions

Solution 2

Hi SunilP,
In your server has MS office package.If not then install it.

Posted 20-Aug-12 4:02am

Kamalkant(kk)

Solution 3

This seems to be IIS permission issue.

Check whether you have proper read/write permission of the folde you are accessing.

Thanks,
cheers

Posted 21-Aug-12 0:41am

Sandip.Nascar

Solution 4

give the full permission to your domain, right click, > Properties> security tab give the permissions and your server MS Office must be installed...

Posted 21-Aug-12 0:45am

Jagadish M Vadavatti

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)

Sunil Kumar Pandab · Accepted Answer · 2012-08-26T22:28:00

I have gone through all your solutions but my problem was there. After 3 days struggle I changed my flow. I just create Excel file from dataset and downloading that to client machine without saving that in server. The code that helps me given below. I am very much thankful to Ming_Lu, Author of this article:-

Export DataSet to Multiple Excel Sheets[^]