Read data from Excel

[Fird]

Hi ALL.

I have a bunch of values in my excel data.

However, I need to read the value for every next 10 values.

Example,

1    ----- First reading

2

3

4

5

6

7

8

9

10

11 ---- second reading

.

.

.

20 

I try to use LLB Manager before. However, it doesnt work as wanted.

Anyone can help me.

Thank you. 

[AdnanZ]

It would be better if you posted your 'excel file' so we know what format your data is stored in. In that case, you don't have to use the VIs in the llb file that you have attached; you could use something simpler like Read from Spreadsheet file or use advanced File I/O functions to set the file position and, then, read the data easily.

[Fird]

Kindly find the attachement below.

I need to read data from -360, -350,-340,...,340,350,360

Thanks

[smercurio_fc · Accepted solution]

The first thing you should do is rename the library. "LLB Manager" is a built-in LabVIEW tool for managing libraries. This can cause confusion.

What exactly doesn't work? What have you tried? You specify the start/stop range, and run the "Get Excel Values" VI. Example:

 

You have 2 options:

1. Call the VI for each cell you wish to read.
2. Read all of the values and index them out based on getting the ones that are mulitples.

The latter will require more memory since you have to read in all the values, but it will be faster.

Message Edited by smercurio_fc on 03-13-2009 09:41 AM

[Fird]

Dear ALL,

I manage to solve the problem. What I did was taking out all the value needed and stored in another Excel file.

It is much more easier eventhough it is not preferrable method.

Merci.

[smercurio_fc]

Well I wouldn't call that easier. Did you try suggestion (2)? It's quite easy, especially since your data is evenly spaced.

[Fird]

Yeah.

Thanks a lot!