Read Excel values

[Moony]

Hi all.



Please, don't angry about my question. I know that it is very popular problem and many specialists gave various ways to solve this, but i can't do it.

I need to use from Excel 2-nd and 3-rd columns as arrays in my program.

Would you be kind to help me?

Thanks in advance.



P.S. My Labview version is 8.5.

[smercurio_fc]

As you've said, this is a very popular question which has been answered numerous times. What exactly have you tried that doesn't work? Have you looked at the example that ships with LabVIEW? Instead of posting the Excel file (all 3 MB of it), post your code.

[GITA_A]

Hi,

You can use Read from Spreadsheet file.vi to read the whole data from excel file and then index the required column using index arrary.

[smercurio_fc]

---

@GITA_A wrote:

Hi,

You can use Read from Spreadsheet file.vi to read the whole data from excel file and then index the required column using index arrary.

---

Read From Spreadsheet does not work with Excel files. It only works with text files.

[Moony]

Hi all.

Thanks for replies. Finally I've used LLB Manager, Get values from Excel.vi.

Thanks once more. 

[smercurio_fc]

To what are you referring? The LLB Manager (Tools -> LLB Manager) has nothing to do with Excel.

[David-A]

Hi Moony,

If all you want is the second and third column of your excel sheet then delete everything except those two columns and save it as a

tab delimited .txt file.  You can then read the .txt file in labivew using a "Scan From File.vi"

http://zone.ni.com/reference/en-XX/help/371361G-01/glang/scan_from_file/

David A.