需要在excel角的每个单元格中添加样式(背景色)，xlsx "version"："0.14.1"，

Question

如何基于json响应对单元格进行样式设计

json答复：

{
    "position": 0,
    "clientLocation": "XPS-Kitchen",
    "upStream": "92.772",
    "downStream": "99.829",
    "minExpUpstreamValue": "65",
    "minExpDownstreamValue": "70",
    "upsStatus": "Success",
    "dwsStatus": "Success"
},

我想显示客户的位置，上下游值，背景颜色的上下游取决于upsStatus和dwsStatus。绿色如果成功，红色如果失败，

使用以下库：

"xlsx": {
  "version": "0.14.1",
  "resolved": "https://registry.npmjs.org/xlsx/-/xlsx-0.14.1.tgz",
  "integrity": "sha512-7hjB5YuyJo1fuuzXQjwuxD8LSUzE4Rxu5ToC3fB5JSunZxGjLcgKg69bEFG9GYoxeVDx5GL0k1dUodlvaQNRQw==",
  "requires": {
    "adler-32": "~1.2.0",
    "cfb": "^1.1.0",
    "codepage": "~1.14.0",
    "commander": "~2.17.1",
    "crc-32": "~1.2.0",
    "exit-on-epipe": "~1.0.1",
    "ssf": "~0.10.2"
  }
},

Answer 1

您可以有条件地设置如下HTML元素的样式

<div [style.background]="jsonObj.upsStatus == 'Success' ? 'green' : 'red'">
</div>

在变量中需要有json对象(取决于您的逻辑)

谢谢。