How to prevent xlswrite to overwrite the present values?

2 次查看（过去 30 天）
Jayanta Deb
Jayanta Deb 2017-4-5
评论： Walter Roberson 2017-4-5
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
  3 个评论
显示 1更早的评论
Jayanta Deb
Jayanta Deb 2017-4-5
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
Walter Roberson 2017-4-5
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').

请先登录，再进行评论。

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

回答（1 个）

Walter Roberson
Walter Roberson 2017-4-5
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'."

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by