MATLAB: How to pass the name of a file to a function – dataset

Question

Dear all,

How can I create a function for loading an excel file into a dataset array in matlab?

I have tried something like this:

function tryB( X )
data=dataset('xlsfile',inputname(1));  
end

But I get the following error each time.

Undefined function 'tryB' for input arguments of type 'char'.

Thank you,

Diego

Answer 1

Two things:

1) Apparently the file tryB.m is not saved on your ML path. Add the folder it's in to the path

2) inputname will use the name of the variable passed in, not it's value. So instead call tryB with the filename and use X

tryB('test1.xlx')

And inside of tryB:

data=dataset('xlsfile',X);  
doc function %for more information