Excel System.UnauthorizedAccessException

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I got the web application to open up the excel. It works fine on my
development box. But when i moved it to the production server, I cannot get
the Excel spreadsheet to open. I get System.UnauthorizedAccessException:
Access is denied.
I've granted full access for the excel file stored in the server, but still
can't access it. Please help!
 
Have you tried granting the ASP user to have read access of the file? By
default this is ASPNET. Make sure you don't have 'deny' permission on that
file as well since it has higher precedence than the 'allow' permission.
 
I have granted permission....
I'd like the excel to open on the client side, but seems like is not doing
it....

here's my code:

Excel.ApplicationClass excelObj = new Excel.ApplicationClass();
excelObj.Visible=true;
Excel.Workbook newbook =
excelObj.Workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
Excel.Workbook workBook =
excelObj.Workbooks.Open(strFileName,0,true,5,"","",true,Excel.XlPlatform.xlWindows,"",false,false,0,true,true,false);
Excel.Sheets sheets = workBook.Worksheets;
Excel.Worksheet dataSheet = (Excel.Worksheet)sheets.get_Item("Trade Ticket
Lookup");
Excel.Range range = dataSheet.get_Range("B2",Type.Missing);
dataSheet.Select(Type.Missing);
range.Cells.Value2=tradeID;

Excel.Worksheet tradesRealSheet = (Excel.Worksheet)sheets.get_Item("Trades
(Real)");
tradesRealSheet.Select(Type.Missing);

excelObj.Application.Quit();

I don't know what I'm doing wrong here, please help!
Thanks!
 
Back
Top