MATLAB: How to load files(xls, xlsx, etc.) in the current directory to the workspace

loadworkspace

I have a file named dataset.xlsx and now I want to load it on my workspace instead of click the "import data" button. I tried to use the load method but it cannot work, and the error showed that "Error using load.Unable to read file 'dataset.xlsx'. Input must be a MAT-file or an ASCII file containing numeric data with same number of columns in each row"
load('dataset.xlsx');

Best Answer

load() function is for MAT file or ASCII file;
For Excel workbook, you can use readcell, readtable or readmatrix according to your data and output format.
Related Question