MATLAB: How to merge cells in excel

merge excel cells

I want to merge cells A1 to E1… and give a heading with different colour and font… how to do it through matlab code….

Best Answer

Check here .

e = actxserver('Excel.Application');
% Add a 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
eSheet1 = eSheet1.get('Range', 'A1:E1');
eSheet1.MergeCells = 1;
eSheet1.Value = 'text here';
eSheet1.Font.ColorIndex = 3
eSheet1.Font.Bold = 1;

Related Solutions

MATLAB: Manipulate Excel From Matlab

% 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;

MATLAB: Merge and Center in Excel

That's because of this line:

eSheet1 = eSheet1.get('Range', 'B1:C1');

which replace the former value of esheet1 which use to be a sheet by a range reference.

Typically with matlab, you don't have to use the get method to access excel objects. I would also recommend that you don't rely on ActiveAnything, there's no point in using ActiveWorkbook when you already have a reference to the workbook so why not use it:

e = actxserver('Excel.Application');
% Add a workbook.
eWorkbook = e.Workbooks.Open(dest);
e.Visible = 1;  %optional
%get 1st sheet of workbook
eSheet1 = eWorkbook.Sheets.Item(1); %No need to activate it
% Merge Cells for Title1
rg = eSheet1.Range('B1:C1');
rg.MergeCells = true;
rg.Value = 'Title1';
rg.Font.ColorIndex = 3;
rg.Font.Bold = 1;
rg.HorizontalAlignment = -4108;
% Merge Cells for Title2
rg = eSheet1.Range('D1:E1');
rg.MergeCells = true;
rg.Value = 'Title2';
rg.Font.ColorIndex = 3;
rg.Font.Bold = 1;
rg.HorizontalAlignment = -4108;

Best Answer

Related Solutions

MATLAB: Manipulate Excel From Matlab

MATLAB: Merge and Center in Excel

Related Question