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


Please Help Members By Posting Answers For Below Questions

What is masterpage?

505


What is event bubbling?

601


IN an ASP.NET Web application if there is any error, how can you debug?

579


How can you display all validation messages in one control?

545


What is the displayafter property in updateprogress control?

505






What is an imagemap in asp.net?

552


Describe briefly what is the role of IIS on an ASP.NET application? What does it for the same application?

563


how to retrieve property settings from xml .config file.

541


What is voluum?

536


What is asp.net web pages?

526


Is asp.net is a programming language?

487


What is query string in asp.net?

557


what is silver light when will we use silver light,

1437


Less than one page, how many windows will you be able to maintain?

561


What are the Difference between asp.net and asp ?

564