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.
Answer Posted / 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 |
Post New Answer View All Answers
How would you turn off cookies on a page of a website?
How can we make sure that Web API returns JSON data only?
Is sql backend or frontend?
What is session management in web application?
What is view state management in asp net?
Distinguish between Server-side and Client-side code with its functionality?
is there any third party tools are using in .net technologies? what are there ? give me the brief introduction?
Explain the difference between authentication and authorization.
How do you open a page in a new window?
What does aspcompat="true" mean?
What are navigation controls? How many navigation controls are there in ASP.NET 4.0?
What is the maximum timeout we can set for Cookies?
What is caching? What are different ways of caching in asp.net?
Define the steps to set up validation control.
What I need to create and run an asp.net application?