Import File function not working?
34 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
xander fong
le 15 Juil 2015
Réponse apportée : Ghada Saleh
le 17 Juil 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 commentaire
Stephen23
le 15 Juil 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?
Réponse acceptée
Ghada Saleh
le 17 Juil 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
0 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!