MATLAB Basics: Getting started from Excel

This is one of a series of videos covering MATLAB basics. It is meant for the new MATLAB user.

This video covers how to use the import wizard to bring in files, and then use the plot tools to customize a graphic. Finally, the “save as” feature is used to get a .jpg

Video Content

Find the files here.

You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.

5 Responses to “MATLAB Basics: Getting started from Excel”

Ken Rotter replied on November 8th, 2007 at 4:25 am :

Good illustration. Thanks
The link to files is failing to connect.

Elizabeth replied on November 8th, 2007 at 4:46 pm :

Hi,

This is helpful, but I have a question along the same lines. Is there any way to import data off a website when the webpages type is text/plain? There is a top line with writing, then approximately 18 more lines of space delimited numerical text before another line of writing occurs. Is there any way to make MATLAB go in and read out the data from a website or do you have to save the data into an actual text file first?

Let me know if you can help!

Thanks

Doug replied on November 9th, 2007 at 1:42 pm :

Elizabeth,

You might be interested in the command URLREAD.

>>a = urlread(’http://www.mathworks.com’)

This will get you the source of the page, and then you can parse it as you wish. Can you point me to the specific page you are looking to read in? I would like to make an example of it.

Doug

He replied on November 18th, 2007 at 2:41 pm :

Hi Doug
HOw are you

Can you help me on how to write data to excel from matlab structure table and/or cell array

for example

I have
1)11X4 cell array
2)structure table of students with a fields of name,sex,age,scores,

my e-mail address

henitek@gmail.com

Thank u so much

Nancy replied on June 29th, 2008 at 11:27 am :

The procedure is well described, but does not allow obtain data from the second sheet, which is required to obtain as vectors columns of the first and second sheet

About

Doug Hull is an Application Engineer at The MathWorks. A MATLAB user since 1994, he gets paid to live, eat, and breathe MATLAB! This blog is dedicated to promoting the File Exchange by highlighting files and original video content.

Doug’s Pick of the Week

October 18th, 2007