Stuart’s MATLAB Videos

Watch and Learn

Video series: Reading Excel data into MATLAB with a GUI

Posted by Doug Hull,

10 views (last 30 days)  |   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:
Current Time 0:00
Duration 4:10
Loaded: 0%
Stream Type LIVE
Remaining Time 4:10
 
1x
  • Chapters
  • descriptions off, selected
  • en (Main), selected
    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.
    Current Time 0:00
    Duration 0:00
    Loaded: 0%
    Stream Type LIVE
    Remaining Time 0:00
     
    1x
    • Chapters
    • descriptions off, selected
    • captions off, selected
        Finally, the function needed a GUI to make it easy to view any piece of data from the file.
        Current Time 0:00
        Duration 0:00
        Loaded: 0%
        Stream Type LIVE
        Remaining Time 0:00
         
        1x
        • Chapters
        • descriptions off, selected
        • captions off, selected
             
            |
            Category: 
            Format: Video,
            Topic: Excel,
            Topic: GUI or GUIDE,
            Topic: Practical example
            • print

            See Also

            Comments

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

            Loading...
            Go to top of page