How to import an excel file using a range?
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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,
2 Commenti
Risposta accettata
Oleg Komarov
il 8 Mar 2011
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 Commenti
Più risposte (2)
Luciano Campos
il 8 Mar 2011
4 Commenti
Oleg Komarov
il 9 Mar 2011
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
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!