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
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 |
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 |
Which authentication uses a combination of windows and iis authentication?
Explain the asp.net session state modes.
What is sdlc process?
what is the deference between dataset and data adapter?
What is the difference between page-level caching and fragment caching?
How do you enable tracing? a) Set the Trace property of the Web Form to True b) Set the Trace property of the server object to True c) Set the Session variables Trace to True d) Set the Applications Variable Trace to True.
How does the cookies work in asp.net?
What is cookie less session? How it works?
What are the types of assemblies and where can u store them and how a private assembly is used only by a single application, and is stored in that application's install directory (or a subdirectory therein)?
Why asp.net mvc is better than asp.net? : Asp.Net MVC
difference between Trace and Debug ?
2 Answers Accenture, HCL, Patni,
In a webpage if i want to give access to only half page ,then what should i do?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)