We are using Microsoft.Office.Interop.Excel in a .NET Core application to read and write Excel files. Our Excel files have micro formulas.
In order to access the Excel files, by default Interop is using DCOM config object (com objects by com excel reference). We want, that Interop use COM+ Application in place of DCOM config excel object.
Could you please assist how we can use COM+ for Interop?
Uehara AyakaPosted Dec 13, 2021, 8:37 AM
I suggest that you may try Free Spire.XLS for .NTE to read and write Excel files and manipulate formulas as well. This library does not require MS Excel to be installed on either developer's or client's machines.
Here are some useful links:
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Create-Excel-File-in-C-VB.NET.html
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Excel-Formula.html