I had to hand-roll my own marshalling code for this. There were no freely available libs to handle this. XLW is meant for wrapping your entire plugin - this was not an option for me.
In the end, it just took a lot of time, looking through the documentation for xloper and variant, and figuring out how to map them to each other.
For the curious:
arrays in xloper(12):
.xltype is xltypeMulti
.val.array is a pointer to an array of xlopers.
arrays in variant:
.vt is VT_ARRAY | VT_VARIANT
.parray is a SafeArray of variants
other tips with this marshalling:
xltypeRef and xltypeSRef: use xlCoerce to look up actual cell values.
integer values run the risk of overflow. boost::numeric_cast helps with that.
发布评论
评论（2）
我必须为此手动编写自己的编组代码。没有免费可用的库来处理这个问题。 XLW 旨在包装整个插件 - 这对我来说不是一个选择。
最后，只是花了很多时间，浏览 xloper 和variant 的文档，并弄清楚如何将它们相互映射。
出于好奇：
xloper(12) 中的数组：
变体中的数组：
与此编组有关的其他提示：
boost::numeric_cast对此有所帮助。I had to hand-roll my own marshalling code for this. There were no freely available libs to handle this. XLW is meant for wrapping your entire plugin - this was not an option for me.
In the end, it just took a lot of time, looking through the documentation for xloper and variant, and figuring out how to map them to each other.
For the curious:
arrays in xloper(12):
arrays in variant:
other tips with this marshalling:
boost::numeric_casthelps with that.我使用 XLL Plus（费用）
http://www.as-ltd.co.uk/xllplus/default.htm
还有XLW（开源）
http://xlw.sourceforge.net/
以及其他我不知道的内容
I use XLL Plus (costs)
http://www.as-ltd.co.uk/xllplus/default.htm
There is also XLW (opensource)
http://xlw.sourceforge.net/
and probably others I am not aware of