Need help in excel and led

[dnssetup]

Hi everyone. Can someone reallly please show me a sample vi on linking a excel to a led. Its like when a person puts a password and the led light's up.

[Dennis_Knutson]

That is a very confusing question. What do you mean 'a excel'? Do you mean a cell in an Excel worksheet? To start the Excel program? Something completely different?

[dnssetup]

sorry for the confusing question. Ya, i meant a cell in a excel worksheet. The worksheet that is available in labview.

[smercurio_fc]

You've already asked this question.

Please do a search for opening Excel files from LabVIEW. This issue has been asked about MANY times and many examples have been posted.

[LV_Pro]

Do you mean having an operator enter a value (password) and comparing it to one read from a spreadsheet? As mentioned there have been a number of threads about reading from a spreadsheet, both those that are actually Excel formatted, and those which are just text files with specific delimiters, such as CSV (comma seperated variables) or tab-delimited. Once you have built code to read in from a text file, then you will need to determine a way to compare the operator entered data to that which is read in.  Do a search, build the file read, then come back for more help. There isn't a pre-made LabVIEW program to do this, unless someone has posted one in the past.

[NIquist]

---

@smercurio_fc wrote:

You've already asked this question.

Please do a search for opening Excel files from LabVIEW. This issue has been asked about MANY times and many examples have been posted.

---

Car park method???   I don't get it.

[dnssetup]

Sorry, i been trying to find but still cant get it..

[smercurio_fc]

We can't really help you unless you provide a better explanation of what you are trying to do. We don't know whether you're trying to control Excel or whether you're trying to put a spreadhseet on a front panel, or whether you're trying to put a regular table on a front panel, or .... ??

[dnssetup]

I am trying to put  a spreadsheet which has username and password. The 1st row of the spreadsheet will link to the 1st led, and the 2nd row will link to 2nd led and goes on. If any row which has information is deleted the LED turns off. Sorry again.

[KateB]

There's a function called Excel Get Data installed with Report Generation Toolkit for Microsoft Office that you could use it for pulling data from Excel.

Then, matching between user name, and password in LabVIEW to lit up LED.