excel Input with condition

2015 11 11
1 个回答
回答已采纳
更新时间：2015 11 13
1 次查看（30 天）

0 个投票

Hi everyone,
I'm gonna write an app that needs many inputs. after inserting inputs, some values will be select from some tables with many raws and columns.
for example
if material==copper then Ko=1,K1=2,K3=4 ...
else if material==aluminum then Ko=20,K1=11,K3=-9 ...
else if ...
and so on
what should I do for the best?

请先登录，再回答此问题。

 采纳的回答

Image Analyst
Image Analyst 2015-11-12

0 个投票

if strcmpi(material, 'copper')
Ko=1;
K1=2;
K3=4;
elseif strcmpi(material, 'aluminum')
Ko=20;
K1=11
K3=-9
end
That's about all we can say with what you gave us. We'd need specifics to provide any more code. There's a lot you can do with MATLAB but unless we know what it is, we can't offer advice other than to look at this link: http://www.mathworks.com/matlabcentral/answers/8026-best-way-s-to-master-matlab

7 个评论
显示 5更早的评论 隐藏 5更早的评论

Hamid
Hamid 2015-11-12
thanks my friend.
my bad I didn't explain well, my final purpose is a code that contains many inputs.
I want my inputs will be an excel file.
for example in the excel file :
material=copper
length=10
width=5
resistivity=200
...
after inserting inputs by the excel file, some values will be select from some tables with many raws and columns(conditions).
I want the tables in another excel file.
for example
if material==copper then Ko=1,K1=2,K3=4 ...
else if material==aluminum then Ko=20,K1=11,K3=-9 ...
else if ...
and so on
What is the way?
Image Analyst
Image Analyst 2015-11-12
What is the value of copper? Is it a number? Does it contain a string? If so, what is the string? If it's a string you should not be using == to compare strings. You should use the strcmp() code I gave you.
To put the data into a different file, you need to call xlswrite().
Hamid
Hamid 2015-11-13
copper is a string.
you are right.
Is there a chance to use directly table excel file in matlab file without call xlswrite()and just creating an excel file??
thanks.
Image Analyst
Image Analyst 2015-11-13
How did you assign copper? Did you do this:
copper = 'copper'
or was copper gotten from a table or cell or structure or something? Of course, you know that
material = copper;
and
material = 'copper';
are totally different things, don't you?
Yes, you can use tables as long as each column is of the the same data type. Different columns can be different data types but within a column, they must all be the same type. You can use readtable() and writetable() to read and write tables from and to Excel format .xlsx files.
Hamid
Hamid 2015-11-13
yes, I know.
copper was gotten from a table and this is what I'm gonna use in my code:
material = copper;
I haven't readtable() in 2009version.
Image Analyst
Image Analyst 2015-11-13
Tables did not exist in R2009 either. They only came into existence in R2013b. They're very useful and maybe 6 years is long enough for you to go with an old version - time to upgrade/modernize so you can use the concepts the rest of us are all talking about and using now.
Hamid
Hamid 2015-11-13
ok, thanks.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息

标签

尚未输入任何标签。

Community Treasure Hunt

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

Start Hunting!

Translated by