how to use string in eval function

17 次查看(过去 30 天)
I'd like to use eval for this expression: sheet ='p1_Q1_test';
It works for num2str(x) but does not work for string y.
How can I use the string 'y' correctly in eval?
x = 1;
y = 'Q1';
eval(['sheet =p' num2str(x) '_' y '_final']);
A = xlsread('E:\myfolder\datasheet.xlsx', sheet);
error:
Undefined function or variable 'p1_Q1_test'.

回答(2 个)

KSSV
KSSV 2022-8-29
x = 1;
y = 'Q1';
sheet =strcat('P',num2str(x),'_',y,'_final')
sheet = 'P1_Q1_final'

Stephen23
Stephen23 2022-8-29
移动:Image Analyst 2022-8-29
"I'd like to use eval for this expression: sheet ='p1_Q1_test';"
Why write such complex code?
x = 1;
y = 'Q1';
sheet = ['p',num2str(x),'_',y,'_final']
sheet = 'p1_Q1_final'
or even better using SPRINTF:
sheet = sprintf('p%d_%s_final',x,y)
sheet = 'p1_Q1_final'
  2 个评论
Ham Man
Ham Man 2022-8-29
移动:Image Analyst 2022-8-29
Great thanks. It works nice!
Image Analyst
Image Analyst 2022-8-29
@Ham Man then please click the "Accept this answer" link to award @Stephen23 "reputation points". He'll appreciate it. Thanks in advance. 🙂

请先登录,再进行评论。

Community Treasure Hunt

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

Start Hunting!

Translated by