How do I deal with error truncating #REF with spark.read
I am trying to read an excel file with spark.read.format, and even using PERMISSIVE mode, its truncating the records that contains #REF! in any column
I am trying to read an excel file with spark.read.format, and even using PERMISSIVE mode, its truncating the records that contains #REF! in any column