Remove single quotes around numeric vector

2 views (last 30 days)
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,

Accepted Answer

Stephen23
Stephen23 on 20 Jun 2022
Edited: Stephen23 on 20 Jun 2022
"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

More Answers (0)

Products


Release

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by