How can I save a workbook compatible with older version of Microsoft Excel using ACTXSERVER in MATLAB 7.4 (R2007a)?
조회 수: 3 (최근 30일)
이전 댓글 표시
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.
채택된 답변
MathWorks Support Team
2009년 6월 27일
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
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!