Hello,
I have an ASP.NET application that allows users to download their data into an Excel spreadsheet, then edit it and then upload it back into the Oracle database.
When uploading the data, we are copying the Excel file to the IIS server in a folder inside the virtual directory (this seems to be going fine) and then opening the file with Excel. At this point, the entire process hangs, because Excel is apparently waiting for us to answer the "Do you want to enable macros?" question. After awhile, the page times out and the EXCEL.EXE is left running (orphaned) on the web server.
I'm certain that this prompt can be answered programmatically, but I haven't found any information on it. Can anyone help? Is it related to Excel settings on the individual user's PC or would it be the settings on the server that are causing the issue?
Please let me know if I need to provide any more information.
Thanks!
I have an ASP.NET application that allows users to download their data into an Excel spreadsheet, then edit it and then upload it back into the Oracle database.
When uploading the data, we are copying the Excel file to the IIS server in a folder inside the virtual directory (this seems to be going fine) and then opening the file with Excel. At this point, the entire process hangs, because Excel is apparently waiting for us to answer the "Do you want to enable macros?" question. After awhile, the page times out and the EXCEL.EXE is left running (orphaned) on the web server.
I'm certain that this prompt can be answered programmatically, but I haven't found any information on it. Can anyone help? Is it related to Excel settings on the individual user's PC or would it be the settings on the server that are causing the issue?
Please let me know if I need to provide any more information.
Thanks!