Doug’s MATLAB Video Tutorials

October 18th, 2007

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
Find the files here. Other videos have been gathered here: http://blogs.mathworks.com/pick/category/video/ Other MATLAB Basics posts have been gathered here: http://blogs.mathworks.com/pick/category/matlab-basics/

By Doug Hull

14:21 UTC | Posted in Format: Video, Level: Basic, Topic: Excel | Permalink |

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”

  1. Ken Rotter replied on November 8th, 2007 at 04:25 UTC :

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

  2. Elizabeth replied on November 8th, 2007 at 16:46 UTC :

    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

  3. Doug replied on November 9th, 2007 at 13:42 UTC :

    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

  4. He replied on November 18th, 2007 at 14:41 UTC :

    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

  5. Nancy replied on June 29th, 2008 at 11:27 UTC :

    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

Leave a Reply

Wrap code fragments inside <pre> tags, like this:

<pre class="code">
a = magic(3);
sum(a)
</pre>

If you have a "<" character in your code, either follow it with a space or replace it with "&lt;" (including the semicolon).

About

Doug Hull is a proud MathWorker who is on a mission to help you with MATLAB.

Doug's picture

Subscribe


Blog Admin

These postings are the author's and don't necessarily represent the opinions of The MathWorks.