xlsread doesn't read a column that contains string in the cells with unknown number of rows
조회 수: 5 (최근 30일)
이전 댓글 표시
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
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.
채택된 답변
Dimitar Georgiev
2019년 6월 20일
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:
댓글 수: 0
추가 답변 (0개)
참고 항목
카테고리
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!