Does .save work correctly for Excel object in Excel 2010?
1 回表示 (過去 30 日間)
古いコメントを表示
Hi, I used to run certain matlab scripts for formatting excel sheets. I use activex for accesing Excel(Office 2003) in those scripts. Now I have migrated to Excel 2010, and now the Excel Object's .save method does not seem to work. can anybody help me?
% Create COM object for the current Sheet.
objExcel=actxserver('excel.application');
objExcelW=objExcel.Workbooks;
ExcelFilePath = pwd;
objExcelF=objExcelW.Open(fullfile(ExcelFilePath, ExcelFileName));
objExcelS=objExcelF.ActiveSheet;
....
some formatting, data write operations etc using the sheet object objExcelS
....
% Delete the COM Object.
objExcelF.Save;
objExcelF.Close;
objExcel.Quit;
objExcel.delete;
The script hangs at objExcelF.Save; :(
1 件のコメント
Gnaneswar Nadh satapathi
2014 年 6 月 27 日
use: save('fimename.xlsx',yourvariable) it needs only Excel to be installed in your system. it might be 2003/2010
採用された回答
その他の回答 (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!