3,597 questions
using office (excel) automation from a web server is not supported. runtime errors should be expected, and manual recovery from errors may be required.
Active X 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(265.6, 80%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Louie
21
Reputation points
We have a Web application that can generate Excel file. We trigger creating the Excel in the front-end and the services will take care of the Excel creation in the background.
Sometimes, we encountered error related to Active X. And sometimes, we don't.
Here are some of 2 patterns we encountered:
①
System.Exception: ActiveX コンポーネントを作成できませんUnable to create Active X component。 場所 Microsoft.VisualBasic.Interaction.CreateObject(String ProgId, String ServerName) 場所 ExcelOprationLibrary.ExcelLib.get_ExcelApplication() 場所 ExcelOprationLibrary.ExcelLib.OpenNewBook(enAddNewExcelBookOption aiNewBookOption, String acFullBookName) 場所 ExcelOprationLibrary.ExcelLib.OpenBook(String acDirName, String acBookName) 場所 AcNavi.SearchService.ExecOutExcelFile.OutFileToExcel() 場所 AcNavi.SearchService.ExecOutExcelFile.TranData(IDataRead
②
System.Runtime.InteropServices.COMException (0x800A03EC): Workbooks クラスの Add プロパティを取得できません Unable to get Add property of Workbooks class。 場所 Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack) 場所 Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack) 場所 ExcelOprationLibrary.ExcelLib.OpenNewBook(enAd
Developer technologies ASP.NET Other
SQL Server Other
14,494 questions
{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(262.40000000000003, 36%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELH%3C/text%3E%3C/svg%3E)
Lan Huang-MSFT 30,186 Reputation points Microsoft External Staff2024-02-26T03:10:08.89+00:00 Hi @Louie,
Currently in Microsoft Q&A we only support English, could you please edit your question into English？Then we can help to solve your issues, thanks for your understanding.
What specific project did you use? It would be best if you could provide a minimal example that reproduces the issue so we can better help you.
-
Louie 21 Reputation points
2024-02-26T06:30:55.7633333+00:00 Good day, I've updated the question. Thanks!
-
Lan Huang-MSFT 30,186 Reputation points Microsoft External Staff
2024-02-26T07:33:27.7066667+00:00 Hi @Louie,
What specific project did you use? It would be best if you could provide a minimal example that reproduces the issue so we can better help you.
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2024-02-26T22:52:37.68+00:00 Currently in Microsoft Q&A we only support English, could you please edit your question into English？
That is not really the case. These days there are forums for a couple of more languages, see: https://learn.microsoft.com/sv-se/answers/non-supported-locale/
Sign in to comment
1 answer
Sort by: Most helpful
-
![](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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator2024-02-26T23:13:21.6833333+00:00