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.xlWBATW orksheet);
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!
"Cor Ligthert" wrote:
Jane,
Is it opening the file on the clientside or the serverside?
Cor
"Jane" <Ja**@discussions.microsoft.com>
..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!