How to prevent xlswrite to overwrite the present values?

Hello Everyone, I have some variables which need to get copied in an excel sheet. The variables gets changed every time I execute the program.Now when I try it with the XLSWRITE it over writes the previous value, but I need to retain the previous value and need to store the new value after the previous or old value in a specific column. How to do that? It will be much helpful if we are able to store the variables in a specific columns of an excel sheet. Say for variable A i should be able to store it in A1, B in B1 etc... Thanks in advance

[Stephen23]

@Jayanta Deb: the xlswrite documentation explains exactly how to do this.

Did you read the documentation?

[Jayanta Deb]

Hi Stephen, Yes I read, but cant see the appropriate solution. I am able to get the data in my excel but when i again run the script the newly obtained data over writes the previous value which should not be the case. thanks :)

[Walter Roberson]

Give a different xlRange option the next time.

Notice the hint:

If you do not specify sheet, then xlRange must include both corners and a colon character, even for a single cell (such as 'D2:D2'). Otherwise, xlswrite interprets the input as a worksheet name (such as 'D2').

Answer 1

[Walter Roberson]

https://www.mathworks.com/help/matlab/ref/xlswrite.html

"xlswrite(filename,A,xlRange) writes to the rectangular region specified by xlRange in the first worksheet of the workbook. Use Excel range syntax, such as 'A1:C3'."