java excel获取行号_在使用java的excel xssf文档中找到文本并获取单元格索引，即[行号和列号]是否可行？...

以从那里的代码，您的需要，我们得到：

String toFind = "needle in haystack";

Workbook wb = WorkbookFactory.create(new File("input.xlsx"));

DataFormatter formatter = new DataFormatter();

Sheet sheet1 = wb.getSheetAt(0);

for (Row row : sheet1) {

for (Cell cell : row) {

CellReference cellRef = new CellReference(row.getRowNum(), cell.getColumnIndex());

// get the text that appears in the cell by getting the cell value and applying any data formats (Date, 0.00, 1.23e9, $1.23, etc)

String text = formatter.formatCellValue(cell);

// is it an exact match?

if (toFind.equals(text)) {

System.out.println("Text matched at " + cellRef.formatAsString());

}

// is it a partial match?

else if (text.contains(toFind)) {

System.out.println("Text found as part of " + cellRef.formatAsString());

}

}

}