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

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by