bare_java_excel.scala

final case class Loan(
  id: Int,
  balance: Double,
  loanState: String
)

val workbook = WorkbookFactory.create(i).getSheetAt(0)
val idIndex = 0
val balanceIndex = 1
val loanStateIndex = 2

val balances: Iterator[Balance] = sheet.iterator()
  .asScala
  .map(row => {
    val id = row.getCell(idIndex).toInt
    val balance = row.getCell(balanceIndex).toDouble
    val loanState = row.getCell(loanStateIndex)

    Loan(id, balance, loanState)
  })