I developed an XLL plug-in through ExcelDNA, and it runs normally. I have now introduced Google OR-Tools to implement related calculations for mixed integer programming. The problem now is that after compiling and generating in visual studio 2022, Google.OrTools.dll and google-ortools-native.dll need to be placed in the same directory as -packed.xll for the program to run normally. If you pack the two DLLs into the xll file by writing a packed statement in the DNA file, you can compile successfully, but the XLL program does not run properly, and it prompts that the reference file cannot be found.
Are there any friends who use OR-Tools in DNA? How to correctly pack it into a single xll file?
Development environment:
Visual studio 2022
.NET Framework 4.8
Google OR Tools 9.11.4210