how splitting data in one column into two column in EXCEL file by MATlab?

1 次查看(过去 30 天)
Hi , i have excel file contains address memory from : to as example : (in excel file as attached )
4c078c:4c078f
i need to put each address in seperate column please
[~,~,datx] = xlsread('C:\Users\testx.xlsx');
datadd=[datx(:,1)];

回答(1 个)

Nishant Gupta
Nishant Gupta 2019-9-13
You may use readtable in place of xlsread to read the table. To seperate lowest and highest address of each address range, use strsplit function. Then use hex2dec to convert those address in decimal format and after that you can easily store the numbers in a row vector. Finally you can use dec2hex to get the address back in hexadecimal format.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by