Unable to read data from my excel file

1 次查看（过去 30 天）
Prajwal Venkatesh
Prajwal Venkatesh 2020-1-19
评论： Walter Roberson 2020-1-19
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
  3 个评论
显示 1更早的评论
Prajwal Venkatesh
Prajwal Venkatesh 2020-1-19
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
Walter Roberson 2020-1-19
I suggest adding import options to force the expected headers and columns.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Prajwal Venkatesh
Prajwal Venkatesh 2020-1-19
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?

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by