Hi,
I'm trying to use an excel sheet as a "configuration sheet" that has configuration data for the program I'm running in VEE.
I already have the VEE program opening the appropriate excel sheet and reading the data in as a 2D array.
What is the easiest way to take this array of data and populate many different "set variables" with individual data?
(about 20 different values i.e.:
min time
max time
min temp
max temp
min voltage
max voltage
min current
... etc.)
Thanks in advance for your help!
I'm trying to use an excel sheet as a "configuration sheet" that has configuration data for the program I'm running in VEE.
I already have the VEE program opening the appropriate excel sheet and reading the data in as a 2D array.
What is the easiest way to take this array of data and populate many different "set variables" with individual data?
(about 20 different values i.e.:
min time
max time
min temp
max temp
min voltage
max voltage
min current
... etc.)
Thanks in advance for your help!
I was trying to do the very same thing today and came up with this. I dont know how fast it will execute if it is constantly pulling data out of the database but it sure is a lot easier to have it look for a name of a test value instead of trying to pinpoint it to a cell location that may change in the future. No need to keep track of where that data is located! So take a look, it may be too basic for some but it seems to work.
Regards,
Kurt