- 5525 Views
- 1 replies
- 4 kudos
Error when reading Excel file: "org.apache.poi.ooxml.POIXMLException: Strict OOXML isn't currently supported, please see bug #57699"
Hi,I want to read an Excel "xlsx" file. The excel file has several sheets and multi-row header. The original file format was "xlsm" and I changed the extension to "xlsx". I try the following code:filepath_xlsx = "dbfs:/FileStore/Sample_Excel/data.xl...
- 5525 Views
- 1 replies
- 4 kudos
- 4 kudos
copying the data onto a newer file solved my issue. Likely issue related to files metadata!
- 4 kudos
- 12658 Views
- 4 replies
- 17 kudos
Error when reading Excel file: "java.lang.NoClassDefFoundError: shadeio/poi/schemas/vmldrawing/XmlDocument"
Hi, I want to read an Excel file by:filepath_xlsx = "dbfs:/FileStore/data.xlsx" sampleDF = (spark.read.format("com.crealytics.spark.excel") .option("Header", "true") .option("inferSchema", "false") .option("treatEmptyValuesAsNulls", ...
- 12658 Views
- 4 replies
- 17 kudos
- 17 kudos
For this dataset, I also tried binary file reading as below: xldf_xlsx = ( spark.read.format("binaryFile") .option("pathGlobFilter", "*.xls*") .load(filepath_xlsx) ) excel_content = xldf_xlsx.head(1)[0].content file_like_obj = io.BytesIO(excel...
- 17 kudos