How to let the user input an excel file (i.e .csv file) and array in MATLP APP Designer

Hello,

I am trying to design Matlab App Designer. I want my user to input an excel file and arrays. Is that possible? If yes, please help how to do it or share a reference that would help me.

Thanks

[Cameron]

Yes it is possible, but your question is fairly open ended. What specifically do you want to do? Do you want to push a button and insert an Excel file? I'm also not sure what you mean by input arrays unless you mean using Excel to input an array.

Answer 1

[Kevin Holly]

Attached are two examples of apps opening Excel files.

[Kevin Holly]

If you want the user to manually input an array within the app, you can create text editfields in your app.

[Othman Alkandri]

Thank you a lot for your help. I have some things I want to ask about, please.

1- When I tried to run the LoadingEcellTable.APP

I am getting the error "Undefined function 'TableConverter' for input arguments of type 'table'" did you have the same issue when you ran the code?

2- When I run the second file LoadandPlotEcellData

it loads everything perfectly and puts t in the table, but it does not plot the data when I click the push button.

3- Can I change the code from .xls to .csv and work with .csv files?

[Kevin Holly]

1. I have attached the required file. I made this app to answer someone's else question. For your application, I would pay attention to the readtable function to import your data.
2. Your data didn't meet the if condition that are found in the "Generate Plot" pushbutton's callback function. You can edit this callback in App Designer by right clicking the "Generate Plot" button while in the Design View and select Go to GeneratePlotButtonPushed callback.
3. Yes, readtable accepts .csv files

Let me know if you have additional questions.

[Othman Alkandri]

Thanks