LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

read from spreadsheetfile

hi,

i read from a spreadsheetFile,i want to read each value ,but in my code i can read only the first value.how i can resolve this problem ?

i want to calculate the value  :  S=sum(sqrt(xi+yi)) where xi represent the value readed from xoffset.txt and yi represent the value readed from yoffset.txt  at iteration i

Download All
0 Kudos
Message 1 of 7
(2,393 Views)

Hi iman,

 

it seems you really should learn to use the context help. Some basic debugging techniques would be ok too.

Going through basic courses offered by NI would also be a good idea...

 

check.png

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 2 of 7
(2,365 Views)

Modified..

 

What you are reading is a 2D array and the data is in Row -0.Just need to index Row zero and take the values

0 Kudos
Message 3 of 7
(2,361 Views)

I didnt see the post by GerdW..Thats more simple

0 Kudos
Message 4 of 7
(2,356 Views)

but i want all the datas in all rows not only in the first row

0 Kudos
Message 5 of 7
(2,345 Views)

Hi iman,

 

your example files only contain one row of data...

 

Just use a FOR loop with autoindixeing inputs. It will automatically index of the rows of your 2D data.

Did I mention the basics courses offered by NI?

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 6 of 7
(2,341 Views)

yes please

0 Kudos
Message 7 of 7
(2,336 Views)