Does .save work correctly for Excel object in Excel 2010?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaire
Gnaneswar Nadh satapathi
le 27 Juin 2014
use: save('fimename.xlsx',yourvariable) it needs only Excel to be installed in your system. it might be 2003/2010
Réponse acceptée
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!