02-10-2012 01:50 AM
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!!
Solved! Go to Solution.
02-10-2012 02:18 AM
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.
02-10-2012 02:20 AM
02-10-2012 02:25 AM
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!
02-10-2012 02:30 AM
use two for loops or index array to get the string from 2Darray
and then compare with your string
02-10-2012 02:49 AM
02-10-2012 02:52 AM
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.
02-10-2012 03:16 AM
You can use Excel Find and Replace VI directly to change in excel
02-10-2012 03:20 AM
@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....
02-10-2012 03:21 AM
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.