I am new to this python package. This question was asked and I did a search of the forum however, I can figure out what I am doing wrong.
I have a very simple function:
from pyxll import xl_func
When I run excel, Excel recognizes the function. Now, since this function is returning 3 numbers in an array to excel, I have to use the special cntl+shift+enter. So if I choose (highlight) cells A1:A3, press the "=" and enter in test_func() and then press cntl+shift+enter should I get three cell entries at 1,2,3? It doesn't work for me. It just returns zero. Something tells me there might be a numerical type issue or I'm just not using the excel array feature correctly. How can I get the array to return vertical? Iterate along rows instead of columns?
Thanks for reading.