Help reading an Excel file with Matlab

[quantumspark]

Hi everyone, this is my first post on the physics forums. I am trying to use the readtable command in Matlab to make a table from an Excel file. Matlab is still new to me so I'm running into problems a lot. When I input T = readtable('myfile.txt'), I get an error that says "? Undefined function or method 'readtable' for input arguments of type 'char'." Can anybody tell me what to do differently? I followed the Matlab instructions to the tee.

 

[jedishrfu]

It looks like readtable is a function available in the r2013b version of MATLAB. Do you know what version you have?

http://www.mathworks.com/help/matlab/ref/readtable.html

http://www.mathworks.com/help/matlab/ref/xlsread.html

and some tutorial stuff

http://blogs.mathworks.com/loren/2013/09/10/introduction-to-the-new-matlab-data-types-in-r2013b/

 

[quantumspark]

Oh, looks like I have the r2010b version. So I guess it only works in the latest version?

 

[jedishrfu]

Oh, looks like I have the r2010b version. So I guess it only works in the latest version?

if you poke around google there may be some user code to do it.

Did you try the xlsread function? it appears to be in earlier releases. Just change the name from readtable to xlsread.

 

[Office_Shredder]

If you have a text file csvread will work too.

 

[kreil]

Tables and categorical arrays are new for R2013b, so you won't be able to use them in older versions even if you use a legacy import function.

There is a catch though, if you have Statistics Toolbox. If so, you can use a dataset array from the toolbox (very similar to a table).