Manipulate Excel From Matlab

2011 10 7
1 个回答
回答已采纳
4 次查看（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 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by