您可以借助getStyle这个方法来获取当前单元格的背景色,然后借助工作表的行列数去遍历当前单元格
- var rowCount = sheet.getRowCount();
- var colCount = sheet.getColumnCount();
- for (var i = 0; i < rowCount; i++) {
- for (var j = 0; j < colCount; j++) {
- // 黄色的16进制编码为#FFFF00
- if (sheet.getStyle(i,j) && sheet.getStyle(i, j).backColor && sheet.getStyle(i, j).backColor == "#FFFF00") {
- console.log("单元格(" + i + "," + j + ")的背景色是黄色");
- }
- }
- }
复制代码
|