XLSB FILES SUPPORT FOR PYSPARK

[Mrrobot2709]

Hi @nightscape can you add the funtionality to read xlsb file format in your com.crealytics.spark.excel will be very helpful .

Thanks

[nightscape]

Hi @Mrrobot2709, this is the first time I've heard of .xlsb files.
We're using @pjfanning's branch of excel-streaming-reader.
You would have to ask over there, or best create a PR which modifies/extends/duplicates this file to use a XSSFBReader instead of a XSSFReader when reading .xlsb files.

[SUMITGANGWAR]

can you suggest some other solution?
something like a jar for .xlsb

[nightscape]

I'd have to research myself, which unfortunately I don't have time to.
Please update this issue if you find sth. 👍