How to import an excel file using a range?
조회 수: 2 (최근 30일)
이전 댓글 표시
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
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
댓글 수: 0
추가 답변 (2개)
Luciano Campos
2011년 3월 8일
댓글 수: 4
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
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!