Videos and Webinars

Reading Excel Data into MATLAB with a GUI, Part 4

From the series: Reading Excel Data into MATLAB with a GUI

Doug Hull, MathWorks

Last month we covered a lot of ground in making a GUI that would read and display Excel data. Since those videos were originally posted, I have gotten quite a few requests to expand the GUI to do some analysis. This video shows how I was able to add analysis capabilities to the GUI. We do a simple normalization of the data, but you could expand this to do more exotic calculations. For a more extensive GUI, I would add the ability to choose from many different types of calculations and to do custom analysis.

Other videos have been gathered here: https://blogs.mathworks.com/pick/category/video/ Practical example videos have been gathered here: https://blogs.mathworks.com/pick/category/practical-example/

Product Focus

MATLAB

Recorded: 28 Sep 2007

Series: Reading Excel Data into MATLAB with a GUI

Part 1 It was pretty easy to read in the data with XLSREAD.

Part 2 Once this was done, it was time to turn that script into a function so that it could be reused easily.

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

Part 4 This video shows how I was able to add analysis capabilities to the GUI.

MATLAB Video Blog

Related Videos and Webinars

Reading Excel Data into MATLAB with a GUI, Part 3

Reading Excel Data into MATLAB with a GUI, Part 2

Reading Excel Data into MATLAB with a GUI, Part 1

Building a GUI to Read, Modify and Write an Excel File,...

Building a GUI to Read, Modify and Write an Excel File,...

Building a GUI to Read, Modify and Write an Excel File,...

Building a GUI to Read, Modify and Write an Excel File,...

Technical Computing with MATLAB, Part 2: Importing from...

Saving Data from MATLAB to Excel Using a Template

Beyond Excel: Enhancing Your Data Analysis with MATLAB

Inserting Data into a Vector in MATLAB

Creating a MATLAB Function to Split a URL into Component...

Creating a MATLAB Function to Split a URL into Component...

Reading Web Pages, Part 2: Using try/catch to Handle Errors

Reading Web Pages, Part 1: Using webread

Populating a Uicontrol and Reading a Directory in MATLAB

Arduino and MATLAB: Reading Inputs and Writing Outputs

Reading Parameters from a File in MATLAB

Importing Excel Data and Fitting a Curve to It

Developing Forecast Models from Time-Series Data in MATLAB...