using xls read to read value from column /row in a for loop
조회 수: 4 (최근 30일)
이전 댓글 표시
Hi everyone, i have a file of binary data(i.e. 0 and 1) only as , 128rows and 128 columns. all i want is my for loop to take one row or column at time and assign its value to key_out variable, and in next iteration it moves to 2nd row or column. Right now i have this code given below, but its not working fine, i will be very glad if someone can help me.
filename = 'binary.xlsx';
sheet=1;
key_out=xlsread(filename,sheet);
key_out=sprintf('%g', key_out);
disp(key_out);
key_out= reshape(key_out, [],128);
disp(key_out);
for j=1:128
my_out= masterkey (key_out);
%two more functions will be executed here, for each 128 bits of j
end
댓글 수: 0
채택된 답변
Cris LaPierre
2020년 12월 19일
You need to specify row and column indices. Try this
for j=1:128
my_out= key_out(:,j); % extracts the jth column
end
댓글 수: 0
추가 답변 (1개)
KALYAN ACHARJYA
2020년 12월 19일
편집: KALYAN ACHARJYA
2020년 12월 19일
You can do the same without Loop also (Using Cell Array)
- Saving all Rows as key blocks
key_blocks=mat2cell(binary_data,1*ones(1,128),128);
- Or Saving all Cloumns data as key blocks
key_blocks=mat2cell(binary_data,128,1*ones(1,128));
Later you call any data from cell array using key_blocks{row/column number}
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Schedule Model Components에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!