read data from excel file and display each row separately on a meter one by onemultiple

[bob992]

hi

how do i read dat from an excel file and display this data one row at a time onto multiple meters in labview?im using labview 8.5 at the moment and require 6 different displays. the data in excel has been written by labview using the write to spreadsheet.vi.

many thanks

[Mark_Ramsdale]

Hi,

You can read the spreadsheet, parse the rows, and then use the instrument drivers to send the readings to the meters.

Do you have some more specifics?

[bob992]

im quite new to labview so i dont really know all available options. the data that is being stored is from 6 sensors and is stored as 6 rows of data, each being an integer between 0 - 255. when the data is finished being stored i need to play that back into labview in the same order it was stored in and adjust the meters to display each value working through the whole table. hope that explains it a bit more clearly

[nyc_(is_out_of_here)]

You are new here. People want to see that you have made an effort, e.g. they want to see your VI.

LabVIEW 101 tutorials

[Mark_Ramsdale]

Hi,

I think I misunderstood what you are calling meters, these are the indicators on the VI right?

You can still do what I mentioned above, only send the results to the indicator with a wire, ignore the instrument driver bit.

You might consider using a graph to display the data, a 'meter' would change values as fast as you put them in.

[aeastet]

There are examples that ship with LabVIEW. If you go to the help in the menu bar you can look up examples on how to read data from MS Excel. That should get you started then come back with specific questions.

[bob992]

hi yes the meters are numerical tanks displaying the output. i can read back the data to a graph and see the data displayed but i need to play back the data one column at a time to change the tank and leds, which are connected together, so a real time varying display is seen when read back. sorry but i dont know what you mean when you say parse the rows. thank you

[bob992]

hi

i have attatched both my programs. the second one at the moment only has graphs to display the data but i dont know how to change that for a meter that changes every time a new row is read as if it were in real time playing back

cheers

[Dennis_Knutson]

You did not include the subVI 'SI Read From File' and I don't understand why you would use it in the first place instead of the regular Read From Spreadsheet. You don't have an Excel file at all if Project LabVIEW is what you are using to create the file. You did not include a typical file either. Of course, if Project LabVIEW is your file write program, it is poorly written and you are throwing away most of the data.

Fix your file write and then read the file with Read From Spreadsheet File. This will create a 2D array. Simply wiring the result into a for loop will autoindex the array. That is a fundamental concept in LabVIEW that you should be familiar with.

[bob992]

hi

yes that is my write program thank you, i know its not the best which is why im on here looking to amend things. i have altered my write to excel file but it is too large to attatch to here. anyadvice would be greatly appreciated for both read and write files