How to merge cells in excel
98 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Elysi Cochin
am 27 Apr. 2017
Kommentiert: Ricardo Gutierrez
am 27 Jun. 2020
I want to merge cells A1 to E1... and give a heading with different colour and font... how to do it through matlab code....
1 Kommentar
king excel
am 28 Okt. 2018
You can merge cells or rows or columns values easily using Dose for Excel Add-In: https://www.zbrainsoft.com/excel-merge.html
Akzeptierte Antwort
KL
am 27 Apr. 2017
Bearbeitet: KL
am 27 Apr. 2017
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;
4 Kommentare
KL
am 27 Apr. 2017
then you have to change
eWorkbook = e.Workbooks.Add;
to
eWorkbook = e.Workbooks.Open(file);
where 'file' should be filename with fullpath. ('C:\file.xlsx')
Ricardo Gutierrez
am 27 Jun. 2020
Very good. But, if I want to save the file from matlab, how should I do it?
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Use COM Objects in MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!