Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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)
Hi @tinaresh please feel free to utilize the Product Ideas board. The Product Ideas board is here to let you share and exchange your ideas on how to improve Dataiku. Here are some resources to help get you started:
How to suggest Dataiku ideas
Participating on the Product Ideas board
Suggest an idea
I hope this helps!