topic Re: Object Read from another document? in Libraries & objects

Object Read from another document?

JGoode — Thu, 23 Nov 2017 11:12:15 GMT

Hello,

Is it possible for an object to be able to read and search through another document such as Excel?

Thanks

Edit:
I have found this but I can't work out how to interpret it to be able to use it! Any help would be much appreciated.

DIM sarray[]
! file in the library, containing parameter data
filename = "ProjectNotes.txt"
ch1 = OPEN ("text", filename, "MODE=RO, LIBRARY")
i = 1
j = 1
sarray[1] = ""
! collect all strings
DO
    n = INPUT (ch1, i, 1, var)
    IF n > 0 AND VARTYPE (var) = 2 THEN
        sarray = var
        j = j + 1
    ENDIF
    i = i + 1
WHILE n > 0
CLOSE ch1
! parameter popup with strings read from the file
VALUES "RefNote" sarray

Re: Object Read from another document?

Erwin Edel — Thu, 23 Nov 2017 11:55:59 GMT

Think this it what OPEN, INPUT, OUTPUT etc are used for.

There should be information about this in the GDL Reference Guide that you can find from the Help menu.

Should probably work with tab delimited text files.

Re: Object Read from another document?

JGoode — Thu, 23 Nov 2017 12:25:28 GMT

Erwin wrote:
Think this it what OPEN, INPUT, OUTPUT etc are used for.

There should be information about this in the GDL Reference Guide that you can find from the Help menu.

Should probably work with tab delimited text files.

I've read through and tried these, still no idea. Still not working.

EDIT: I have got the basic drop down box including all information in my text document. Is there any way to search through the list easily without having to type it out very quickly?