Unable to read data from my excel file

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 information

[Walter Roberson]

readtable is not going to do a good job on that without import options that tell it how many header lines to skip.

[Prajwal Venkatesh]

it does the job for the rest of the files present in the folder and they are all the same format , just the data change in each document

What do you suggest

[Walter Roberson]

I suggest adding import options to force the expected headers and columns.

Answer 1

[Prajwal Venkatesh]

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?

[Walter Roberson]

Pass the 'sheet' option followed by the sheet name.