Extracting a specific number from an excel cell
조회 수: 4 (최근 30일)
이전 댓글 표시
Hi all!
I'm new on MATLAB and I have to extrapolate a specific data from a cell in an excel sheet, to assign it a name and put it in a new array. The problem is that I don't need all the values in the cell, but only the last one, as in the picture.
How can I do it?
Thank you!
댓글 수: 0
채택된 답변
Akira Agata
2019년 6월 6일
How about the following?
[~,~,C] = xlsread('yourExcel.xlsx');
C = extractBetween(C,'(',')');
C = extractAfter(C,' ');
data = str2double(C);
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!