AnytoDouble.scala

AnytoDouble.scala

// this flavour is pure magic...
def toDouble: (Any) => Double = { case i: Int => i case f: Float => f case d: Double => d }
  
// whilst this flavour is longer but you are in full control...
object any2Double extends Function[Any,Double] {
  def apply(any: Any): Double = 
    any match { case i: Int => i case f: Float => f case d: Double => d }
}

// like when you can invoke any2Double from another similar conversion...  
import java.time.{LocalDate, ZoneId}
object any2LocalDateExcel extends Function[Any,LocalDate] {
  def apply(any: Any): LocalDate =
    LocalDate.ofEpochDay(0).plusDays(any2Double(any).intValue-25569)
}

// and again...
import java.util.Date
object any2DateExcel extends Function[Any,Date] {
   def apply(any: Any): Date =
    Date.from(any2LocalDateExcel(any).atStartOfDay(ZoneId.systemDefault()).toInstant())