input_file_name returns empty string about spark-excel HOT 6 CLOSED

Does the same code work with other DataFrames?

from spark-excel.

I've tested the same code using multiple xls and xlsx files, same empty string result every time. Using other formats like csv results in the expected result.

from spark-excel.

TBH I don't have any idea how input_file_name is supposed to work. Can you dig out the corresponding documentation and maybe some code examples what one has to do to make it work?
Maybe you can find the corresponding code in the CSV package.

from spark-excel.

Closing this due to inactivity.

from spark-excel.

Hi, I too face the same issue, the input_file_name() return empty when used with this.

example how this is supposed to work.

file_read = spark.read.option("header","true").csv(blob_location)
file_loc = file_read.withColumn("file_loc",input_file_name())
display(file_loc)

result:
col1 | col2 | file_loc
merin | 25 | wasbs://[email protected]/folder/file.csv

So this will give full path name of the file processed. But when using spark excell, the file path return empty.

from spark-excel.

See above:

TBH I don't have any idea how input_file_name is supposed to work. Can you dig out the corresponding documentation and maybe some code examples what one has to do to make it work?
Maybe you can find the corresponding code in the CSV package.

from spark-excel.