Change colour of cells of an excel worksheet imported into matlab

Question

Cameron Kirk 2020-3-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/509882-change-colour-of-cells-of-an-excel-worksheet-imported-into-matlab

评论： Walter Roberson 2020-3-12

Hi Guys,

I have an excel spreadsheet that contains a table of results of correlations between variables. I would like to read this document into matlab, then use a code that will loop through the worksheet and highlight every cell that is <0.05 in the colour green (to show a significant correlation), what code would I use to do this please?

Thanks

2 个评论
显示无隐藏无

Sindar 2020-3-9

Why do you want to use Matlab for this?

(In Excel, you can use conditional formatting to do the same thing in one step)

Walter Roberson 2020-3-12

https://www.mathworks.com/matlabcentral/answers/509463-coloring-variable-cells-in-excel is pretty much the same.

请先登录，再进行评论。

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

Answer 1

Monisha Nalluru 2020-3-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/509882-change-colour-of-cells-of-an-excel-worksheet-imported-into-matlab#answer_419759

在 MATLAB Online 中打开

testing.xlsx

I have attached the excel file for the reference work.

The code below is used to color a cell in third column with values greater than 5.

m=xlsread("testing.xlsx");
% Connect to Excel
Excel = actxserver('Excel.application');
% Get Workbook object
WB = Excel.Workbooks.Open(fullfile(pwd, 'testing.xlsx'),0,false);
for i=1:numel(m(:,3))
    if m(i,3)>5
        cell="C"+num2str(i);
        % Set the color of required cell of Sheet 1 to GREEN
        %color Index for GREEN is 4 in excel
        WB.Worksheets.Item(1).Range(cell).Interior.ColorIndex = 4;
    end
end
% Save Workbook
WB.Save();
% Close Workbook
WB.Close();
% Quit Excel
Excel.Quit();