reading data from excel text not displayed

Question

abdul rehman 2021-12-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1614060-reading-data-from-excel-text-not-displayed

评论： Siddharth Bhutiya 2022-1-3

I want to read everything only but following code is showing 3 tables: number, text and everything. If i use only xlsread it does not read the text column. please tell me a way to read colplete excel sheet without skipping text.

filename = ' final.xlsx';

[numbers, TEXT, everything] = xlsread(filename,1)

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Voss 2021-12-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1614060-reading-data-from-excel-text-not-displayed#answer_858275

在 MATLAB Online 中打开

I believe that the variable 'everything' should have everything.

If you don't need the numeric-only and text-only outputs from xlsread, you can avoid storing them in variables, like this:

[~,~,everything] = xlsread(filename,1)

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

Siddharth Bhutiya 2022-1-3

Avoid using xlsread. Instead use more modern functions like readtable or readmatrix. These are being continuously improved to make your life a lot easier.

请先登录，再进行评论。