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

2 views (last 30 days)
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 Comment
Gnaneswar Nadh satapathi
Gnaneswar Nadh satapathi on 27 Jun 2014
use: save('fimename.xlsx',yourvariable) it needs only Excel to be installed in your system. it might be 2003/2010

Sign in to comment.

Accepted Answer

Image Analyst
Image Analyst on 27 Jun 2014
It works fine for me. Try
objExcel.ActiveWorkbook.Save();
  1 Comment
ES
ES on 30 Jun 2014
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!

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!