Extracting a specific number from an excel cell
5 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
doublebi
el 6 de Jun. de 2019
Comentada: doublebi
el 7 de Jun. de 2019
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 comentarios
Respuesta aceptada
Akira Agata
el 6 de Jun. de 2019
How about the following?
[~,~,C] = xlsread('yourExcel.xlsx');
C = extractBetween(C,'(',')');
C = extractAfter(C,' ');
data = str2double(C);
Más respuestas (0)
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!