how to build a gui that upload excel file and then calculate trendline acording to dates that the user wants

i got a small task for college to build a gui that upload excel file . then calculat trendline acording to specific dates the the user put in in the gui plus i need to put an option of time there...short tem lets sey a month or long term lets sey a year. so pleas can some one help me ? i need to do it in 3 days.

[Benjamin Kraus]

What have you tried so far? What version of MATLAB are you working with? Do you have any code you can provide that isn't working? The MATLAB Answers community can be very helpful, but we aren't going to do your homework for you.

[rayen chauso]

2017b. I have tried all kind of code buy so far no success. I really not that good at it. I spend more then 40 houses on it. Watch all the video on the subject. The teacher gave use some pices of general code for use as example but it did not help.

[Francheska Payongayong]

Hi, did you make your program work? I'm working on a gui that is almost the same as this. Thank you!

[rayen chauso]

Yes I have something that works :) With a lot of my friends help

[Francheska Payongayong]

May I ask how you wrote your code? I have a push button, and it creates a pop-up menu that stands as a file browser. However, when I run the program and then select a file to open it with, it doesn't work. :( My code only looks like this for the push button:

      app.Import.Enable = 'on';
            [FileName,PathName] = uigetfile({'*.xlsx'},'File Selector');

I was also hoping you could help me on how to generate a table from the excel file a user would open :( thank you for answering! :)

Answer 1

[Benjamin Kraus]

Have you searched through the doc pages? Here are a few links to help you get started:

1. App Designer
2. Ways to Import Spreadsheets
3. Create a Simple App Using App Designer

[rayen chauso]

That will be great. I did try to find any helpfully video or codes or link. The closest I saw was from dug hull he has 5 video on the subject. It's not exactly what I need but close. I did exactly like he did but still no luck.