Remove single quotes around numeric vector
조회 수: 1 (최근 30일)
이전 댓글 표시
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,
댓글 수: 0
채택된 답변
추가 답변 (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!