I'm currently develloping a web site in ASP.Net. I need to do a import from xls and xlsx documents to a database.
I'm using Microsoft.Office.Interop.Excel and this code to open my documents:
oXL = new excel.Application();
oWB = oXL.Workbooks.Open(filePath);
First time, I could'nt acces to Excel application because of rights on the server. Now I have done te correct acces rights to "Microsoft Excel application" in the component Services and I have acces to Excel but when I want to open my file I have this issue:
Microsoft Excel can't acces to the file ÃÂ« C://test/Test.xls ÃÂ». Several reasons are possible: