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
Asp pages that worked pefectly on windows 2000 server and iis 5.0 do not work on windows 2003 server with iis 6.0. Asp.net pages work fine. Why?
How many ways are there to maintain a state in .net? What is view state?
Describe a bubbled event and how it is used ?
Which is the parent class of the web server control?
What is asp.net file?
How do cookies work?
What is the used of "ispostback" property?
Explain server-side scripting and client-side scripting.
What is base class of button control in .net?
List down the sequence of methods called during the page load.
14. What are your Future Plans for Swatz Oils GROUP U.K?
Which method is used to enforce garbage collection in .net?
Is asp.net and .net the same?
What are the 3 levels at which content pages can be attached to Master Page?
i have 3+ exp in .net? i am going interview now but they asked me do you know any TOOL? which tool will i study please refer me?