Stuart’s MATLAB Videos
Watch and Learn

Video series: Reading Excel data into MATLAB with a GUI

Posted by Doug Hull, August 13, 2007

9 views (last 30 days) | 0 Likes | 104 comments

I had a chance to work with a MATLAB user that was interested in bringing her Excel data into MATLAB and plotting different variables. This was a fairly standard file format, just columns of data. It was pretty easy to read in the data with XLSREAD:

Video Player is loading.

Current Time 0:00

Duration 4:10

Loaded: 0%

Stream Type LIVE

Remaining Time 4:10

Note that three minutes into the video above, I use a neat cell mode trick that many might not know about. Once this was done, it was time to turn that script into a function so that it could be reused easily.

Video Player is loading.

Current Time 0:00

Duration 5:05

Loaded: 0.00%

Stream Type LIVE

Remaining Time 5:05

Finally, the function needed a GUI to make it easy to view any piece of data from the file.

Video Player is loading.

Current Time 0:00

Duration 13:48

Loaded: 0%

Stream Type LIVE

Remaining Time 13:48

|

Category:: Format: Video,; Topic: Excel,; Topic: GUI or GUIDE,; Topic: Practical example

Comments

To leave a comment, please click here to sign in to your MathWorks Account or create a new one.