how splitting data in one column into two column in EXCEL file by MATlab?
조회 수: 2 (최근 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)];
댓글 수: 0
답변 (1개)
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.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!