Reading microsoft excel spreadsheets not within the 'Current Folder' directory in Matlab working environment?
30 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
I am familiar with the xlsread functions, however I understand the file must be within the current path/folder that matlab is working in. Is it possible to load spreadsheet data from a random location on the drive using the load command? I have come accross the uigetfile function which is useful since I have just started working with GUIs (GUIDE etc):
[filename1, pathname1, FilterIndex] = uigetfile;
When I load the data would it matter to us the path or filename?
Thanks for any advice, Al
0 comentarios
Respuestas (1)
Srinivas
el 4 de Abr. de 2013
you can give your full path in xlsread some thing like this
data = xlsread('C:\Users\username\myfile.xlsx')
2 comentarios
Jordan Andersen
el 20 de En. de 2017
Editada: Jordan Andersen
el 20 de En. de 2017
Be sure there are no spaces in your file path as MATLAB recognises the space character as a break in a command. It's a good habit to always use an underscore instead of a space when naming data files from the start.
e.g. data = xlsread('C:\Users\username\my_file.xlsx') instead of ('C:\...\my file.xlsx')
Walter Roberson
el 20 de En. de 2017
Editada: Walter Roberson
el 20 de En. de 2017
Spaces within quoted strings do not terminate commands (except indirectly; you have to be careful if you use dos() or system() or unix() )
Historically, though, some Simulink related toolboxes had problems with directories that had spaces or special characters in the name.
Ver también
Categorías
Más información sobre Environment and Settings 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!