MATLAB: Unable to read data from the excel file

importing excel data

for i=1:nfiles
datafi{i} = readtable(fullfile(testfiledir, matfiles(i).name));
end
I am reading certain excel files in my folder and certain files are read and certain files no information is read.
I get a blank table for certain excel files.
below picture shows the data that has been read from the excel file, while in the actual excel file there is a lot more informationScreenshot (293).png
Screenshot (292).png

Best Answer

I found the problem that the first sheet for this file is different than the rest.
how do i import data based on sheet name?