How to import exponent number from Excel column to MATLAB

Question

Ayush Ulhas 2022-9-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1812835-how-to-import-exponent-number-from-excel-column-to-matlab

评论： Walter Roberson 2022-9-27

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'

Thank you for any help you can provide.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Chunru 2022-9-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1812835-how-to-import-exponent-number-from-excel-column-to-matlab#answer_1061515

2powx.xlsx

x = readtable("2powx.xlsx")
x = 5×1 table
       LSB   
    _________

    {'2^-6' }
    {'2^-7' }
    {'2^-8' }
    {'2^-9' }
    {'2^-10'}
y = cellfun(@(a) sscanf(a, "%d^%d")', x.LSB, "UniformOutput", false)
y = 5×1 cell array
    {[ 2 -6]}
    {[ 2 -7]}
    {[ 2 -8]}
    {[ 2 -9]}
    {[2 -10]}
y = cell2mat(y)
y = 5×2
     2    -6
     2    -7
     2    -8
     2    -9
     2   -10
y = y(:, 1).^y(:, 2)
y = 5×1
    0.0156
    0.0078
    0.0039
    0.0020
    0.0010