Export data from matlab to excel file

I'm creating a function that takes arguments in matlab. I already have a excel file with names and numbers but i want to change the number for and want matlab to write over the old number how do I write the function so that it overwrites the right field in the excel file? I don't want to name the field in the function since the function should work for any of the names....

[Image Analyst]

Explain your edit on June 17 - I don't know what you changed.

Answer 1

[Mahdi]

You can use the xlswrite built-in MATLAB function and specify the file you want to write and the column/row where it should write a value.

[Lisa]

Yes, I have tried to use the xlswrite function and then specifying the range with xlRange. But the problem is I don't know how to specify the field, I want to write it to column 2 but which row it is depends on which name I put in as an argument. And by the way, how do I even use a name as an argument?

Answer 2

[Image Analyst]

You have to call xlsread() first. Then use ismember() to find out where the name occurs in the existing file. Then use the third argument in xlswrite() to write the data to the particular cell where it needs to go.

[Lisa]

when i run the file like get the error "Undefined function or variable. How do I make it work with a name as an argument?

[BSantos]

I believe you may need to pass your variable as a string.

[Image Analyst]

Correct. And also you need to use the output of ismember to find out what row 'Eric' resides at. You're also not using xlsread() or xlswrite() correctly. Please look at the help for those functions, plus ismember(), to find out how to do it. I can tell that you have not done that yet or you would not have code that looks anything like that. Also, newbalance is not defined. You didn't pass it in, or define it in the ChangeNumber() function.