Hello!
I am using CVI for a work project
I have a 450,000 cell excel
I tried loading it to structs in CVI with ExcelRpt_GetCellValue in a for loop but it takes about 20 minutes.
my end goal-
for the user to input 5 variables; and to do a filter of the results-
if nameinput == name in cell
if hourinput == hour in cell
if numberinput == number in cell
etc...
and then to plot two of the var
(excel wise- name is a col, hour is a col, number is a col etc...)
when it loads the 450,000 cells it works great but I don't like the 20 minutes wait period for it to load.
I can't seem to find a function that does 'filter' in excel- it would mean I could take from the excel only the relevant values
do you have a better way to do it?
id love for some advice
