Reading microsoft excel spreadsheets not within the 'Current Folder' directory in Matlab working environment?

12 次查看(过去 30 天)
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

回答(1 个)

Srinivas
Srinivas 2013-4-4
you can give your full path in xlsread some thing like this
data = xlsread('C:\Users\username\myfile.xlsx')
  2 个评论
Jordan Andersen
Jordan Andersen 2017-1-20
编辑:Jordan Andersen 2017-1-20
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
Walter Roberson 2017-1-20
编辑:Walter Roberson 2017-1-20
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.

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 File Operations 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by