1,746 questions
Microsoft.Office.Interop.Excel's merge method when deployed to an LLS file results in an error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 86%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPY%3C/text%3E%3C/svg%3E)
peiyuan yan
0
Reputation points
System.Runtime.InteropServices.COMException: The remote procedure call failed. (Exception from HRESULT: 0x800706BE)
on System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperType, MessageData& msgData)
In Microsoft.Office.Interop.Excel.Range.Merge(Object Across)
At WebApplication2.XSDD.XSDD_EXCEL(String dh) position D:Print TemplateWebApplication2XSDD.cs:Line number 200
At WebApplication2.WebService1.XSDD(String dh) position D:Print TemplateWebApplication2WebService1.asmx.cs: line number 472
Windows development | Internet Information Services
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 24%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESW%3C/text%3E%3C/svg%3E)
Sam Wu-MSFT 7,561 Reputation points Microsoft External Staff2023-06-14T03:22:20.25+00:00 It is difficult to reproduce your problem based on your description, what is your project? what have you tried? does the problem only occur on iis? etc. please post more details information about your issue.
-
MotoX80 36,401 Reputation points2023-06-16T00:01:48.81+00:00 You should also read this.
Important
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment. For more information, see Considerations for server-side Automation of Office.
What programming language is your code? You should add those tags to this question so that you can reach developers who use that language and see what recommendations that they have for accessing Excel data while using IIS.
Sign in to comment
Sign in to answer