Control interface to manage an exel file

[Th618]

I'm learning labview and would like to create a control that a user can select a name (pulled from an excel file) and edit/update the columns within that person's row. Is there an easy way to create this?  I'll put an example table below. I love the power of the program I just want to practice in a way I could learn 

Name   seniority   Points

John.    One.            10

Jim.      Two.            20

Jack.    Three.          30

[cbutcher]

To manipulate Excel files, you'll need to use the Report Generation Toolkit (kind of a pain).

To manipulate files that can be opened with Excel, you can use the far simpler .csv file and things like Delimited Spreadsheet functions and Read/Write Text Files.

I'd guess you're going to want to read the file, associate a name with a row number, then manipulate the other columns, then update that specific row, then write the file.

[Bob_Schor]

If you want to learn LabVIEW, remember its raison d'être, to solve engineering problems (such as the timed acquisition of data from instruments, controlling actuators, and such things).  It can be used for file I/O, can interface with Excel, can manipulate a database, but that's not its real purpose, nor its strength.

If you want to "practice with File I/O", I'd also recommend playing with what LabVIEW calls "Delimited Spreadsheet Files", which is simply a text file.  If you give this function a 2D array of numbers or strings, it will create a file where the rows are simply "lines of text", and the columns are separated by a "delimiter character".  By default, LabVIEW uses the <tab> character, but if you tell the function to use a comma, you will get a file type called a "comma-separated values" file, which often has the extension ".csv".

Bob Schor