How to pass the name of a file to a function - dataset

1 view (last 30 days)
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

Accepted Answer

Sean de Wolski
Sean de Wolski on 7 Dec 2012
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

More Answers (1)

Diego
Diego on 7 Dec 2012
Thank you Sean.
Regards,
Diego

Products

Community Treasure Hunt

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

Start Hunting!