How can I save a workbook compatible with older version of Microsoft Excel using ACTXSERVER in MATLAB 7.4 (R2007a)?
3 views (last 30 days)
Show older comments
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.
Accepted Answer
MathWorks Support Team
on 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 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!