Manipulate Excel From Matlab

Hi

How can i merge two or more excel cells from matlab? I think is something with actxserver function.

Thanks George

Answer 1

[George]

% MATLAB Automation client example 
%
% Open Excel, add workbook, change active worksheet, 
% get/put array, save.

% First, open an Excel Server.
e = actxserver('Excel.Application');

% Insert a new workbook.
eWorkbook = e.Workbooks.Add;
e.Visible = 1;

% Make the first sheet active.
eSheets = e.ActiveWorkbook.Sheets;

eSheet1 = eSheets.get('Item', 1);
eSheet1.Activate;

% Merge Cells
eActivesheetRange = e.Activesheet.get('Range', 'A1:B1');
eActivesheetRange.MergeCells = 1;

[AwedBy Matlab]

Can these activex commands be used on an existing XLS file? And can I create a spreadsheet with merged cells and save it as an excel file from matlab, but without the edits being done in real-time in Excel, like in the above code? Thanks!