在scala中实现excel Loopup功能

libraryDependencies += "org.apache.poi" % "poi" % "4.1.2"
libraryDependencies += "org.apache.poi" % "poi-ooxml" % "4.1.2"

import org.apache.poi.ss.usermodel.{WorkbookFactory, DataFormatter}

object ExcelLookup {
  def main(args: Array[String]): Unit = {
    val filePath = "path/to/excel/file.xlsx"
    val sheetName = "Sheet1"
    val lookupValue = "Value1"
    val lookupColumn = 0
    val resultColumn = 1

    val workbook = WorkbookFactory.create(new File(filePath))
    val sheet = workbook.getSheet(sheetName)
    val dataFormatter = new DataFormatter()

    val rows = sheet.iterator()
    while (rows.hasNext) {
      val row = rows.next()
      val cell = row.getCell(lookupColumn)
      val cellValue = dataFormatter.formatCellValue(cell)
      if (cellValue == lookupValue) {
        val resultCell = row.getCell(resultColumn)
        val resultValue = dataFormatter.formatCellValue(resultCell)
        println(s"Lookup value: $lookupValue, Result value: $resultValue")
      }
    }

    workbook.close()
  }
}