MATLAB Answers

Import File function not working?

190 views (last 30 days)
xander fong
xander fong on 15 Jul 2015
Answered: Ghada Saleh on 17 Jul 2015
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 Comment
Stephen
Stephen on 15 Jul 2015
When I search the MATLAB documentation for "importfile" I get these four results:
But there is no function called importfile. Where did you hear about this function?

Sign in to comment.

Accepted Answer

Ghada Saleh
Ghada Saleh on 17 Jul 2015
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

More Answers (0)

Community Treasure Hunt

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

Start Hunting!