Page 1 of 1

array size

Posted: Sun Jul 31, 2011 5:59 am
by BruceN
I have a 2 dimensional array (created from dc_excel2array() ). the number of rows is len(aArray). I can't seem to find a function that gives me the number of columns. Is there one? If not how can I determine it?

thanks

Re: array size

Posted: Sun Jul 31, 2011 6:15 am
by Auge_Ohr
BruceN wrote:I have a 2 dimensional array (created from dc_excel2array() ). the number of rows is len(aArray). I can't seem to find a function that gives me the number of columns. Is there one? If not how can I determine it?
try

Code: Select all

nCol := len(aArray[1])

Re: array size

Posted: Sun Jul 31, 2011 10:01 am
by BruceN
Thanks... that did it. Another quick question. I get a msgbox 'excel is not installed'. So, I take it that to use the dc_excel2array function a copy of excel MUST be installed? Would open office work?

As such, I've had to do my testing on wife's notebook which has excel on it - that does not lead to peaceful coexistance :)

Re: array size

Posted: Sun Jul 31, 2011 5:06 pm
by GeneB
Look at this question on this forum:

http://bb.donnay-software.com:8080/phpB ... ?f=2&t=256

GeneB