On Jul 20, 8:07*am, abb <andre...@gmail.comwrote:
Quote:
On a Vista machine, the following code works using the ASP.NET
Development Server, but fails in IIS7:
>
book =excel.Workbooks.Open(tempfile,
* * * * * * *false, false, Missing.Value,
* * * * * * *Missing.Value, Missing.Value, Missing.Value,
Missing.Value,
>
In IIS7, the error is "Microsoft OfficeExcelcannot access the
file ... There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently
open workbook."
>
Both NETWORK SERVICE and IUSR have:
- read/write permissions on the temp folder
- Launch, Access, and Configuration permissions in DCOM Config forExcel
>
I've also tried running the IIS application as my local adminstrator
account, but the same error occurs. *It's IIS7 specific. *What
permission does it need? *Any ideas? *Thanks.
I agree with Mark that there are many automation issues on the server:
http://www.gemboxsoftware.com/GBSpre...htm#Automation
Except previously mentioned myxls and Aspose.Cells, you can try our
free Excel R/W component:
http://www.gemboxsoftware.com/GBSpreadsheetFree.htm
If you have XLS/CSV/XLSX files smaller that 150 rows it is free of
charge, otherwise it is $425 per developer (one time fee).
--Zeljko
