xlsread doesn't read a column that contains string in the cells with unknown number of rows

3 次查看（过去 30 天）

显示更早的评论

farzad 2019-6-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/468045-xlsread-doesn-t-read-a-column-that-contains-string-in-the-cells-with-unknown-number-of-rows

回答： Dimitar Georgiev 2019-6-20

采纳的回答： Dimitar Georgiev

Hi all

I am trying to read from an xlsx Excel file some rows in clumn 1 that are strings.

xlsread alone does not function

how to read all and put into a list ?

9 个评论
显示 7更早的评论隐藏 7更早的评论

Bob Thompson 2019-6-20

A conversion to what? What are you looking to do with it? all(1) is a cell class element, but all{1} is a string class, which can be used as an input for other commands, such as a file reading function.

farzad 2019-6-20

Conversion between classes But I think I'm convinced

Thank you so much

请先登录，再进行评论。

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

采纳的回答

Dimitar Georgiev 2019-6-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/468045-xlsread-doesn-t-read-a-column-that-contains-string-in-the-cells-with-unknown-number-of-rows#answer_380126

You can use readcell, for example,

example = readcell('example.xlsx','Range','A2:P5');

Now you can extract strings from the cell array.

I would recommend you to read:

https://www.mathworks.com/help/matlab/cell-arrays.html

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

请先登录，再进行评论。

类别

MATLAB Language Fundamentals Data Types Data Type Conversion

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

Community Treasure Hunt

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

Start Hunting!

Translated by