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



I have developed a web application in asp.net 2.0 with Access as back end i am trying to gereate r..

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

I have developed a web application in asp.net 2.0 with Access as back end i am trying to gereate r..

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

Post New Answer

More ASP.NET Interview Questions

What is mta?

0 Answers  


Do you know caching feature?

0 Answers  


Explain Page life cycle

8 Answers   DELL,


Differentiate between file-based dependency and key-based dependency.

0 Answers  


hi i am varinder. i am very eager to learn ASP.net in C#. i am beginer to it. i have refer some books but i found it tuff to understand. their language is tuff. So please tell me the best site or best book to learn ASP.net in C#. i will be very thankful. Varinder

1 Answers  


How to reduce the width of textbox in editcommandcolumn of datagrid?

0 Answers  


How ViewstateMac works?

0 Answers   CGI,


What methods are fired during the page load?

3 Answers  


Best Institute in india for online training (Dotnet/java/Tibco/Dwh/etc.....)

4 Answers  


What is the main difference between Asp.net and Vb.net?

0 Answers  


can we transfer data from one page to another page using viewstate if so how?if not y?

1 Answers   Patni,


what is the difference between this.controls and page.form1.controls and me.controls?

2 Answers   FactorH,


Categories