Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Newbie question] Returning an array from a function
Hi,
I only started a few days ago working with Excel add-ins. :) I would like to make a function (that can be called from a cell!), that will fill an array of values and return them on the sheet. To be more clear, I would like to write in a cell(i.e. A1) =MyFunc(), and when the function is called, in the cells A1-B4 I will have values like: 0 11 1 11 2 21 3 31 I tried using the FP stucture, and I wrote something like this: ... {" MyFunc", " K", " MyFunc", " ", " 1", " MyCat", " ", " ", " test func"}, ... FP* __stdcall AVM_Schedule(void) { FP arr; arr.rows = 4; arr.columns = 2; for(int i=0; i<4; i++) for(int j=0; j<2; j++) arr.array[i*4+j]=i*10+j; return &arr } When I run this function, I get the first value in the array (in this case 0) in the cell where I entered the function call. Probably I'm trying a wrong approach. Could you please help me get on the right track? Some sample code about this issue would be very nice. Thanks! Best regards, Doru K |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Newbie question] Returning an array from a function
I don't understand your code, but try highlighting A1:B4 instead of just
A1, and using Ctrl+Shift+Enter instead of just Enter. Alan Beban dorutzu wrote: Hi, I only started a few days ago working with Excel add-ins. :) I would like to make a function (that can be called from a cell!), that will fill an array of values and return them on the sheet. To be more clear, I would like to write in a cell(i.e. A1) =MyFunc(), and when the function is called, in the cells A1-B4 I will have values like: 0 11 1 11 2 21 3 31 I tried using the FP stucture, and I wrote something like this: ... {" MyFunc", " K", " MyFunc", " ", " 1", " MyCat", " ", " ", " test func"}, ... FP* __stdcall AVM_Schedule(void) { FP arr; arr.rows = 4; arr.columns = 2; for(int i=0; i<4; i++) for(int j=0; j<2; j++) arr.array[i*4+j]=i*10+j; return &arr } When I run this function, I get the first value in the array (in this case 0) in the cell where I entered the function call. Probably I'm trying a wrong approach. Could you please help me get on the right track? Some sample code about this issue would be very nice. Thanks! Best regards, Doru K |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Newbie question] Returning an array from a function
WOW! That works! Thanks! I'm amazed. Great! :) *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Newbie question] Returning an array from a function
Doru K wrote:
WOW! That works! Thanks! I'm amazed. Great! :) *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Thanks for the feedback. It's called "array entering". Alan Beban |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
[Newbie question] Returning an array from a function
On the same topic, is there a way to return an array of strings, instead
of doubles? I would like to return some strings, but the array field of the PF structure allows me only to use double values. Thanks! Doru K *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie Question, NOW() function | Excel Worksheet Functions | |||
newbie question on multi-dimensional array | New Users to Excel | |||
Newbie Question: Returning the value from a cell on another sheet | Excel Programming | |||
function returning array | Excel Programming | |||
returning an array from a custom function | Excel Programming |