How to read empty row of an excel sheet with a matlab command?
6 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (1)
Rik
am 16 Mai 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 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!