spark-excel icon indicating copy to clipboard operation
spark-excel copied to clipboard

XLSB FILES SUPPORT FOR PYSPARK

Open Mrrobot2709 opened this issue 3 years ago • 3 comments

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

Thanks

Mrrobot2709 avatar Sep 01 '20 11:09 Mrrobot2709

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.

nightscape avatar Sep 02 '20 20:09 nightscape

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

SUMITGANGWAR avatar Nov 17 '23 08:11 SUMITGANGWAR

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

nightscape avatar Nov 17 '23 09:11 nightscape