A problem creating Excel object 1

[Plato2]

I'm tying to create new Excel Object;
Excel.Application Myexcel = new Excel.Application();
But it gives error:
Exception Details: System.UnauthorizedAccessException: Access is denied.

I'm made the reference to Excel.dll and gave the permission and it still gives error.....

How can I solve this?

 

[Isadore]

One method is to use javacript, e.g.,

<script language=&quot;JavaScript&quot;>
function startExcel(strFile){
var myApp = new ActiveXObject(&quot;Excel.Application&quot;
if (myApp != null){
myApp.Workbooks.Open(strFile);
myApp.Visible = true;
}
}
</script>

The add a href to open Excel file:

<a href=&quot;javascript:startExcel('XL3034.xls')&quot;>Open Excel File</a>

 

[Isadore]

Plato: Couple of articles that might help (in case you didn't come across them):

Read Excel files from ASP.NET

http://www.aspfree.com/aspnet/excel.aspx

Using Excel Spreadsheets as a DataSource

http://www.123aspx.com/redir.aspx?res=28985

Security settings-From ASP.net to run Excel application

http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/Q_20424011.html

ASP.NET: Display data from an Excel Spreadsheet

http://www.aspalliance.com/aldotnet/examples/excel.aspx

Post back and let us know if you crack this one Plato.

 

[Plato2]

Thank you for the links.
The third link doesn't exists and 3 other links use OleDB adapter to select data from Excel(by using select statement) but I want to open excel and read each cell at a time.
I have to use this way cause &quot;select&quot; doesnt help in some cases....

Any other suggestions.
Thanks again

 

[Plato2]

Finally I managed to Create Excel object from asp.net. But I had to create a custom asp.net account and then I had to restart iis(I did that for my local server) .
Do I have to create custom asp.net account for my remote server and restart iis - it seems very inconvinient. Is there is another way to do that(to make Excel 'problem' work)? Why do I have to create custom asp.net?

If anybody can explain in more details why these problems(with excel) are happening and how to get around - I would greatly appreciate that?

Thanks