本帖最后由 沉沉 于 2022-8-5 14:14 编辑
https://gcdn.grapecity.com.cn/forum.php?mod=viewthread&tid=151772在这篇帖子里面,你也问了类似问题,可以设置条件格式,也可以去遍历表单,找到符合条件的,再去设置整行颜色
- var style1 = new GC.Spread.Sheets.Style();
- var style2 = new GC.Spread.Sheets.Style();
- style1.foreColor = 'blue';
- style2.foreColor = 'green';
- for(let j = 0;j<sheet.getRowCount();j++){
- if(sheet.getValue(j,i)=='37'){ //i 表示当前体温所在列
- sheet.setStyle(j, -1, style1, GC.Spread.Sheets.SheetArea.viewport)
- }else if(sheet.getValue(j,i)=='38'){
- sheet.setStyle(j, -1, style2, GC.Spread.Sheets.SheetArea.viewport)
- }
复制代码最后附上如何设置单元格样式学习链接: http://localhost:9009/spreadjs/SpreadJSTutorial/features/cells/basic-style/purejs
|