Howto create a C# XLL addin using XLW & Visual Studio

[xlwDemon]

Work is currently underway on the next version of XLW. In the meantime development snapshots are being placed on the xlw sourceforge website under Files->xlw->xlw-5DEV. There is now support for Visual Studio 2010 and GCC 4.5.2

[garjhana]

Yes. I figured it later. But if I want to do that programatically as a result of a formula, how can I do that? Instead of me going in excel, typing the formula in a group of cells, and hitting the key combination.

If I want to return a matrix result, and when the formula is calculated I want that matrix to be printed on excel right away instead of manually selecting and hitting the key combination.

Will it be possible with xlw 4.0? If you have an example, greatly appreciate it.

[garjhana]

Hi. were you adding [ ] s or { } s to get the matrix result there on Excel 2007?

Thanks

[xlwDemon]

Actualy it's neither. To have a function return a matrix in Excel, you have to press CTRL-SHIFT-RETURN instead of the usual RETURN by itself. Then Excel will enclose your function call within {} itself.

[liquidsnake55]

awesome!!! absolutely awesome, i been stuck on this for weeks! and finally a good solution .. thanks!

[xlwDemon]

Welcome