How can I save a workbook compatible with older version of Microsoft Excel using ACTXSERVER in MATLAB 7.4 (R2007a)?
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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.
Réponse acceptée
MathWorks Support Team
le 27 Juin 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 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!