I want to a list or drop down menu that will load all the files in the Distraction folder and displayed the contains of file in the front panel

[Ngouda]

I have a folder (Distraction) that contains several excel files. Each excel file contains a text column and a time column.
I want to:
1. A list or drop down menu that will load all the files in the Distraction folder. And so the user can choose the file he needs.
2. When the user chooses the file, the text and time in the file should be displayed on my front panel.
Is this possible on Labview?
Can you show me how to do it please?

Thanks you

[GerdW · Accepted solution]

Hi Ngouda,

---

@Ngouda wrote:

1. A list or drop down menu that will load all the files in the Distraction folder. And so the user can choose the file he needs.
2. When the user chooses the file, the text and time in the file should be displayed on my front panel.
Is this possible on Labview?

---

Yes, that's possible!

1. Use a ListFolder function to get all filenames for the folder. Show those filenames in a listbox.
2. Upon ValueChange event of the listbox ("user selected an item") you can load the file and display its data…

[altenbach · Accepted solution]

Here's how to add the list to the control. Then just use the value to index into an array of file names to create the path to be read.

See how far you get. Not sure about your program and what e.g. the start/stop button is supposed to d etc.

[Ngouda]

Hi Dear @altenbach,
Yes you are right, I changed my program a bit and it works now.
I still have to read the values with the indexes as you told me.
Thank you very much 🙂

[Ngouda]

Dear GerdW,

I'm going to test this method too (2) to display the values on the front anel.
Thanks a lot to both of you:)

[Ngouda]

Hi guys,

I'm coming back to you, I really tried a lot of things but it doesn't work

How to upload the file when the user has selected a file please?

[altenbach · Accepted solution]

• First of all, don't end any of your files with MODCA. This is reserved for VIs modified by me personally.
• You cannot use "read delimited spreadsheet" for excel files (a proprietary Microsoft format!). You need to use the office toolkit (you figure it out. If you don't have office, this might help, read the entire thread). Much easier would be to export the files in excel as tab delimited text and read that using read delimited spreadsheet
• There is no need to maximize the diagram to the screen.

[Ngouda]

Hi dear @altenbach,

I like your MODCA but okay I won't pick you anymore 🙂
I thank you very much for your help and yes I will read the whole thread.
Thanks again for taking your time to help me.
Have a nice day 🙂

[altenbach]

No problem! Good luck with your programming and come back if you have another question!