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

excelMATLABscript

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

Thanks in advance!!

Best Answer

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;

Related Solutions

MATLAB: Color the particular row of the excel sheet

% 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.

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

Best Answer

Related Solutions

MATLAB: Color the particular row of the excel sheet

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

Related Question