Import File function not working?

19 次查看（过去 30 天）
xander fong
xander fong 2015-7-15
回答： Ghada Saleh 2015-7-17
Hello, I'm trying to create a script that sucks in Excel files, and keeps selected Data from one of its multiple spreadsheet tabs. However, the import file function is not working for me. Here is what I have:
%----------------------------------------------------------------% if ~exist('initialUpload.mat', 'file') dirName = '/Users/xanderfong/Documents/TestFiles' files = dir('*.xlsx'); %list all *.xyz files files = {files.name}'; % Transpose Names data = cell(numel(files),1); % Store File Contents for i=1:numel(files) % Load file into data data{i} = importfile(files{i},'Test-Spreadsheet'); end
MATLAb returns: "Undefined function 'importfile' for input arguments of type 'char'."
  1 个评论
Stephen23
Stephen23 2015-7-15
When I search the MATLAB documentation for "importfile" I get these four results:
http://www.mathworks.com/help/search.html?qdoc=importfile&submitsearch=
But there is no function called importfile. Where did you hear about this function?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Ghada Saleh
Ghada Saleh 2015-7-17
Hi Xander,
I assume this is the function generated from the Import Data tool in MATLAB. One possible reason for this error is that you have another function shadowing this one. You can try the following command:
>> which -all importfile
This should return the paths of all functions with the name 'importfile' in MATLAB search path. If there is another function in MATLAB search path, remove it from the path and try again.
If this does not work or if you see a single output corresponding to your 'importfile' function, upload your 'importfile' function and the Excel data file so we can check what is causing the error.
I hope this helps,
Ghada

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by