Read .xls data one sample at a time

[bla1234]

Hi all,

I am quite new to LabView and I would really appreciate your help.

I've got a long column of decimal values of a signal in an .xlsx file and I would like to read it in LabView simulating an acquisition.

My goal is then that to read one sample ( or one row ) every 0.5ms to perform some signal processing real time..

I imagine that I just have to increase the index of the row to read as the iteration number of a for loop but I am having lots of problems doing that and I think there is an easy way to do it that eludes me..

Thank you in advance for your helps!!

[Bob_Schor]

If you are "quite new to LabVIEW", then you don't want to deal with an Excel Workbook (a .xls file).  Open the file in Excel, which I hope is a file with a single Worksheet.  Select the column(s) you want to save.  Go to File, Export, and save it as either a .txt file (which separates columns with <tab>) or a .csv file (which uses commas instead of <tabs>).

Your idea of writing a bit of code to simulate generating data is a good one.  Indeed, LabVIEW makes it pretty easy to do "code Experiments".  But have you looked at the LabVIEW Time functions?  In Windows, it is difficult to create delays measured in fractions of milliseconds (whole milliseconds are no problem).  It would help to learn more about LabVIEW and "use what you know".

So go learn about simple file I/O (even if you have a text file, you still need to know how to open and read the data it contains) and how to use the Time functions to get a loop to run at a specified rate.

Bob Schor