How to set Tab color of an excel sheet using Matlab command?

I would like to color the spreadsheet tab into 'RED' or 'Green' using Matlab command.

Thanks in advance!!

Answer 1

[vinvino]

The below command i used and it worked for me

 % Excel = actxserver('excel.application');
WB = Excel.Workbooks.Open(fullfile('Sample.xls'));
% Set the color of Sheet 1 to RED
%'Red'--> give the proper color index ex: Red = 3
%'SheetNo'--> ex: Sheetno = 1
WB.Worksheets.Item(SheetNo).Tab.ColorIndex = Red;

Answer 2

[Image Analyst]

Can you even do it in Excel? I've never done it. But if you can, just record a macro in Excel to do it, then transfer the commands to an ActiveX object in MATLAB if you're using Windows.

ActiveX demo attached.

[vinvino]

Hi Image Analst,

yes i got the solution. Thanks for the ExcelDemo.m file where i got more info. The below command i used and it worked for me

 Excel = actxserver('excel.application');
WB = Excel.Workbooks.Open(fullfile('Sample.xls'));
% Set the color of Sheet 1 to RED
%'Red'--> give the proper color index ex: Red = 3
%'SheetNo'--> ex: Sheetno = 1
WB.Worksheets.Item(SheetNo).Tab.ColorIndex = Red;