MATLAB: How to append a row to an excel file

appendexcelMATLABrow

How can I append a row to an Excel file?

Best Answer

This functionality is supported in MATLAB R2020a or later versions using name-value pair ('WriteMode',' Append')
For previous versions, the possible workaround is to use the name-value pair 'Range', which allows you to specify the position in the worksheet where you would like to start writing. Below is an example of how you can achieve the same. 
in2=xlsread('InputFileName.xlsx');
in3=array2table(in2);
writetable(in3,'OutputFileName.xlsx,'Range','A12:Q22')
Please note that the above name-value pair 'Range' will work only for excel files.