清空筛选条件
清空筛选条件

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

30 次查看（过去 30 天）
Al-Mansoor
Al-Mansoor 2013-4-4
编辑： Walter Roberson 2017-1-20
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 Center 和 File Exchange 中查找有关 Environment and Settings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by