How to create a user interface to change the password by the user, when the list of usernames and passwords are in MS-Excel?

[Anu Mathew]

How to create a user-interface to change the "password" by the user, from the list of usernames and passwords which are in MS-Excel?

Can any one help me with a sample code?

Anu

[Megan B.]

Hi Anu,

I'm not very clear on your question.  What password are you trying to change? 

That being said, your first step will probably be to read the names and passwords into LabVIEW from Excel.  The easiest method will likely to be use the Read from Spreadsheet VI which will return your data in a 2-D array.  You can then use the Index Array VI to parse out the usernames and passwords.

Hope this helps,
Megan B.
National Instruments

[tbob]

Are the names and passwords in a true Excel file, with Excel formatting and such.  Or are they in a comma-separated-variable (CSV) format which can be displayed in Excel, or even a tab-delimited format which can also be displayed in Excel.  The CSV and Tab files can be displayed in Excel but they do not contain the actual Excel formatting of a real XLS file.  This makes a difference on how to code your program.  It is a lot easier, in my opinion, to use a simple CSV file or Tab file.  You can use Read From Spreadsheet VI as described by Megan, change the password, then use Write to Spreadsheet VI to save the changes.  If using a true XLS file, you would need to use the Active X methods of Excel (Open workbook, read cell, write cell, etc,).

[Anu Mathew]

The excel file is in tab-delimited form. i already have a list of usernames and passwords in two different columns. i want to change the "password" corresponding to the "username" using the labview so that the list of password in excels are modified and saved. i want a user interface to change the password if someone forgets the password.

can anyone post a sample code?

Anu

[parthabe]

Hi Anu,

I've created a set of VIs for Password changes with priveleges for Admin & User logins.

I've done for normal notepad text files without file extn.

So, U can easily modify them as per Ur Excel requirement.

It's a very basic functionality VI set, that it doesnt have the feature of adding Admin Logins while runnig, U've to modify a littlle bit by Urself.

Pls make sure that the "list" file exists in the Current Working Directory from which U run the Untitledpass.VI.

This is the top most VI. Run it & explore the features.

Rgds,

Partha.

[Anu Mathew]

Thank You!