Remove single quotes around numeric vector

조회 수: 1(최근 30일)
Chaimaa El
Chaimaa El 2022년 6월 20일
댓글: Chaimaa El 2022년 6월 20일
Hey,
I am using readcell to read some specific cells from an excel file, except that to specify the range I am using a four element numeric vector:
Example: X=readcell('C:\Users\pc\Desktop\MyFile.xlsx','Sheet',1,'Range',[752 4 752 4]); ==> X gets the content of the cell D752
And since that I have a large file and I want to read many cells that belongs to the same row but not the same columns, I am using the following loop:
for i=2:numel(MTnumbers)
if MTnumbers{1,i}==Machine{1,1}
RangeVector=sprintf('[752 %d 752 %d]',i,i); X=readcell('C:\Users\pc\Desktop\MyFile.xlsx','Sheet',1,'Range',VectorRange);
end
end
But this is not working because:
RangeVector='[752 2 752 2]' , while that the range value should not be between single quotes in readcell.
How can I remove the single quotes around the numeric vector? Do I have to use another function rather than sprintf?
Thank you,

채택된 답변

Stephen23
Stephen23 2022년 6월 20일
편집: Stephen23 2022년 6월 20일
"Do I have to use another function rather than sprintf?"
Get rid of SPRINTF(), converting to character does not help you:
RangeVector = [752,i,752,i]; % basic MATLAB numeric vector
  댓글 수: 1
Chaimaa El
Chaimaa El 2022년 6월 20일
It's working. Thank you so much!

댓글을 달려면 로그인하십시오.

추가 답변(0개)

제품


릴리스

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by