How to merge cells in excel
98 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaire
king excel
le 28 Oct 2018
You can merge cells or rows or columns values easily using Dose for Excel Add-In: https://www.zbrainsoft.com/excel-merge.html
Réponse acceptée
KL
le 27 Avr 2017
Modifié(e) : KL
le 27 Avr 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 commentaires
KL
le 27 Avr 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
le 27 Juin 2020
Very good. But, if I want to save the file from matlab, how should I do it?
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Use COM Objects in MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!