Filter löschen
Filter löschen

Exporting from Matlab to excel with macro.

6 Ansichten (letzte 30 Tage)
Matija Kosak
Matija Kosak am 10 Jul. 2018
Kommentiert: Matija Kosak am 10 Jul. 2018
I have matrix which I have to add in excel file. Excel file looks like in picture. With StartLoft, than StartCurve, than matrix which needs to be added, than EndCurve, EndLoft, End.
In this excel I should have embedded macro file to just open excel after starting matlab code, and run macro, without adding it additionaly. Is this possible? Macro code for excel is attached.
  4 Kommentare
Matija Kosak
Matija Kosak am 10 Jul. 2018
About copyright, this macro code is available for free in DASSAULT SYSTEMES.
About previous question, I forgot to accept the answer. Difference is that I don't have embedded macro file in excel file I get, and I should have it, to have more automatic process.
Sorry for any inconvenience I caused.
Matija Kosak
Matija Kosak am 10 Jul. 2018
Maybe you know way to do this? I'd appreciate it a lot.

Melden Sie sich an, um zu kommentieren.

Akzeptierte Antwort

Guillaume
Guillaume am 10 Jul. 2018
Bearbeitet: Guillaume am 10 Jul. 2018
My advice would be to have a blank excel file that already has the macro code in it. Whenever you want to create a new file with that macro, just copy that template file and fill it with xlswrite. This is probably the easiest and most reliable way.
Otherwise, yes it is possible to insert the macro from matlab, with some restrictions. The first problem you'll face is that for many versions now, Microsoft, by default, forbids programmatic access to VB projects (where macro code resides). The only way to enable programmatic access is within excel itself, under the Macro Settings of the Trust Center (in options), you need to tick Trust access to the VBA project object model. This cannot be done programmatically
Note that enabling this setting will make you more vulnerable to viruses.
Once that is done, you need to decide where that macro should reside: in a worksheet, in the workbook, or as a VB module. The import method differs for each of these. I'm going to assume that it's in the workbook as it's the most common case. To add the content of that text file to the workbook macro:
excel = actxserver('Excel.Application');
workbook = excel.Workbooks.Open(full_path_to_your_file);
vbproject = workbook.VBProject; %Will error is trust access to the VBA project model is not enabled
workbookcomponent = vbproject.Components.Item('ThisWorkook');
workbookcomponent.CodeModule.AddFromFile(full_path_to_your_text_file);
workbook.SaveAs(full_path_as_xlsm_file, 52); %52 is xlOpenXMLWorkbookMacroEnabled
excel.Quit;
  2 Kommentare
Matija Kosak
Matija Kosak am 10 Jul. 2018
Thank you. I think I'll do it with empty excel with macro already in it.
Matija Kosak
Matija Kosak am 10 Jul. 2018
Can I maybe upload this empty file on internet, and than use it in matlab, and save it on computer? or that file should be on computer?

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (1)

Sayyed Ahmad
Sayyed Ahmad am 10 Jul. 2018
you have to use activeX in matlab to start Excel
e = actxserver('excel.application');
e.visible=1;
%%new Woorkbook
eWorkbooks = get(e, 'Workbooks');
% neuWB=Add(eWorkbooks)
%%open a Workbook
neuWB=eWorkbooks.Open('YourExcelFile.xlsm');
Now you kann start your Macro in Excel
%%makro starten
e.ExecuteExcel4Macro(['!NameOfModule.NameOfSub(' INPUT_ValuesFromMatlabInExcel ')']);
%%save your work in excel
neuWB.Save();
neuWB.Saved = 1;
neuWB.Close;
%%excel clear and close
e.Quit;
e.delete
I hope that is what you need!
cheers Ahmad
  2 Kommentare
Guillaume
Guillaume am 10 Jul. 2018
Note that this requires that the macro already exists in the workbook and that macros are enabled. In most recent versions of Excel, if you have the default security settings, unless the macro is signed, macros will be disabled.
I would not recommend lowering the security settings as macro viruses are still common.
Matija Kosak
Matija Kosak am 10 Jul. 2018
Thank you for answer.

Melden Sie sich an, um zu kommentieren.

Community Treasure Hunt

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

Start Hunting!

Translated by