Importing a certain value on the cell (Excel)
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
My problem is quite specific. I would like to import a certain value on the excel cells. The problem is that cell includes both text and numbers. For example "G(function1): Expected Value=0.5" I just like to import 0.5 value from this cell to matlab. How can I do that?
1 commentaire
Stephen23
le 29 Juin 2018
"How can I do that?"
Import the text, then extract the value. What have you tried so far?
Réponse acceptée
Jan
le 29 Juin 2018
Something like this might work:
[num, txt] = xlsread(FileName, 'C5:C5');
[dum, str] = strtok(txt{1}, '=');
str(1) = [];
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!