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

3 次查看（过去 30 天）
vinvino
vinvino 2018-7-6
回答： vinvino 2018-7-9
I would like to color the spreadsheet tab into 'RED' or 'Green' using Matlab command.
Thanks in advance!!

请先登录，再回答此问题。

采纳的回答

vinvino
vinvino 2018-7-9
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;

更多回答（1 个）

Image Analyst
Image Analyst 2018-7-6
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.
  1 个评论
vinvino
vinvino 2018-7-9
编辑：vinvino 2018-7-9
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;

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2016b

Community Treasure Hunt

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

Start Hunting!

Translated by