How to import an excel file using a range?

3 次查看（过去 30 天）
Luciano Campos
Luciano Campos 2011-3-8
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,

请先登录，再回答此问题。

采纳的回答

Oleg Komarov
Oleg Komarov 2011-3-8
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

更多回答（2 个）

Luciano Campos
Luciano Campos 2011-3-8
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,
  4 个评论
显示 2更早的评论
Oleg Komarov
Oleg Komarov 2011-3-9
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
Luciano Campos 2011-3-9
Thanks Oleg,
I really appreciate your help.
Best,

请先登录，再进行评论。

Luciano Campos
Luciano Campos 2011-3-8
I've got a Mac OS X 10.5.8
thanks,

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by