How can I xlswrite to a new line in an excel file?
13 次查看(过去 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)
0 个评论
采纳的回答
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:
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,
Cheers!
Abhiram.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!