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

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.

Answer 1

[Rik]

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)