...
实现上下箭头的JS代码参考如下:
代码块 | ||||||
---|---|---|---|---|---|---|
| ||||||
function main(spreadSheetReport) { var row = spreadSheetReport.getRowCount() - 1; var startrow = 4; for (var i = startrow; i < row; i++) { var td = spreadSheetReport.getCell(i, 7); var value = parseFloat(td.innerText.replace(",", "")); if (value >= 40) { var img = document.createElement("IMG"); img.src = "/smartbi/vision/img/alertdialog/up.gif"; td.insertBefore(img, td.firstChild); } else { var img = document.createElement("IMG"); img.src = "/smartbi/vision/img/alertdialog/down.gif"; td.insertBefore(img, td.firstChild); } } } |
...