Manipulate Excel From Matlab

2011 10 7
1 个回答
回答已采纳
10 次查看（30 天）

1 个投票

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

1 个投票

% 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 个评论
显示 -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 个）

类别

在 帮助中心 和 File 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