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

1 次查看（过去 30 天）
Furat Alobaidy
Furat Alobaidy 2019-9-10
回答： Nishant Gupta 2019-9-13
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.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by