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