java - 如何根据Java中前一行的组大小值跳过行

Question

我无法跳过下一行第 2 行（如果第 1 行中的组大小为 2）

S.No    title_rcd   passenger_type_rcd  YoungestGroupMember GroupSize   
1   MRS ADULT   ADULT   2   Same Group
2   MR  ADULT   ADULT   2   
3   MR  CHILD   CHILD   1   Unique
4   MR  ADULT   ADULT   1   Unique
5   MR  ADULT   ADULT   2   Same Group
6   MR  INF INF 2   

代码：

for(int r=2;r<=NumberofRows;r++){

    String  getGroupSize=xlsx.getCellData(SheetName, "GroupSize", r);
    float GroupSize=Float.parseFloat(getGroupSize);
    int ActualGroupSize=(int) GroupSize;
    System.out.println("Number of Pax in Row number "+r+" is "+ActualGroupSize);
    ActualGroupSize=nextrow;

预期的

Number of Pax in Row number 1 is 2
Number of Pax in Row number 3 is 1
Number of Pax in Row number 4 is 1
Number of Pax in Row number 5 is 2

如何跳过第 2 行和第 6 行。目前使用上述代码正在从所有行中获取值。

标签： javaseleniumselenium-webdriverautomated-tests

Answer 1

也许这可能有效：

        int lastgroupsize = 0;
    for(int r=2;r<=NumberofRows;r++){

        String  getGroupSize=xlsx.getCellData(SheetName, "GroupSize", r);
        float GroupSize=Float.parseFloat(getGroupSize);
        int ActualGroupSize=(int) GroupSize;
        if(lastgroupsize < 2 || (lastgroupsize >= 2 && ActualGroupSize < 2)) {
            System.out.println("Number of Pax in Row number "+r+" is "+ActualGroupSize);
        }
        lastgroupsize = ActualGroupSize;
        ActualGroupSize=nextrow;