ifcommand not work

[star-andy]

I use 3.0.0 version

After I used the if statement, row A11 should not have appeared.

Is it because I'm using it in the wrong way?

This is the template for the input file.
in.xlsx
This is the out file
out.xlsx
This is test data
data.json

[star-andy]

@gastendonk @SoltauFintel I need help Rows A11 and A16 should not have been rendered. I've tried many methods, but still can't achieve the expected result.

[SoltauFintel]

Your template looks good. I can't say more at the moment.

[star-andy]

@SoltauFintel Yeah, I don't see what the problem is either. Could it be a bug?

[SoltauFintel]

Try to change the lastCell to G12 in the command of cell A6.

You could have a look at IfCommandDemo.java in this repository.

[star-andy]

this is data

{
  "buDataList": [
    {
      "internalList": [],
      "externalList": [
        {
          "projectName": "上海项目",
          "planAmount": "470400",
          "actualAmount": "470400"
        },
        {
          "projectName": "北京项目",
          "planAmount": "470400",
          "actualAmount": "970400"
        },
        {
          "projectName": "天津项目",
          "planAmount": "470400",
          "actualAmount": "470400"
        }
      ],
      "buName": "BU1"
    },
    {
      "internalList": [],
      "externalList": [
        {
          "projectName": "新项目",
          "planAmount": "470400",
          "actualAmount": "470400"
        }
      ],
      "buName": "BU2"
    }
  ]
}

this is code

public static void main(String[] args) throws Exception {
		InputStream jsonStream = new FileInputStream("D:\\test\\data.json");
		byte[] buffer = new byte[jsonStream.available()];
		jsonStream.read(buffer);
		String json = new String(buffer, "GBK");
		TypeReference<Map<String, Object>> type = new TypeReference<Map<String, Object>>() {};
		Map<String, Object> context = JsonUtil.parseObject(json, type);
		InputStream template = new FileInputStream("D:\\test\\in.xlsx");
		OutputStream result = new FileOutputStream("D:\\test\\out.xlsx");
		JxlsPoi.fill(template, JxlsStreaming.STREAMING_OFF, context, result);
	}

I tried it and it wasn't what I expected, IfCommandDemo, which I've already seen, didn't solve my problem
I don't expect there to be rows A11 and A16
Please try the test in your free time, thank you very much