Filter löschen
Filter löschen

Exporting from matlab to excel with macro?

2 Ansichten (letzte 30 Tage)
Matija Kosak
Matija Kosak am 6 Jul. 2018
Beantwortet: Guillaume am 6 Jul. 2018
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 Kommentar
Aarti Dwivedi
Aarti Dwivedi am 6 Jul. 2018
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.

Melden Sie sich an, um zu kommentieren.

Akzeptierte Antwort

Guillaume
Guillaume am 6 Jul. 2018
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');

Weitere Antworten (0)

Kategorien

Mehr zu Data Export to MATLAB finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by