Exporting from matlab to excel with macro?

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?

[Aarti Dwivedi]

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.

Answer 1

[Guillaume]

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');