How to read empty row of an excel sheet with a matlab command?
6 次查看(过去 30 天)
显示 更早的评论
Assume i have data within range (A2:E2) in an Excel sheet. I want to update the excel sheet with a matlab command ie whenever i run the matlab code, the data should be entered into the next empty row (ie A3 wrt to above example). Please suggest how to modify the xlswrite command so the it automatically enters the data into the next empty row whenever i run the code.
0 个评论
回答(1 个)
Rik
2017-5-16
From the documentation (type doc xlswrite):
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'.
You can use some counters to keep track of what the first empty row is, or use xlsread to find that out. (note that xlsread will generally not output empty rows and cols, that behavior is not well-documented)
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!