Exporting from matlab to excel with macro?

2 次查看（过去 30 天）
Matija Kosak
Matija Kosak 2018-7-6
回答： Guillaume 2018-7-6
Hi, I have matrix(200x3) I want to export in excel spreadsheet in which I already have 5 lines of text.
---
StartLoft
StartCurve
EndLoft
EndCurve
End
-----
I would like to export my matrix between StartCurve and EndLoft (that is A3 in spreadsheet), but I want for EndLoft, EndCurve, End to move down.
When I try to place matrix in A3 it just delete's EndLoft, EndCurve, End, and I want them moved down to be after Matrix. Is that possible?
  1 个评论
Aarti Dwivedi
Aarti Dwivedi 2018-7-6
https://www.mathworks.com/matlabcentral/answers/178989-open-edit-and-save-excel-file-with-matlab Have you tried the solution here? It appears to me that these two questions are similar.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Guillaume
Guillaume 2018-7-6
To achieve exactly what you want, you'd have to automate excel from matlab through actxserver. If you're familiar with excel VBA, it's fairly easy to do. If not, you have a steep learning curve ahead of you.
However, I don't see why you can't simply write your matrix, stomping over the EndLoft, EndCurve and End line, then simply write these lines after your matrix:
xlswrite(yourexcelfile, [num2cell(yourmatrix); {'EndLoft', [], []; 'EndCurve', [], []; 'End', [], []}, 'Sheet1', 'A3');

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Export to MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by