I need to make a function that reads an excel file?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
studentdavid
am 7 Jun. 2016
Kommentiert: studentdavid
am 7 Jun. 2016
How do I read an Excel file into a function without hard coding it? I want to be able to put the file into the functionhandle with a predefined variable as the xlsx file, but i can't seem to make it work.
1 Kommentar
Guillaume
am 7 Jun. 2016
Can explain more clearly what you're trying to do. An example of inputs and expected outputs would be useful.
" I want to be able to put the file into the functionhandle with a predefined variable as the xlsx file". Does not make any sense to me. What function handle?
Akzeptierte Antwort
Image Analyst
am 7 Jun. 2016
How about this
function [numbers, strings, raw] = MyXlsread(filename)
numbers = [];
strings = [];
raw = [];
if exist(filename, 'file')
[numbers, strings, raw] = xlsread(filename);
else
message = sprintf('File not found:\n%s', filename);
uiwait(warndlg(message));
end
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!