时间戳

首页 > 解决方案 > 如何在用 C# 编写的 web-API 中集成 COM 互操作（Excel、Ms Word 等的操作）？

c# - 如何在用 C# 编写的 web-API 中集成 COM 互操作（Excel、Ms Word 等的操作）？

问题描述

我正在尝试将 COM 互操作集成到我用 C# 编写的 Web API 中。并且似乎web api的.net核心无法支持COM技术。

这是我收到的错误消息：

FlicApi.Controllers.ButtonController.Post(string buttonId)
lambda_method(Closure , object , object[] )
Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(object target, object[] parameters)
Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor+SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, object controller, object[] arguments)
Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(ref State next, ref Scope scope, ref object state, ref bool isCompleted)
Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(ref State next, ref Scope scope, ref object state, ref bool isCompleted)
Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
Microsoft.AspNetCore.Routing.EndpointMiddleware.Invoke(HttpContext httpContext)
Microsoft.AspNetCore.Routing.EndpointRoutingMiddleware.Invoke(HttpContext httpContext)
Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context)

有什么办法可以绕过net-core for web API不支持COM的这种情况？最终我想要实现的是调用一个 API 并在 Microsoft Excel 上进行一些操作。

这是我尝试过的：

        // POST api/button/buttonId
        [HttpPost("{buttonId}")]
        public ActionResult<string> Post(string buttonId)
        {
            //Console.WriteLine(value);

            //start Excel and get Application Object
            oXL = new Excel.Application();
            oXL.Visible = true;
            //Get a new workbook.
            oWB = oXL.Workbooks.Add(Missing.Value);
            oSheet = (Excel._Worksheet)oWB.ActiveSheet;

            //Add table headers going cell by cell.
            oSheet.Cells[1, 1] = "First Name";
            oSheet.Cells[1, 2] = "Last Name";
            oSheet.Cells[1, 3] = "Full Name";
            oSheet.Cells[1, 4] = "Salary";

            oWB.SaveCopyAs(@"/Users/eaxz/Desktop/book1.xlsx");

            return "success";


        }

标签： c#.netexcelapicom-interop

解决方案

COM 互操作不是服务器端环境的好选择。您可以尝试一些第三方组件，例如GrapeCiy Document API

推荐阅读