Conditional Formatting in Excel
조회 수: 4 (최근 30일)
이전 댓글 표시
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;
댓글 수: 0
답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 ActiveX에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!