----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Thepelicanbrief2 Message 3 in Discussion suggest you read excel as a database, and read it using oledb connection. opening a excel object onto a web server will lead you into lots of troubles. -----Original Message----- From: SaifIkram4u [mailto:[EMAIL PROTECTED] Sent: Donnerstag, 23. September 2004 09:25 To: 'BDOTNET' Subject: Reading Excel file in ASP.NET ----------------------------------------------------------- New Message on BDOTNET ----------------------------------------------------------- From: SaifIkram4u Message 1 in Discussion Hi All,<o:p></o:p> <![if !supportEmptyParas]> <![endif]><o:p></o:p> I had created an ASP.Net Application and I am trying to read the Excel file... the code is as follows<o:p></o:p> <![if !supportEmptyParas]> <![endif]><o:p></o:p> Excel.Application oApp = new Excel.Application();<o:p></o:p> <o:p></o:p> Excel.Workbook oWorkbook = oApp.Workbooks.Open(strpath,0,true,5,"","",true,<o:p></o:p> Excel.XlPlatform.xlWindows,"\t",false,false,0,true);<o:p></o:p> Excel.Sheets oSheets = oWorkbook.Worksheets;<o:p></o:p> <![if !supportEmptyParas]> <![endif]><o:p></o:p> But when I run the project I am getting the following error :<o:p></o:p> <![if !supportEmptyParas]> <![endif]><o:p></o:p> Access is denied. <o:p></o:p> Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.UnauthorizedAccessException: Access is denied.<o:p></o:p> <![if !supportEmptyParas]> <![endif]><o:p></o:p> <![if !supportEmptyParas]> <![endif]><o:p></o:p> Can any one help me<o:p></o:p> <![if !supportEmptyParas]> <![endif]><o:p></o:p> Regards<o:p></o:p> Saif <o:p></o:p> <![if !supportEmptyParas]> <![endif]><o:p></o:p> ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED] ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
