Author Topic: Return array  (Read 1566 times)


  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Return array
« on: June 15, 2012, 07:10:39 AM »
Hi everybody
when I write a function returning an array it doesn't work.
I expect the function returns a grid of data but it returns a single cell value and not a list of list as return values.
Also I can not work with standard function examples as array_pyxll_function_2  or numpy_array_fucntion_1.
I installed numpy but the second function doesn't return the transpose matrix but only an error message. (I installed numpy correctly and numpy_is_installed() function returns true value).
Thanks in advance


  • Administrator
  • Hero Member
  • *****
  • Posts: 638
  • Karma: +15/-1
    • View Profile
Re: Return array
« Reply #1 on: June 15, 2012, 10:09:29 AM »

are you entering it as an array formula into Excel? You have to select the range you want to use, then enter the formula, and then press Ctrl+Shift+Enter. See for details about array formulas.

Is there anything in the log that might help us figure out your second problem with those functions? Please could you take a look and copy and paste any errors, or just send me the whole file, please?