How to import an excel file using a range?

2011 3 8
3 个回答
回答已采纳
3 次查看（30 天）

0 个投票

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

0 个投票

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

0 个投票

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更早的评论 隐藏 2更早的评论

Oleg Komarov
Oleg Komarov 2011-3-8
I edited my answer, do you have Win OS?
Luciano Campos
Luciano Campos 2011-3-8
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
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,

请先登录，再进行评论。

类别

在 帮助中心 和 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