java - excel 中一列的最后一行使用 POI for selenium-java

Question

我遇到的情况是需要找到特定列的最后一行。这与查找工作表的最后一行不同，因为它必须是特定的列。因此，为了清楚起见，我想获取 Header1 列的最后一行。

希望有人之前已经这样做过并分享给我。

enter image description here

Answer 1

    String SAMPLE_XLSX_FILE_PATH = "./GoogleAnalyticsevent.xlsx";
    // Creating a Workbook from an Excel file (.xls or .xlsx)
    Workbook workbook = WorkbookFactory.create(new File(SAMPLE_XLSX_FILE_PATH));
    // number of sheets in the Workbook
    System.out.println("Workbook has " + workbook.getNumberOfSheets() + " Sheets : ");
    // Sheet at index zero
    for(int i=1;i<workbook.getNumberOfSheets();i++) {
        Sheet sheet = workbook.getSheetAt(i);
        for (int colnum=0;colnum<sheet.getLastRowNum();colnum++){
            // Create a DataFormatter to format and get each cell's value as String
            // System.out.print(sheet.getRow(j).getCell(1) + "\n");

            // Closing the workbook
            workbook.close();
        }

    }

您可以更改colnum并获取您的列和sheet.getLastRowNum()将返回您最后一个单元格编号