MATLAB Answers

Color the particular row of the excel sheet

25 views (last 30 days)
I need to color the particular row of the excel sheet. How can i do this ?

Accepted Answer

Thomas Koelen
Thomas Koelen on 8 May 2015
Edited: Thomas Koelen on 8 May 2015
% Connect to Excel
Excel = actxserver('excel.application');
% Get Workbook object
WB = Excel.Workbooks.Open(fullfile(pwd, 'Book1.xlsx'),0,false);
% Set the color of cell "A1" of Sheet 1 to Yellow
WB.Worksheets.Item(1).Range('A1').Interior.ColorIndex = 6;
% Save Workbook
WB.Save();
% Close Workbook
WB.Close();
% Quit Excel
Excel.Quit();
Does this, ofcourse you can change all the values.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!