LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Writing Excel File Dynamically LabVIEW 8.5

Hi all, I have attached a .jpeg file to give a better picture.

can somebody give me an example on how i can do it?

 

Overview of my picture. below few pointers are what i have done.

  1. 4 different sets of number are to be keyed it. The reason for 4 digits because each individual number can only go up to 7. So after the 4 different numbers are keyed, i will convert these 4 into 1 set of string.
  2. using the string, i use the 'find' function to search the code column.
  3. say code 1234 is read, i will read excel file row 2, column B and column C to display the type & Number given. (a set of string)
  4. thereafter, i want to dump the information to another excel file with timestamp. afterwhich, the next cycle will continue(waiting for the next recieved code). ( I don't know how to do this )
  5. There's a set of power control on the top right. I have bind increment and decrement to Shift+F1 / F2.

 

Some improvements/questions i'd like you people to help me with

  1. Pointer 4 of the above. I'd like to do this dynamically, constantly update. Once the information is dump, it will not read the same received code again.
  2. Is it possible to bind the increment/decrement to other hotkeys like shift+d or shift+arrowup/down instead?
  3. i'd like to use the redundancy of error prevention in case somebody go mess it up on the recieved code. so is it possible to implement something that my VI will read the code 3-5 times within 1min. If it's the same, then it will begin to go through the look-up table. AND after that, if the next time the same code is received, it will ignored it till the next change of recieved code.
  4. is it possible to run the same excel but different sheet for getting the information? because i can't seems to access just one excel file for the look-up table and get cell.

 

I have attached

  1. My VI(Trial.VI) it's kinda messy =/
  2. A JPEG file for an overall picture
  3. Look-up.xls & Getcell.xls (for the look up table and comparing)
  4. SearchExcel.VI(an example of searching the number)Project Sample.jpg

hope somebody can help me. =/

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