本帖最后由 Wilson.Zhang 于 2025-11-5 12:09 编辑
产品：GcExcel
版本：8.2.2
调研编号：GCEXCEL-11845
代码
- Workbook workbook = new Workbook();
- workbook.open("colorScale.xlsx");
- IFormatConditions fcs = workbook.getWorksheets().get(0).getUsedRange().getFormatConditions();
- IColorScale colorScale = (IColorScale) fcs.get(0);
- if (colorScale.getColorScaleCriteria() != null && colorScale.getColorScaleCriteria().getCount() > 0) {
- for (int j = 0; j < colorScale.getColorScaleCriteria().getCount(); j++) {
- final Color color = Optional.ofNullable(colorScale.getColorScaleCriteria().get(j)).map(IColorScaleCriterion::getFormatColor).map(IFormatColor::getColor).orElse(Color.Empty);
- if (color != Color.Empty) {
- colorScale.getColorScaleCriteria().get(j).getFormatColor().setColor(color);
- }
- }
- }
- Exception in thread "main" java.lang.NullPointerException
- at com.grapecity.documents.excel.internals.bn.dA.a(Unknown Source)
- at com.grapecity.documents.excel.bh.a(Unknown Source)
- at com.grapecity.documents.excel.Q.a(Unknown Source)
- at com.grapecity.documents.excel.G.getColor(Unknown Source)
- at java.util.Optional.map(Optional.java:215)
- at org.example.PlayGround.main(PlayGround.java:20)
|
