Results 1 to 3 of 3

Math Help - Excel to matlab

  1. #1
    Newbie
    Joined
    Apr 2010
    Posts
    2

    Wink Excel to matlab

    Hello,

    im new to matlab, so i would like somebody to help me to solve one problem.

    I have made matrixs in excel, using xlsread funcion i bring tehm to matlab.
    when i ask matlab to show me the matrix it shows me with no probelm. but when i need to do some operations with them f.e. B=A*K*A' it calculates and shows the matrix B filled with "NaN" what should i do to see the numbers??? i know that numbers are real, because i've tried it with Mathcad and i got normal numbers?
    does anybody knows what is wrong?
    thx
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by Dovilles View Post
    Hello,

    im new to matlab, so i would like somebody to help me to solve one problem.

    I have made matrixs in excel, using xlsread funcion i bring tehm to matlab.
    when i ask matlab to show me the matrix it shows me with no probelm. but when i need to do some operations with them f.e. B=A*K*A' it calculates and shows the matrix B filled with "NaN" what should i do to see the numbers??? i know that numbers are real, because i've tried it with Mathcad and i got normal numbers?
    does anybody knows what is wrong?
    thx
    More information needed, looks like some of the data in the matrix is not numeric.

    CB
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Apr 2010
    Posts
    2
    yes, there were one field empty, so that is why it showed me all Nan for all of the matrix.

    Thx
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. help in excel
    Posted in the Math Software Forum
    Replies: 1
    Last Post: May 26th 2011, 06:29 AM
  2. Importing Excel sheet into Matlab
    Posted in the Math Software Forum
    Replies: 0
    Last Post: April 20th 2011, 12:41 PM
  3. From Matlab to Excel
    Posted in the Math Software Forum
    Replies: 3
    Last Post: February 3rd 2010, 03:20 AM
  4. MATLAB excel import troubles
    Posted in the Math Software Forum
    Replies: 6
    Last Post: February 5th 2009, 07:44 AM
  5. Excel to Matlab!
    Posted in the Math Software Forum
    Replies: 5
    Last Post: May 25th 2008, 03:00 PM

Search Tags


/mathhelpforum @mathhelpforum