How to import an excel file using a range?
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuesta aceptada
Oleg Komarov
el 8 de Mzo. de 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 comentarios
Más respuestas (2)
Luciano Campos
el 8 de Mzo. de 2011
4 comentarios
Oleg Komarov
el 9 de Mzo. de 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
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!