How can I xlswrite to a new line in an excel file?
조회 수: 35(최근 30일)
I want to write an array to a new line in my excel document instead of overwriting previous lines in my excel document. Is there a way to do that? I just want it to jump a line. Note( I don't know what line I want it to write to, I just want the code to find the previous line in the excel doc and them simply write to the next one)
Abhiram Bhanuprakash 2015년 5월 20일
Hello Dr. ARK,
I see two approaches to solve this issue:
1. You can use xlsread to read in the existing data in the Excel file into MATLAB, append the data to the existing data, and then overwrite the entire data using xlswrite.
But, this is a costly approach if you have to do this too many times, because this would involve launching and shutting down Excel each time you use xlswrite.
You can go for ActiveX commands, but this would require you to learn usage of these commands, and the whole purpose of using MATLAB would be defeated.
Check related threads:
b. ML Answers
2. You can go for this file submission 'XLSAPPEND' on MATLAB Central:
The authors of that file claim that it REQUIRES ONLY ONE CALL TO THE EXCEL ACTXSERVER, so the overhead is less than for successive xlsread/xlswrite calls.
Hope this helps,