Change colour of cells of an excel worksheet imported into matlab
58 views (last 30 days)
Show older comments
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 Comments
Sindar
on 9 Mar 2020
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
on 12 Mar 2020
https://www.mathworks.com/matlabcentral/answers/509463-coloring-variable-cells-in-excel is pretty much the same.
Answers (1)
Monisha Nalluru
on 12 Mar 2020
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();
Refer the following link:
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!