Manipulate Excel From Matlab

6 次查看(过去 30 天)
Hi
How can i merge two or more excel cells from matlab? I think is something with actxserver function.
Thanks George

采纳的回答

George
George 2011-10-7
% 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;
  1 个评论
AwedBy Matlab
AwedBy Matlab 2012-11-14
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!

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Use COM Objects in MATLAB 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by