MATLAB Answers

0

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

Asked by pavan sunder on 16 May 2017
Latest activity Answered by Rik
on 16 May 2017
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 Comments

Sign in to comment.

Tags

1 Answer

Answer by Rik
on 16 May 2017

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 Comments

Sign in to comment.