LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

search words in a excel file

Solved!
Go to solution
Highlighted

hello,

 

i have one question, can i search some words that i would like to write in labview, in a excel file???

 

what i want is to search some words from an excel file and then change it for another that i am going to write from labview.

 

do you undeerstand??

 

 

THANKS!!

0 Kudos
Message 1 of 50
(1,226 Views)
Highlighted

First you can read from excel file, then search using string functions like

search/split string, match pattern, scan from string based on your requirement.

then change in the excel.

Aarthi
0 Kudos
Message 2 of 50
(1,221 Views)
Highlighted

Hi Alan4,

  Ofcourse you can do all the operations which you want to in LabVIEW.But before you need to be sure to do the following things,

  1)Reading the data from excel sheet as 2-d array or 1-d array to LabVIEW.

  2)Writing the data to excel sheet from LabVIEW.

 

regards,

Srikrishna

Regards,
Srikrishna

0 Kudos
Message 3 of 50
(1,220 Views)
Highlighted

thahts right, but i am reading in 2d array, and i am searching in a simple string...so it can't be possible, can put a image or something how you'll do it??

 

please!

0 Kudos
Message 4 of 50
(1,218 Views)
Highlighted

use two for loops or index array to get the string from 2Darray
and then compare with your string

Aarthi
0 Kudos
Message 5 of 50
(1,212 Views)
Highlighted

Hi Alan4,

   I am attaching a screen shot of block diagram.Please go through LabVIEW basics I & II to get full understanding of labview programming.

 

 

 

 

Regards,

SrikrishnaNF

Regards,
Srikrishna

0 Kudos
Message 6 of 50
(1,206 Views)
Highlighted

Hi Alan,

 

Can you explain what you want to do with example?

It will be more clear to us.

To search, I would rather do it in Excel. Please find attached excel and code,

Change path and run. You just have to put word you want to search in a perticular column, ou will get data if it is present else it will be empty.

 

just let us know with one example.

Gaurav k
CLD Certified !!!!!
Do not forget to Mark solution and to give Kudo if problem is solved.
Download All
Message 7 of 50
(1,209 Views)
Highlighted

You can use Excel Find and Replace VI directly to change in excel

Aarthi
0 Kudos
Message 8 of 50
(1,201 Views)
Highlighted

@aarathi : yups there is ...

But I don't think it has function Search in Text...which is available in excel sheet.

Actually Excel itself is a powerful tool which we can use to remove processing overhead in LabVIEW.

 

Don't take this post as offensive, I just wanted to give example so that he can explore excel even more to find more formulaes....  Smiley Wink

Gaurav k
CLD Certified !!!!!
Do not forget to Mark solution and to give Kudo if problem is solved.
0 Kudos
Message 9 of 50
(1,198 Views)
Highlighted

hi!

 

what i want, is to read an excel file with lot of pages inside it, and search a specific word in it...

 

after search it change this word for another one...this second word i will write in labview.

0 Kudos
Message 10 of 50
(1,198 Views)