Excel XLSWRITE problem (help)

15 次查看（过去 30 天）
zhixuan hong
zhixuan hong 2018-2-28
评论： zhixuan hong 2018-3-1
Hi guys , I have some variables which need to get copied in an excel sheet. The variables gets changed every time I run the GUI program. Now when I try it with the XLSWRITE it overwrites the previous value, but I need to collect all the data. How to do that? I try to search answer online but doesn't work... It will be much helpful if we are able to store the variables in a specific columns of an excel sheet. Let say for variable A ,it should be able to store it in A1, B in B1 etc... Thanks.

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

采纳的回答

Walter Roberson
Walter Roberson 2018-2-28
Pass the sheet reference to xlswrite as the third parameter and pass the range as the fourth parameter.
To check: are you using Windows with excel installed? Are you writing to xls or xlsx or are you writing to csv?
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2018-3-1
When you use readtable() pass the option 'readvariablenames', false
zhixuan hong
zhixuan hong 2018-3-1
Thank you so much ! BUT for xls or xlsx file, is it possible separate the data into 3 columns like csv form? or I can convert csv file to xls/xlsx file?

请先登录，再进行评论。

更多回答（0 个）

类别

在 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