java - 如何从第二行获取数据

Question

我正在尝试根据下面的标题获取数据，首先我获取第一行并将其存储在 map 中。但问题是我想从第二行获取数据，但我有迭代器。如何从第二行获取数据？

    DataFormatter df=new DataFormatter();
    Map<String,Integer> m=new HashMap<String,Integer>();
    FileInputStream file = new FileInputStream(new File("/root/Documents/xyz.xlsx"));

        //Get the workbook instance for XLS file
        XSSFWorkbook workbook = new XSSFWorkbook(file);

        //Get first sheet from the workbook
        XSSFSheet sheet = workbook.getSheetAt(0);

           Row row=sheet.getRow(0);
           XSSFRow rowe = (XSSFRow)row;
           int s=row.getLastCellNum();
           System.out.println(s);
           for(int i=0;i<s-1;i++){
               String data= df.formatCellValue(rowe.getCell(i));
               System.out.println(data);
                  m.put(data,i);
           }


      Iterator<Row> rows = sheet.rowIterator();       
        while (rows.hasNext()) {
            XSSFRow rowa = (XSSFRow) rows.next();

            System.out.println(df.formatCellValue(rowa.getCell(m.get("Member.Member Card Number"))));

        }

Answer 1

这是您要找的吗？

 int count =0;
 while (rows.hasNext()) {

            XSSFRow rowa = (XSSFRow) rows.next();
            if(count !=0){
            System.out.println(df.formatCellValue(rowa.getCell(m.get("Member.Member Card Number"))));
            }
            count++;
        }