How to read empty row of an excel sheet with a matlab command?

1 次查看（过去 30 天）
pavan sunder
pavan sunder 2017-5-16
回答： Rik 2017-5-16
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.

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

回答（1 个）

Rik
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)

类别

在 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