I need to make a function that reads an excel file?

1 Ansicht (letzte 30 Tage)
studentdavid
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
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?

Melden Sie sich an, um zu kommentieren.

Akzeptierte Antwort

Image Analyst
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)

Community Treasure Hunt

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

Start Hunting!

Translated by