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 are session objects?

725


Why session management is required?

734


What is a gridview in asp.net?

727


Why we go for mvc instead of asp.net? : Asp.Net MVC

702


What is the difference between session and application?

699


Explain the difference between codebehind="mycode.aspx.cs" and src="mycode.aspx.cs"?

724


Where viewstate value is stored in asp.net?

811


Define xmlvalidatingreader class.

779


Suppose you want an asp.net function (client side) executed on the mouseover event of a button. Where do you add an event handler?

765


Where you store Connection string in "Web.Config" file in ASP.NET?

770


How does asp.net work?

721


How does cookies work in asp net?

732


Define cookie.

746


How to make sure that contents of an updatepanel update only when a partial postback takes place (and not on a full postback)?

712


Can we make activex dll also ti execute in some process as that of client ? How can we do?

4449