array size

[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

[Auge_Ohr]

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])

[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

[GeneB]

Look at this question on this forum:

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

GeneB