A1"): print("writing df to temp dir as xlsx file") df.coalesce(1).write.format("com.crealytics.spark.excel").option( "dataAddress", sheetName ).option("header", "true").option("dateFormat", "yy-mm-dd").option( "timestampFormat", "yyyy-MM-dd HH:mm" ).mode( "overwrite" )...