Unable to read data from my excel file
2 views (last 30 days)
Show older comments
Prajwal Venkatesh
on 19 Jan 2020
Commented: Walter Roberson
on 19 Jan 2020
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![Screenshot (293).png](https://www.mathworks.com/matlabcentral/answers/uploaded_files/262420/Screenshot%20(293).png)
![Screenshot (293).png](https://www.mathworks.com/matlabcentral/answers/uploaded_files/262420/Screenshot%20(293).png)
![Screenshot (292).png](https://www.mathworks.com/matlabcentral/answers/uploaded_files/262421/Screenshot%20(292).png)
3 Comments
Walter Roberson
on 19 Jan 2020
I suggest adding import options to force the expected headers and columns.
Accepted Answer
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!