excel Input with condition

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?

Answer 1

[Image Analyst]

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

[Hamid]

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]

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]

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]

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]

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]

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]

ok, thanks.