File Exchange Pick of the Week

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

Video Content

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 Excel, MATLAB Basics, Video | 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

Bob, Brett & Jiro share their favorite user-contributed submissions from the File Exchange.

Subscribe


Recent Comments

  • Zach: Hi Doug and Les, I didn’t have a lot of time to mess with this, but I did find a work-around. I plotted...
  • hamed: k
  • Les: @Zach This isn’t exactly what you are looking for but at least it puts all three parameters on the same...
  • Zach: Thanks for your suggestions Doug. I’ll give that a shot and see what happens. I’ve seen many of...
  • Doug: @Zach, I would say to use plotYYY, because that is close to what you want, but using depth as Y makes sense....
  • Doug: @Teja, I think this will work: http://www.mathworks .com/access/helpdesk /help/techdoc/ref...
  • Gify: merry christmas :) nice christmas tree! Regards, Janet Gify
  • Teja: Dear Doug Is there anyway to plot a surface from nonuniform data without meshgrid and griddata? Basically i...
  • Zach: I’m working with geophysical data, so I’d like to produce a depth profile. The y-axis would be...
  • Doug: @Ashok First, please do not use variable names that are MATLAB commands (std and mean). Second, p(j) should be...

Blog Admin

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