MATLAB: How to fill excel cell color using MATLAB command, and not by the actxserver method

cellcolorcolormapexcelMATLABprogramming

I would like to set/fill the excel color using Matlab command, I find out some commands using actxserver but i dont want to use it. So kindly let me know is there any command in Matlab to set excel cell color. Thanks in advance!!

Best Answer

There is no chance to interact with Excel without using the actxserver. So please explain, why you want to avoid this. Until further notice, I would answer:

No, there is no way.

But it works with ActiveX: https://www.mathworks.com/matlabcentral/answers/3352-how-to-set-excel-cell-color-to-red-from-matlab#answer_4983

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 set Tab color of an excel sheet using Matlab command

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;

Best Answer

Related Solutions

MATLAB: Color the particular row of the excel sheet

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

Related Question