java如何在ApachePOI中不使用公式单元格获取行数据

Question

我正在开发一个程序，其中excel工作表中的行数据应显示为输出。一个id作为输入，它将映射到特定行以显示输出。我正在java上使用ApachePOI来编写代码。我想在不使用我当前在prog中使用的单元格的情况下显示输出。是否有任何函数可以直接打印行对象的行数据

 package exceldata;
 import org.apache.poi.ss.usermodel.*;
 import org.apache.poi.xssf.usermodel.XSSFWorkbook;

 import java.io.File;
 import java.io.FileInputStream;
 import java.io.FileNotFoundException;
 import java.io.IOException;
 import java.util.*;

 public class exceldata {

 private static final String FILE_NAME = "C:\\Users\\agandiko\\Desktop\\data.xlsx";

    public static void main(String[] args) {

        try {System.out.println("Enter the id:");
            Scanner s=new Scanner(System.in);
           String field=s.next();
           int on=0;
           int n=0;
           int cc=1;
            FileInputStream excelFile = new FileInputStream(new File(FILE_NAME));
            Workbook wb = new XSSFWorkbook(excelFile);
            DataFormatter formatter = new DataFormatter();
             for (int i = 0; i < wb.getNumberOfSheets(); i++) {
                 System.out.println();
                 System.out.println();
                 System.out.println("Data for Sheet"+" "+(i+1)); 
                 System.out.println("-----------------------------------");
                 System.out.println();
                 System.out.println();
            Sheet datatypeSheet = wb.getSheetAt(i);
            Iterator<Row> iterator = datatypeSheet.iterator();
            int noOfColumns = datatypeSheet.getRow(0).getPhysicalNumberOfCells();
            while (iterator.hasNext()) {

                Row currentRow = iterator.next();
                Iterator<Cell> cellIterator = currentRow.iterator();

                while (cellIterator.hasNext()) {

                    Cell currentCell = cellIterator.next();
                    Cell k=currentCell;
                    //getCellTypeEnum shown as deprecated for version 3.15
                    //getCellTypeEnum ill be renamed to getCellType starting from version 4.0
                    String val=formatter.formatCellValue(currentCell).toString();

                     if((val.equals(field)))
                     {
                         while(cellIterator.hasNext()){
                    if(cc==1){System.out.print(formatter.formatCellValue(k).toString()+"  ");}
                    else{currentCell = cellIterator.next();System.out.print(formatter.formatCellValue(currentCell).toString()+"  ");}

                         cc++;
                         }

                       // System.out.print(currentRow.toString()+"  ");
                       // currentRow = iterator.next();
                       // cellIterator = currentRow.iterator();
                       // on=1;n++;}

                          //System.out.println(cc);
                }

               // if(n==noOfColumns){System.out.println();n=0;}

               //on=0;


            }

        cc=1;   }
             }
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }

    }

}

Answer 1

以下是我对用例的理解：查找某个id（代码假定它位于每张表的第一列），如果它与输入的id匹配，则打印整行；下面是解决这个问题的方法（取决于工作表中的数据，可能需要添加一些空检查，但通常它“按原样”工作）：

public static void main(String[] args) throws IOException {

        System.out.println("Enter the id:");
        Scanner s = new Scanner(System.in);
        String id = s.next();

        FileInputStream excelFile = new FileInputStream(new File(FILE_NAME));
        Workbook wb = new XSSFWorkbook(excelFile);
        DataFormatter formatter = new DataFormatter();
        for (int i = 0; i < wb.getNumberOfSheets(); i++) {
            System.out.println();
            System.out.println();
            System.out.println("Data for Sheet" + " " + (i + 1));
            System.out.println("                 -");
            System.out.println();
            System.out.println();
            Sheet datatypeSheet = wb.getSheetAt(i);
            Iterator<Row> iterator = datatypeSheet.iterator();

            while (iterator.hasNext()) {
                Row currentRow = iterator.next();
                if(id.equals(formatter.formatCellValue(currentRow.getCell(0)))) {
                    currentRow.cellIterator().forEachRemaining(c -> System.out.print(formatter.formatCellValue(c) + " "));
                }
            }
        }
        wb.close();
        s.close();
}