Any latest update on Excel binary format (Xlsb) support in Dataiku?

Hi @tinaresh

I assume DSS does not support this file type due to the underlying change in the storing format. Xlsb uses binary format instead of XML like with most other Excel files (like XLSX)

You can always use python to read xlsb files from a managed folder:

import dataiku
import pandas as pd
import io
import pyxlsb  # need to pip install pyxlsb

folder_handle = dataiku.Folder("folder_id") #replace with folder id
paths = folder_handle.list_paths_in_partition()
for path in paths:
    print(path)
    with folder_handle.get_download_stream(path) as f:
        b = io.BytesIO(f.data)
        df = pd.read_excel(b, engine='pyxlsb')
        print(df.shape)