I have developed a web application in asp.net 2.0 with
Access as back end i am trying to gereate report/export
data in excel. After hosting the site i am not getting any
error or such exported excel file. but using the source
code from my system it works fine.
Could any one tell me why it is happening and what is its
solution.
Answers were Sorted based on User's Feedback
Answer / shrikant
Could you please let me know what error you are facing?
The most possible error while exporting data thru asp.net
is COM exception.
Use reflection to achieve this, whenever we use Microsoft
com component line MS-Excel we do code for any particular
version instead use generalize way for handling excel or
any other MS component.
Please refer:
http://www.codeproject.com/KB/cs/Simple_Excel_Automation.asp
x
http://www.c-sharpcorner.com/Forums/ShowMessages.aspx?
ThreadID=49886
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / chetan singh
this problem is related to permission.just note you are
uploading excel file in Inetpub folder and which will not
allow you.So to solve this you need to give access
permission.If you are using XP then give permission to
ASPNET user and for windows 2000/2003 give permission to
Network services.
Is This Answer Correct ? | 2 Yes | 0 No |
Describe the difference between inline and code behind - which is best in a?
How many types are there session
Explain the use of view state?
What is ViewState? What does the "EnableViewState" property do? Why would I want it on or off?
What is a swagger in web api?
Explain about Application and Session Events ?
Explain About duration in caching technique
What are the event handlers that can be included in the Global.asax file?
Which is better union or union all?
What is a postback ispostback and autopostback in asp net?
What is the Global.asax used for?
What are the different types of Session state management options available with ASP.NET?