Unable to read data from my excel file

1 次查看（过去 30 天）

显示更早的评论

Prajwal Venkatesh 2020-1-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/500925-unable-to-read-data-from-my-excel-file

评论： Walter Roberson 2020-1-19

采纳的回答： Prajwal Venkatesh

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

3 个评论
显示 1更早的评论隐藏 1更早的评论

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 2020-1-19

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

请先登录，再进行评论。

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

采纳的回答

Prajwal Venkatesh 2020-1-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/500925-unable-to-read-data-from-my-excel-file#answer_410831

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?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Walter Roberson 2020-1-19

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

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 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