Automation Matlab_Excel
Ältere Kommentare anzeigen
Hello,
is it possible to create an Excel file via Automation with xlsm extension? If yes, how ?
I am only able to create an xlsx file (cf below).... but I need to execute macro in Excel so xlsm is essential...
Thank you
% clear all
% clc
%% Ouverture d'Excel via Automation (pour intéragir entre matlab et excel)
Excel = actxserver ('Excel.Application');
% Excel.Visible = true ;
%Création et enregistrement d'un classeur
nom_fichier = input('\nName?\n','s');
xlspath = pwd ;
xlsfile = nom_fichier;
Workbook = Excel.Workbooks.Add ;
Workbook.SaveAs(fullfile(xlspath,xlsfile));
Antworten (0)
Kategorien
Mehr zu Spreadsheets finden Sie in Hilfe-Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!