search words in a excel file

[alan4]

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!!

[Aarthi_Arvindh]

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.

[srikrishnaNF]

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

[alan4]

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!

[Aarthi_Arvindh]

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

[srikrishnaNF]

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

[Gak]

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.

[Aarthi_Arvindh]

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

[Gak]

@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.... 

[alan4]

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.