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

1 visualización (últimos 30 días)
studentdavid
studentdavid el 7 de Jun. de 2016
Comentada: studentdavid el 7 de Jun. de 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 comentario
Guillaume
Guillaume el 7 de Jun. de 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?

Iniciar sesión para comentar.

Respuesta aceptada

Image Analyst
Image Analyst el 7 de Jun. de 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

Más respuestas (0)

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by