Unable to infer schema with spark read excel parser plugin

Asked May 12 '23 at 03:24

Active May 13 '23 at 16:51

Viewed 33 times

When I run the below read options to load excel file into a dataframe , it gives me below error ,

ExcelParserOptionsException: Unable to parse options: Invalid option 'inferschema', did you mean 'enforceSchema'?

Am I doing anything wrong here?

 val df = spark.read
    .format("excel")
    .option("sheetNamePattern", section.section_name)
    .option("cellAddress", section.header_start_pos)
    .option("headerRowCount", 1)
    .option("inferSchema","true")
    .option("orientation","ROW")
    .load(path)

edited May 13 '23 at 16:51

Jacek Laskowski

72,696
27
242
420

asked May 12 '23 at 03:24

karti

Does this answer your question? [Spark Option: inferSchema vs header = true](https://stackoverflow.com/questions/56927329/spark-option-inferschema-vs-header-true) – Gastón Schabas May 12 '23 at 04:11
What Spark SQL package do you use for `excel` format? – Jacek Laskowski May 13 '23 at 16:50

Unable to infer schema with spark read excel parser plugin

0 Answers0