I'm trying to open an existing Excel file, add data, then save the file. I've tried several different variations on saving the file, but I'm not having any luck. Code chunk:
%%Open Existing File & Activate / Re-name Sheet 3
hExcel = actxserver('Excel.Application'); hWorkbook = hExcel.Workbooks; invoke(hWorkbook,'Open',filename_ext); %%filename_ext -- existing file
Sheets = hExcel.ActiveWorkBook.Sheets; hSheet = get(Sheets,'item',3); hSheet.Activate; hSheet.Name = 'CYCLE'; %%Add Data & Formatting
%%<etc>
%%Save File & Close
% hWorkbook.SaveAs(filename_ext); %%V1
% hWorkbook.Saved = 1;
% hWorkbook.Save %%V2
% invoke(hWorkbook,'Save',filename_ext); %%V3
hWorkbook.Close hExcel.Quit hExcel.delete
The differet save methods above give a variety of different error outputs.
* hWorkbook.SaveAs(filename_ext); Cannot find an exact (case-sensitive) match for 'SaveAs' The closest match is: saveas in C:\Program Files\MATLAB\R2012a\toolbox\matlab\general\saveas.m * hWorkbook.Save No appropriate method, property, or field Save for class Interface.000208DB_0000_0000_C000_000000000046. * invoke(hWorkbook,'Save',filename_ext); Error using Interface.000208D8_0000_0000_C000_000000000046/invoke Invoke Error: Unknown name or named argument
In another code section I've used the above SaveAs format (when I'm creating a new file–not adding data to an existing file)without issue, so I'm uncertain on how to correct the issue.
Any help would be appreciated.
Best Answer