Does .save work correctly for Excel object in Excel 2010?

1 次查看（过去 30 天）
ES
ES 2014-6-27
评论： ES 2014-6-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
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

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Image Analyst
Image Analyst 2014-6-27
It works fine for me. Try
objExcel.ActiveWorkbook.Save();
  1 个评论
ES
ES 2014-6-30
Hi Image Analyst, thanks for your reply. When the amount of changes is less, the .save method works. But when the amount of changes made in the Excel after creating the COM is more, the .save runs for eternity. In Excel 2003, .save worked well irrespective of the amount changes in the Excel File. Thanks a lot for your support. Have a good day!

请先登录，再进行评论。

更多回答（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!

Translated by