How can I save a workbook compatible with older version of Microsoft Excel using ACTXSERVER in MATLAB 7.4 (R2007a)?
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
I wish to save the Microsoft Excel workbook that I have created using ActiveX in a format which will be compatible with older versions of Microsoft Excel.
Akzeptierte Antwort
MathWorks Support Team
am 27 Jun. 2009
You can save a file in a format compatible with older versions of Microsoft Excel by using the SAVEAS method of Workbooks and specifying an input argument as in the example below:
file = 'C:\myfilename.xls';
xlswrite(file, rand(5));
myApp = actxserver('Excel.Application');
myApp.visible = 1;
workbook = myApp.Workbooks.Open(file);
workbook.SaveAs('C:\myfilename2.xls',43);
%Saves the file in a format compatible with MS Excel 95 and 97
myApp.Quit;
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets 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!