How to import an excel file using a range?

Hello, I have a Student version of Matlab and I would like to import an excel file using a range and I can not do it because I´m in a basic mode. Please let me know how can I use the range in a case like the following:

[X,B]=xlsread('/Users/Documents/EuroAreaData.xls','Dataset','A11:F170');

Thanks for your kind assistance

Regards,

[Andreas Goser]

What's your OS?

[Luciano Campos]

I've got a Mac OS X 10.5.8

Answer 1

[Oleg Komarov]

Did you get an error saying the file was not found?

Specify the full path: 'c:\...\EuroAreaData.xls'

EDIT

from xlsread help and linking to Andreas' question in the comments to your first question: "Supported only on Windows systems with Excel software."

Oleg

Answer 2

[Luciano Campos]

Hi Oleg, this is the path:

path(path,'/Users/miguel/Documents/Sciences Po/Memoire/BayesianEstimation')

and this is the xlsread function:

[X,B]=xlsread('/Users/miguel/Documents/Sciences Po/Memoire/BayesianEstimation/Dataset.xls','Data','A70:F136');

I get no error warning. It's just that the page of the excel file is imported completely and does not respect the specific range I input in the xlsread function ('A70:F136').

Thanks a lot for your help,

Best,

[Oleg Komarov]

I edited my answer, do you have Win OS?

[Luciano Campos]

I'd like to ask you one more question please:

So with a Mac OS there's no mode other than the basic when importing excel files? Am I unable to specify a range with Mac OS?

Thanks,

[Oleg Komarov]

Unfortunately you can't specify the range on Mac OS. Here are the limitations of basic mode: http://www.mathworks.com/support/solutions/en/data/1-ZITZK/index.html?solution=1-ZITZK

[Luciano Campos]

Thanks Oleg,

I really appreciate your help.

Best,

Answer 3

[Luciano Campos]

I've got a Mac OS X 10.5.8

thanks,