Extracting a specific number from an excel cell

5 次查看（过去 30 天）

doublebi 2019-6-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/465861-extracting-a-specific-number-from-an-excel-cell

评论： doublebi 2019-6-7

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Akira Agata 2019-6-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/465861-extracting-a-specific-number-from-an-excel-cell#answer_378193

在 MATLAB Online 中打开

yourExcel.xlsx

How about the following?

[~,~,C] = xlsread('yourExcel.xlsx');
C = extractBetween(C,'(',')');
C = extractAfter(C,' ');
data = str2double(C);

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

doublebi 2019-6-7

Thank you, it works! :)

请先登录，再进行评论。

类别

Computational Finance Spreadsheet Link Data Import from MATLAB

在 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!

Translated by