Conditional Formatting in Excel

4 次查看（过去 30 天）

Artyom 2013-2-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/64658-conditional-formatting-in-excel

How to apply conditional formatting in Excel. Here is my code:

 file='Result.xlsx';
 data=rand(5,5);
 range='B2:E5';
 file = fullfile(pwd, file);
 Excel = actxserver('excel.application');
 wb=Excel.WorkBooks.Add();
 ran = Excel.Activesheet.get('Range',range);
 ran.value = data;
 % conditional formatting
 xlCellValue = 1;
 Excel.Selection.FormatConditions.Delete;
 Excel.Selection.FormatConditions.Add(xlCellValue,1,'0','1');
 %
 wb.SaveAs(file); 
 wb.Close;
 Excel.Quit;
 Excel.delete;