How to import exponent number from Excel column to MATLAB
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a list of numbers in excel column. I am looking to extract the exponent number (+ - symbol doesn't matter)
For example, in 2^-6 => I want '6'
in 2^-4 => I want '4'
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1137410/image.png)
Thank you for any help you can provide.
0 commentaires
Réponses (1)
Chunru
le 27 Sep 2022
x = readtable("2powx.xlsx")
y = cellfun(@(a) sscanf(a, "%d^%d")', x.LSB, "UniformOutput", false)
y = cell2mat(y)
y = y(:, 1).^y(:, 2)
2 commentaires
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!