Calling an XLL from (unmanaged) C++

2019-08-16 01:52发布

I have an XLL Excel addin and now another team wants to use the same functionality in their project (unmanaged C++). Is there a way to interface with this XLL directly from C++?

标签: c++ xll
2条回答
劳资没心,怎么记你
2楼-- · 2019-08-16 02:19

Is you XLL un managed or unmanaged code?

As far as I know, an unmanaged C++ XLL file is in fact a DLL that exports specific methods called by Excel.

If your XLL has a .def file, maybe you could add method that would be called by the other team.

查看更多
ら.Afraid
3楼-- · 2019-08-16 02:34

You can use GET.WORKSPACE(44) to get a list of the add-ins and their argument signatures. If you no hablo macro sheets, load xllutility.xll from http://sdrv.ms/JtaMIV and call =GET_WORKSPACE(44) in a cell. (Note the underscore.)

The second column is the name of the function and the third is the argument list encoded as described here: http://msdn.microsoft.com/en-us/library/office/bb687900.aspx

Use the handy adjust.xll from the link above to adjust the output to the correct size.

查看更多
登录 后发表回答